Tag Archives: administration

Reserved Space

Posted on January 30, 2019 by way0utwest

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 | Comments Off on Reserved Space

Mitigate Issues Early

Posted on November 28, 2018 by way0utwest

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 | Comments Off on Mitigate Issues Early

Moving to Query Store

Posted on November 26, 2018 by way0utwest

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 , | Comments Off on Moving to Query Store

New Database Options

Posted on November 16, 2018 by way0utwest

I saw recently that Azure SQL Database is getting a few more Database Scoped Options for that platform. These are intended to give more control over the way in which the engine behaves, without requiring each database on a server to function … Continue reading →

Posted in Editorial | Tagged , | Comments Off on New Database Options