Planning the Development, Testing, Staging, and Production Environments for SQL Server part 1.

When asked about how to plan the ideal dev, test, staging and production SQL Server environments it’s easy to get...

The Tally Table and Expanding Rows

Suppose you had some data like this:
Class           Limit
————— ———–
Calculus        5
History         4
Physics         2
But what you really want is this:

Class          ...

Converting to the SSIS 2012 Project Deployment Model

The new project deployment model in SSIS 2012 is the new standard for how packages are created, configured and deployed. ...

Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)

Denali – Day 22: SQL Server Developer Tools SSDT (Aka “Juneau”)
 
As stated earlier on blog on “LocalDB” discussion, developers are involved...

Basic SSIS Equivalents to T-SQL's LIKE

There are some things that we do in one SQL Server tool, but can't seem to figure out how to do in another.  One of those for you might...

Slowing Changing Dimension (SCD) demystified – Part 3

I am wrapping up this series by finally considering the rarely used type 3 SCD.
( i.e.  in most business scenarios)
Unlike...

LinkedIn Group Recommendations-Not Quite Useful

I received an email from LinkedIn suggesting that I might find these groups useful:
 

I’m sure those map back to someone...

Basic SSIS Equivalents to T-SQL's LIKE

There are some things that we do in one SQL Server tool, but can't seem to figure out how to...

SQL Server 2008 SP3 Cumulative Update 5 Released

Microsoft has released two new Cumulative Updates for SQL Server 2008 today. The first one is SQL Server 2008 SP3...

From the Labs of SQL Prompt

I love SQL Prompt as an add-in for SSMS. The intellisense is very handy for me and I’ve gotten used...