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 virtual machine. We improved on part 2 to show how to set the administrator password or the computer name during installation to minimize user input. In part 3 we will take another step. It’s…


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 PowerShell cmdlets and features in Windows 8. In the previous post I explained how to create a virtual disk, apply a standard Windows Server 2008 image to it and attach the disk to a new VM….


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 anything; performance issues, architecture review or migration scenarios. If I’m at a customer site it is not always possible (or recommended) to test my solution on the production systems. And if it’s a possible bug I want to…


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 technique to speed up query processing. Recently I came across a problem where the temporary tables were causing the performance degradation. I’m not going into the different temporary tables types, there are good posts on these. I’m going…


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 working with SQL Server for almost 12 years. I have been a developer, dba and architect and last year I joined Microsoft to become a Premier Field Engineer on SQL Server. This means…


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 the demo’s and now you are ready to get things going in your own datacenter. At this point you might get to a few surprises. One of these might be to get Kerberos going for your availability…