Tag Archives: administration

Using DBCC Clonedatabase

I haven’t messed with the new DBCC CloneDatabase option in SQL Server 2014/12016 (depending on patches), but recently I saw this: On a quiet Friday afternoon, this seemed like a good time to experiment. We (Redgate Software) have a salesdemo … Continue reading

Posted in Blog | Tagged , , | 1 Comment

Balloons and Data

This editorial was originally published on Aug 8. 2013. It is being re-run as Steve is out of the office. We see a lot of questions at SQLServerCentral repeated over the years as workers new to the platform encounter some … Continue reading

Posted in Editorial | Tagged , | Leave a comment

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 ,

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

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