SQLServer

How to create a SQL Server Availability Group WITHOUT an Active Directory Domain

SQL Server Availability Groups were introduced back with SQL Server 2012. They are an awesome replacement for Database Mirroring (introduced back with SQL Server 2005 SP1), but with one huge limitation: the nodes on which the replicas are hosted must be part of the same Windows cluster. This doesn’t sound that at first, but a …

How to create a SQL Server Availability Group WITHOUT an Active Directory Domain + read more

Come to SQLBits, and learn about Locking & Blocking

I’m delighted to announce that I have been chosen to present a precon about Locking & Blocking in SQL Server at SQLBits on May 5 in Liverpool/United Kingdom. As you might know I really enjoy talking about locking & blocking, because it’s one of my specialities. And I’m also already a veteran (with almost no …

Come to SQLBits, and learn about Locking & Blocking + read more

Announcing the *brand new* SQLpassion Briefings and new SQLpassion Workshops

Wow, time flies by. Over the last 3 months I was almost all the time on the road, traveling around the world, speaking and consulting about SQL Server. December is almost every year already a very silent month for me, and I enjoy it a lot staying at home without seeing any airplanes anymore 🙂 …

Announcing the *brand new* SQLpassion Briefings and new SQLpassion Workshops + read more