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
Edited on 10 October 2018: Please note that this model has changed. See Changes to the SQL Server servicing model (Cumulative Updates) for more. The… Read More »Changes to Service Packs and Cumulative Updates for SQL Server 2017
I’ve been working with SQL Server for many years now, and up until recently, I assumed that rebuilding any clustered index would cause non-clustered indexes… Read More »Does rebuilding my clustered index also rebuild my non-clustered indexes?
Recently, I presented my “Back up and Restore your Database with Azure Blob Storage” session to the Bellingham PASS Chapter. There are two components to… Read More »Remote Storage Sync and Restore updated
We back up our databases regularly. We store them on a secure network location so that if the database drive fails, we can still satisfy… Read More »Compressed and Encrypted Backups on the Cheap
Blob Storage Sync tool updated During a SQL Server migration this month, I found some inconsistencies in my Azure Blob Storage Sync tool, so I… Read More »Update to Azure Blob Storage Sync and Restore
Five months from now, Microsoft will stop supporting Windows XP. As Tim Rains points out, running Windows XP after this date will effectively be an… Read More »End of Life for Microsoft Windows XP and Server 2003: Six-One or Up