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...
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...
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...
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...
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...
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...
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...
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...
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:...
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...
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...
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...
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...
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...
Date: 08/22/2011