Friday Followup For February 7, 2014

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...

Parent-Child SSIS Architecture

This is the first in a series of technical posts on using parent-child architectures in SQL Server Integration Services.  The...

What Drives Microsoft’s Data Platform Vision?

FEATURED POST BY:   Quentin Clark, Corporate Vice President, The Data Platform Group, Microsoft Corporation

If you follow Microsoft’s data platform work,...

MDX+SSAS #37–Ignore unrelated dimension or not

In Adventure Works cube 2008 or 2012, in the Dimension Usage tab, you will see that many intercepts of measure...

SQL Server Diagnostic Information Queries for February 2014

I improved the file-level latency query this month and made some other small improvements to a few other queries. Rather...

Murder in Richmond

I am about to set sail on a new venture with my next official whistle stop.  This year has been plenty full of whistle stops and I plan on...

Murder in Richmond

I am about to set sail on a new venture with my next official whistle stop.  This year has been...

Rollback DBCC CHECKDB REPAIR !

I learned something new today while I was listening to one of the courses on corruption authored by the master,...

Virtual Lab – Design and Setup

This is part of a series where I set up a virtual lab for testing and misc work. The other...

24 Hours of PASS: Business Analytics Edition videos online

On February 5, 2014 business intelligence experts took to the virtual stage for the 24 Hours of PASS: Business Analytics Edition to...