Tag Archives: administration

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 , , | Leave a comment

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 , , , | Leave a comment

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 | Leave a comment

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 , , | Leave a comment

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

The Copy Cat Poll

This editorial was originally published on Aug 3, 2012. It is being re-run as Steve is on vacation. One of the interesting facts I saw a few years ago talked about storage in enterprise environments. There was research that showed … Continue reading

Posted in Editorial | Tagged ,

What’s Your Smoke Test?

Many DBAs and operational staff regularly stress over software deployments to production systems. Even when the administrator has built and tested the deployment scripts, there is still a nagging fear that something will be missed, incurring downtime for systems. I … Continue reading

Posted in Editorial | Tagged , ,

T-SQL Tuesday #81–Sharpening Skills

This is an interesting month for T-SQL Tuesday. The challenge is from Jason Brimhall to Sharpen Something, and learn something new. However, his challenge isn’t just a simple “learn something.” Instead, he writes: “This month I am asking you to … Continue reading

Posted in Blog | Tagged , , , , | 2 Comments

Updates During Outages

Slack went down on June 10, 2016. I noticed, which is funny, since I don’t necessarily use the tool every day. I tend to still communicate with email, but more and more people like using Slack at Redgate, so I … Continue reading

Posted in Editorial | Tagged