Monthly Archives: May 2018

Pause and Backtrack

One of the main functions for anyone that manages a database is ensuring that they can recover the system in the event of any issues. My view is that restores are the most important skill and task that need to … Continue reading

Posted in Editorial | Tagged , , , | Comments Off on Pause and Backtrack

Checking CHECKDB

One of the recommendations for SQLServer is that you run a DBCC CHECKDB regularly on your system. Those individuals that have worked with SQL Server for some time and worked on learning more about the system know to schedule this … Continue reading

Posted in Editorial | Tagged | Comments Off on Checking CHECKDB

Update Oddness for SQL Server

I’ve been meaning to patch some of my development instances. With a little spare time while doing other work, I started the process the other day. My first step was to patch SQL Server 2016 with SP2. This went as … Continue reading

Posted in Blog | Tagged , , | 2 Comments

A Great Case for Powershell

I think PowerShell is a great addition to the Microsoft stack. Given the previous versions of VBScript, Perl and Python ports, and more on Windows, PowerShell is a great improvement. Even for someone that spent a lot of time in … Continue reading

Posted in Editorial | Tagged | Comments Off on A Great Case for Powershell