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 that were made. The basis is a 4 node…

6

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…

0

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…

0

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 avond al geslaagd. Fijn…

0

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 on an architecture that does…

0

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 2008 R2…

2

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…

0