Denali – Day 23: Data Quality Services (DQS)

Denali – Day 23: Data Quality Services(DQS)

Data intelligence vs. human intelligence: Sql server RDBMS is a database system which has data...

Plan cache in SQL Server 2008R2

I was curious to look at the effect of database options, on the SQL server plan cache.
I have restored the...

How to synchronize the data from the Production environment to Development, Testing and Staging Environments for SQL Server?

One of the most common DBA task is to synchronize data to Development, Testing, and Staging environments. Normally this is...

Marketing Ideas for Chapters & SQLSaturday

I’m part of the team putting together SQLSaturday #151 in Orlando this year, and one of the things Kendal Van...

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...