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

Meet Thomas Kejser in Aarhus

This is normally not a place where we advertise for events held by our friends, but today I’ll make an...

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

Demystifying SQL Server Differential Database Backups

Odd Man Out
SQL Server has three backup types. Two you have heard of and used. One, while useful, isn’t very well understood.
Let’s...

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

DBCC Cleaning CACHE – Memory

DBCC Cleaning CACHE – Memory I wanted to write this blog for quite some time, here you go, as you know...

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

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

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