Skype for Business
See all products »
Curah! curation service
Microsoft Tech Companion App
Microsoft Technical Communities
Microsoft Virtual Academy
Server and Tools Blogs
TechNet Flash Newsletter
Cloud and Datacenter
Windows Server 2012 R2
System Center 2012 R2
Microsoft SQL Server 2012 SP1
Windows 8.1 Enterprise
See all trials »
Microsoft Download Center
TechNet Evaluation Center
Microsoft Virtual Academy
Free Windows Server 2012 courses
Free Windows 8 courses
SQL Server training
MCSA: Windows 8
Windows Server Certification (MCSE)
Private Cloud Certification (MCSE)
SQL Server Certification (MCSE)
Second shot for certification
Born To Learn blog
Find technical communities in your area
For small and midsize businesses
For IT professionals
For technical support
For home users
Microsoft Premier Online
Microsoft Fix It Center
Security Bulletins & Advisories
International support solutions
Log a support ticket
Not an IT pro?
Microsoft Customer Support
Microsoft Community Forums
Robert's SQL Blog
My thoughts on SQL Server, PowerShell and Microsoft products in general
SQL Server 2012
Windows Server 2008 R2
Windows Server 2012
Browse by Tags
Robert's SQL Blog
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 this comes down to running with a domain account that’s not a member of any group. But we also want to use strong authentication mechanisms like Kerberos, so we need a domain administrator to set the...
22 Aug 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 there are also new features added to the installation process. In a previous post I already mentioned managed service accounts and in this post I will show how to install SQL Server Denali on Windows...
24 Aug 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 permissions. Or why it needs to be local admin on the SQL box, or why the database has to be named XYZ, or why no other databases are allowed on the instance, or why SQL 2000 is the only supported database...
19 Oct 2011
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: http://www.microsoft.com/download/en/details.aspx?id=28145 . One area where you will find improvements or changes is AlwaysOn Availability Groups. In this post I will step through the wizard to show you the improvements...
20 Nov 2011
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...
21 Jul 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 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 groups. If...
4 Mar 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 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 I have a broad experience...
6 Jul 2012
Getting HadronCore on SQL Server 2012
One of the new features of SQL Server 2012 is AlwaysOn Availability Groups. You can think of Availability Groups as Database Mirroring on steroids. Database mirroring is only limited to one database, one secondary and if you wanted to read off it you had to create a snapshot. And in the case of a failover...
31 Oct 2011
Remember to vote for your AlwaysOn Availability Groups
While visiting a customer and helping them set up AlwaysOn Availability Groups we came across a surprising "feature". On my laptop I had build a demo lab consisting of one domain controller, three Windows 2008R2 Core member servers with SQL 2012 SP1 installed and a full Windows 2008 R2 installation with...
24 Apr 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 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 nice to...
7 Sep 2012
Using Kerberos and Windows Authentication with SQL Server
In my opinion SQL or Windows Authentication isn’t a choice. You should always use Windows authentication unless technically impossible. The most common scenario is when the user account is not in the same domain as the SQL Instance and there is no trust relationship. Or when the server is based...
6 Sep 2011
Weer een geslaagde SQL PASS Avond
Dinsdag 4 oktober was het weer SQL PASS tijd. Ditmaal waren we weer te gast bij IVENT en niet zoals eerder in Amsterdam maar op voormalig vliegbasis Soesterberg. De officiersmess was ook de perfecte setting voor deze avond. Ik zag bekende maar ook nieuwe gezichten, zeker de nieuwe gezichten maken de...
5 Oct 2011
© 2015 Microsoft Corporation.
Privacy & Cookies