Reducing Your Storage Footprint Using SQL Storage Compress

I was asked to speak at SQL in the City in New York and Austin Texas.  I have used many...

SQLskills joining Pluralsight is a good news for all

Many can boast that they were trained by Paul and Kimberly Randal at SQLskills. That company is so highly regarded...

Stressed? Need training? Take a #SQLCruise!

I can’t tell you how many times I’ve sat in a training room, in the middle of a week long...

The MERGE statement in SQL Server

The SQL MERGE statement was introduced in SQL Server 2008 and allows you to modify data in a target table based...

This is Big Data

I’m sure some people have bigger data, but Facebook has some serious daily growth. The highlight? 500TB a day.
A day.
That’s...

“It’s Alive” - SSIS Design Patterns

I’m happy to announce that the book I’ve been working on for the past two years is complete and has...

“It’s Alive” – SSIS Design Patterns

I’m happy to announce that the book I’ve been working on for the past two years is complete and has...

Error: ACCESS DENIED on installation

Error: ACCESS DENIED on installation Generally you would get error on: >> During installation >> when try to start the sql services....

Installing SQLServer for SCCM 2012 – Some points to note on patch levels

The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)

 
 
 
 
For...

PowerShell Split-Path Bug And A Workaround

Split-Path is a cmdlet built into Windows PowerShell that returns a specific part of a path, e.g.  a parent directory...