SQL Saturday 147 Precon (#sqlsat147)
If you are planning on attending SQL Saturday 147 down in Recife Brazil you would check out my pre-con session being held on August 24th. In this session I’ll be talking about all of the High Availability options which are available for SQL Server 2012. I will be talking about AlwaysOn Availability Groups, Clustering, Database […]
Making Technical Writing Easier
Those of us that have worked on books have probably all run across the same problem at one time or another. When you are going through the book writing process, you always end up going back and wanting to add a code example, or a screenshot somewhere in the middle of the chapter, and you […]
Stop Using SQL Logins
Hey vendors, consultants, clients, etc. STOP USING SQL LOGINS. Now if the SQL Server you are using isn’t attached to a Windows domain then fine, odds are you’ll need a SQL Authentication login. However if the machine is a member of the Windows domain then login to SQL Server using Windows Authentication. The other day […]
PBM, Replication and Stored Procedure Names
One of the things that Policy Based management is really good at is making sure that people don’t create stored procedures that start with “sp_”. However when the server that you are deploying the policies to is also being used for SQL Server replication this can get a little more complex seeing how all of […]