Execute Multiple 2008/2005 SSIS Packages with a T-SQL

If you want to execute a set of SSIS packages in SQL Server 2008 or 2005, you can do this...

February #Meme15 – LinkedIn

It’s the afternoon of the 16th, and time to write my #meme15 post.  Remember, these are due on or around...

Monday Morning Mistakes: SSIS Expressions Not Evaluating Correctly

SSIS Expressions
Expressions in SSIS are great. They allow you to create dynamic values for all sorts of stuff like variables,...

PowerPivot and Market Research

This past Tuesday, February 14, I was invited to discuss how technology can be used to help analyze data for...

Spruced up query_io_reader.rb

I built a small ruby program a while back to help with two things:
 

Quickly identify what tables have the highest IO in a particular query
Learn a new language (Ruby)

 
The...

Spruced up query_io_reader.rb

I built a small ruby program a while back to help with two things:
 
Quickly identify what tables have the highest...

Spruced up query_io_reader.rb

 I built a small ruby program a while back to help with two things:

1. Quickly identify what tables have the highest IO in a particular
...

Tools to Monitor Performance of SQL Server

To gather statistical information on how a server is performing requires, you need to use operating system tools to gather...

Comparing Inline and Multi-Statement Table-Valued Functions

Table-Valued Functions. What a wonderful addition to SQL they make. They take parameters, do some work, and return a result...

Dynamic Add/Remove file in Mirroring/Logshipping

Yesterday we were having discussion on high availability feature Mirroring and Log shipping with my colleagues (Amol & Alankar) on whether...