Robert's SQL Blog

My thoughts on SQL Server, PowerShell, Azure, DevOps, Containers and Microsoft products in general

Remember to vote for your AlwaysOn Availability Groups

While visiting a customer and helping them set up AlwaysOn Availability Groups we came across a...

Author: Robert Hartskeerl Date: 04/24/2013

From 0 to SQL Demo lab in a few easy steps – Part 4

I have not been able to follow up my post for a long time. Work has to be done as well. The good...

Author: Robert Hartskeerl Date: 03/08/2013

From 0 to SQL Demo lab in a few easy steps – Part 3

In part 1 showed how you could install Windows on a virtual disk and use that disk to create a new...

Author: Robert Hartskeerl Date: 09/07/2012

From 0 to SQL Demo lab in a few easy steps – Part 2

This post is part of a series of posts about buidling a lab environment using some of the new...

Author: Robert Hartskeerl Date: 08/22/2012

From 0 to SQL Demo lab in a few easy steps – Part 1

As a Premier Field Engineer I get into a different challenge every week. These challenges can be...

Author: Robert Hartskeerl Date: 08/15/2012

Using table variables (or temp tables) to speed up… or slow down

In SQL Server you can use temporary tables to store intermediate results. This is a common used...

Author: Robert Hartskeerl Date: 07/21/2012

I got my MCM Lab result.... And I failed!

A couple of weeks ago I got the result from my SQL 2008 MCM Lab exam and I failed. I have been...

Author: Robert Hartskeerl Date: 07/06/2012

Kerberos and AvailabilityGroups - What you need to know

With the freshly released SQL Server 2012 we can put availability groups to live. You have seen all...

Author: Robert Hartskeerl Date: 03/04/2012

SQL Server 2012 RC0, A New AlwaysOn Experience

Last week RC0 for SQL Server 2012 was released. If you missed it you can find it here:...

Author: Robert Hartskeerl Date: 11/20/2011

Getting HadronCore on SQL Server 2012

One of the new features of SQL Server 2012 is AlwaysOn Availability Groups. You can think of...

Author: Robert Hartskeerl Date: 10/31/2011

Who’s the DBA Anyway? It depends.

Every now and then I get questions from DBA’s if I can tell why application Y needs sysadmin...

Author: Robert Hartskeerl Date: 10/19/2011

Using Kerberos and Windows Authentication with SQL Server

In my opinion SQL or Windows Authentication isn’t a choice. You should always use Windows...

Author: Robert Hartskeerl Date: 09/06/2011

Installing SQL Server Denali CTP3 on Windows 2008 R2 Core Edition

Denali is packed with new features. A lot of features evolve around the engine, BI, Data Quality but...

Author: Robert Hartskeerl Date: 08/24/2011

SQL Server Code Name “Denali” adds support for Managed Service Accounts

As we all know we should run our SQL services with the least privileged principle. Most of the times...

Author: Robert Hartskeerl Date: 08/22/2011