SSIS provides several methods to create configuration information for your ETL process. The easiest of these to implement is the XML configuration file. Additionally, it provides the easiest method to migrate and update your configuration information of the method available. I will go step by step on how you can

Looks like Perpetual Technologies may be having me put on yet another event! This one looks like it will entail a SQL Server 2008 Sneak Peak. So keep tuned to my blog and also check out events.perptech.com [http://events.perptech.com] for registration details here in the near

SQL Server 2005 uses a new T-SQL Entity called a  Common Table Expression(CTE), which can be thought of a resultant dataset that can be used within a query(SELECT,INSERT,UPDATE,DELETE or even a View). In many respects a CTE is similar to a derived table variable because

For everyone that may have attended yesterday’s presentation at CincySQL..I mentioned that I liked using the SQLCLRProject for creating and deploying my user-defined functions. Well. sorry for missing this one but it appears that on the 14th Neil has released a newer version of the project in which

Here is a ZIP file that contains the presentation files for my presentation to the CincySQL group in Jan of 2008, Enjoy! CincySQL.zip [https://www.programmersedge.com/Files/CincySQL.zip] Cheers, AJ

Here is an okay preview of some of the features they are touting for SQL Server 2008. It mirrors a lot of the Microsoft stuff we have been receiving at the office here lately. Additionally, I may be planning a SQL Server 2008 sneak peek event for here in Indianapolis

This is a pretty handy script for scripting out user permissions in SQL Server 2005. With a few modifications I was able to transform it to basically run through the databases on an instance and create a bunch of scripts for me. Grats to Narayna on this one. Narayna’s

I will be speaking at a set of free learning event seminars put on by my parent company Perpetual Technologies [http://www.perptech.com]. The events will be going on for the next couple of months and are geared towards DBAs and developers alike….so sign up at at events.

I will be speaking at CincyPASS [http://cincysql.org] on Jan 22nd, 2008. Here is a rundown of what to expect and be sure to check out their website at the link above. CincySQL Meeting Time: 6 – 8 PM Meeting Location: MaxTrain 4900 Parkway Dr Suite 160 Mason OH 45040-8429

Well, the inaugural IndyTechFest [http://www.indytechfest.org] event kicked off on Saturday as the waves of IT masses(350+) descended upon Indianapolis for a free all day event. Everything went off without a hitch and it looked like everyone was having a great time. I spent my morning and

I will be presenting at the October meeting of IndyPASS next week. The title of the presentation will be Thinking Outside the Box: Creating A Design Solution to Overcome Complex Business Needs Basically, it will be an interesting talk consisting of some of the more unique real world solutions that

The link below should take you to the powerpoint slides I used for my IndyTechFest presentation on SQL Server Database Design Best Practices for .NET developers. Please report any broken links to me and I will try to get it corrected as soon as possible…. IndyTechFest Presentation [https://www.programmersedge.

Can someone please explain to me what the benefit of using the SSMA tool to migrate Access databases is? I have looked at it on and off for a week now and don’t really see why it would be used over the simple Import feature of SQL Server 2005.

Another interesting error came up today when I was working on a project remotely using Team Foundation Server. It seems that I pulled down latest version and attempted to rebuild the application when this error popped up. ASP.NET 2.0 & “allowDefinition=’MachineToApplication'” So after some poking around

One of the most understated objects that can be used within SSIS is the variable. Variables are accessable through the variables pane within Business Intelligence Development Studio(BIDS). This pane will show you the various variable names, their scope, and also the current value of the variable as shown in

It is often necessary when working with customer data to do import routines that will input each individual customer’s data. One way whihc is often implemented in Sales is to have the individual sales personnel input their weekly prospects into a predefined Excel spreadsheet and then to send that

I have been working for the past couple of months with Analysis Services 2005 and trying to get a hold on the Many-to-Many relationships. It si a pretty simple concept when you get down to it. AS2005 takes care of the many-to-many relationship and all that is required of you

If anyone has read Jamie Thomson’s piece A Distinct Component Please! [http://blogs.conchango.com/jamiethomson/archive/2006/12/08/SSIS_3A00_-A-distinct-component-please.aspx] .. I would like to ititerate his frustration. This seems like a simple thing for the powers that be on the business intelligence end to come

Okay so it has been about a month now since the SP2 CTP for December has been released and I am still awaiting the official release of the service pack. For those of you that are uninitiated with what the service pack contains …well, the biggest thing for me is

Okay my latest book that I have had a hand is out now. Learn SQL In 24 Hours