Disable, don’t delete those indexes
A quick post this week, since it’s that time of the year when people do gift exchanges and put up colourful lights. Here goes: If… Read More »Disable, don’t delete those indexes
Home » Maintenance »
Maintenance
Introducing Azure Data Studio
(Last edited on 9 January 2020) Note: This was originally written for the book SQL Server 2017 Administration Inside Out, but did not meet the… Read More »Introducing Azure Data Studio
SQL Server 2017 Administration Inside Out
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
Changes to Service Packs and Cumulative Updates for SQL Server 2017
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
Does rebuilding my clustered index also rebuild my non-clustered indexes?
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?
Remote Storage Sync and Restore updated
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
PSA: Check Your Backups
This post comes to you from the Spanish countryside. I travel a lot these days, sometimes even for work. The best part about travelling, apart… Read More »PSA: Check Your Backups
On Best Practices
We hear a lot about “best practice”, but what does it mean in the context of SQL Server? Wikipedia describes best practice as follows: A… Read More »On Best Practices
Compressed and Encrypted Backups on the Cheap
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
98% of I/O is taken up by tempdb
During a recent engagement, the customer explained that the performance on their relatively small system was especially slow on Monday morning, but generally bad that… Read More »98% of I/O is taken up by tempdb
Max Server Memory Matrix
When we perform diagnostics on an existing SQL Server instance, or if we are setting up a new machine, it’s very important to make sure… Read More »Max Server Memory Matrix
Update to Azure Blob Storage Sync and Restore
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
Pre-Announcement Announcement
On Saturday, 27 June 2015, I will be presenting at SQLSaturday #407 in Vancouver BC. The session is titled “Restoring a SQL Server Database from… Read More »Pre-Announcement Announcement
SQLSaturday #407 in Vancouver
I have been selected to speak at SQLSaturday #407 in Vancouver, on 27 June 2015. My topic is about restoring SQL Server backups from Azure… Read More »SQLSaturday #407 in Vancouver
End of Life for Microsoft Windows XP and Server 2003: Six-One or Up
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
- « Previous
- 1
- 2
- 3
- 4
- Next »