Tag Archives: administration

Changing the Database Collation–#SQLNewBlogger

Posted on February 27, 2019 by

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

Posted on January 30, 2019 by

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

Posted on November 28, 2018 by

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

Posted on November 26, 2018 by

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 ,