Tag Archives: administration

Changing the Database Collation–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I was testing some changes recently and needed to verify how things worked in a different collation. Here’s the … Continue reading

Posted in Blog | Tagged , | 1 Comment

Reserved Space

Many of us that work with SQL Server are familiar with the idea of reserving space that our system might need later. This is normal operation in SQL Server, where we pre-allocate space to data and log files, knowing that … Continue reading

Posted in Editorial | Tagged | Leave a comment

Mitigate Issues Early

This is a great postmortem from Basecamp with a detailed explanation of a problem and how they are hoping to avoid issues with their service. Basecamp is a Software as a Service tool from 37 Signals that had an outage recently. Actually, the service … Continue reading

Posted in Editorial | Tagged

Moving to Query Store

In SQL Server 2016, Microsoft introduced the Query Data Store (QDS) as a tool that would capture data about the execution of queries inside of your database. This was a project that had been in the works for a number of years, … Continue reading

Posted in Editorial | Tagged ,