Recently I migrated my home lab from a SuperMicro SYS-E300-8D to something a little beefier. There were ten virtual machines on the SuperMicro server, nine… Read More »Managing virtual machine drives on ESXi
In a previous post I wrote about storing password hashes in a database, which raises the question of how to convert an existing legacy password storage system… Read More »Convert legacy password storage without aggravating your users
In 2016 I created the Max Server Memory Matrix as a guide for configuring the maximum amount of memory that should be assigned to SQL Server,… Read More »Better SQL Server memory defaults in 2019
Next month, Microsoft is ending five years of extended support on SQL Server 2008 and SQL Server 2008 R2. This follows five years of mainstream… Read More »SQL Server 2008 and 2008 R2 is end of life on 9 July 2019
There was an interesting conversation on Twitter recently, between Grant Fritchey (blog | twitter), Kenneth Fisher (blog | twitter), Anthony E. Nocentino (blog | twitter),… Read More »Containers and data: you gotta keep ’em separated
Shall I compare thee to Management Studio? Thou art more scriptable and consistent. Those out-of-memory errors do tend to lose hours of work. And I… Read More »Do you even PowerShell, bro? An ode to dbatools and dbachecks.
A year ago, I wrote in a post that cloud computing is just someone else’s data center. I was wrong. Whether we like it or not,… Read More »The cloud is not just someone else’s computer
For the last five months or so, I have been helping some really smart people put words on paper, both the physical and electronic kind,… Read More »SQL Server 2017 Administration Inside Out
October is a busy month for me. I am flying all over the US and Canada for speaking engagements to share some thoughts about migrating… Read More »Compañero Conference and SQL Modernization Roadshow
[Last updated February 27, 2020] Brent Ozar Unlimited runs a website called SQL Server Updates which comes in really handy for keeping your on-premises SQL… Read More »Should I upgrade SQL Server 2012, or migrate to Azure?