Tag Archives: administration

Using Trace Flags

At SQLServerCentral, we recently published a list of all the trace flags from Konstantin Taranov. It’s a great list, and thanks to Konstantin for compiling it. While I haven’t often used trace flags, there are some that have really helped … Continue reading

Posted in Editorial | Tagged , | Leave a comment

Backups Aren’t Backups Until a Restore Is Made

One of the interesting things I saw in the recent GitLab outage and data loss was the fact that none of their backups were available. They use PostgreSQL and I’m not familiar with the ways in which the modern PostgreSQL … Continue reading

Posted in Editorial | Tagged , | Leave a comment

The War Room

I remember the first time I worked in a large, 10,000+ employee company, and we had a crisis with our systems. A number of us crowded into the cold computer room, gathering around a few workstations and trying to solve … Continue reading

Posted in Editorial | Tagged | Leave a comment

Provisioning

This editorial was originally published on May 24, 2013. It is being re-run as Steve is on holiday. At a talk recently, the presenter talked about the time lag for an on-premises server to be installed and configured to be … Continue reading

Posted in Editorial | Tagged , | 2 Comments

Monitor All the Changes

Can you monitor every configuration change and setting on all your SQL Server instances? Can you get an alert every time code changes, or even if an option for an object changes, such as the changing of an EXECUTE AS … Continue reading

Posted in Editorial | Tagged , ,

A New Recovery Tool for Your Toolbelt

Those of us that administer databases and are responsible for ensuring the integrity and availability of data know that being able to restore systems is a core skill. In the SQL Server world, this should mean more than just being able to … Continue reading

Posted in Editorial | Tagged , , ,

What’s Your Backup Speed?

I ran across a thread recently where someone was looking to estimate the time it too to perform a 600GB backup. I’ve seen other threads with similar questions. The general advice is that you need to run a backup and … Continue reading

Posted in Editorial | Tagged , , | 1 Comment

DBA Support

This editorial was originally published on Oct 28, 2012. It is being republished as Steve is out of the office. There was a time when I managed two production databases on SQL Server. Two. I had a development version of … Continue reading

Posted in Editorial | Tagged

What is the Future of Monitoring?

I read Tom LaRock’s post on the future of monitoring, looking at the rise of machine learning and complex algorithms to evaluate systems. Tom notes that the data input into a system is crucial in determining whether the system can … Continue reading

Posted in Editorial | Tagged , ,

The Danger of xp_cmdshell

Securing a computer is a challenge. There are all sorts of potential issues in every platform, and ensuring safety for your data can be less a reflection of your ability and more the good fortune there isn’t a focused effort … Continue reading

Posted in Editorial | Tagged , | 4 Comments