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

BIxPress 3.5–Now With More Awesome!

Pragmatic Works has now released version 3.5 of the award-winning BIxPress software! For those not familiar with BIxPress it’s a...

What happens when a SSAS Tabular model exceeds memory?

If you are using the Tabular model in SSAS, it will use the xVelocity technology to load your entire database...

SQL Server 2012 Certifications Revamped

Reprinted from my Database Weekly editorial.
Forget what you thought you knew about SQL Server certification, as Microsoft has completely redesigned...

SQLServerCentral.com Track Offered at 2012 SQL Server Connections in Las Vegas this Fall

As we have done for the last several years, SQLServerCentral.com will be offering its own track at SQL Server Connections...