Tag Archives: administration

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

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

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

What’s Your Test Plan?

I ran across a post on upgrading a SQL Server instance, where the original poster (OP) was asking about a document to upgrade from SQL Server 2008 to 2014. That’s a big ask, especially as not many documents tend to … Continue reading

Posted in Editorial | Tagged , ,

Solving Tempdb Issues

While reading Remus Rusanu’s piece on SQL Server 2016 development, there was an item that struck me. There’s a part of the piece where he notes that an engineer at Microsoft realized that there was a tempdb issue with Azure … Continue reading

Posted in Editorial | Tagged ,

Stress Testing

Many of the DBAs that manage production systems will at some point determine what level of hardware is needed to support a workload. Whether this is a physical server purchase or a cloud “rental”, someone has to decide what hardware … Continue reading

Posted in Editorial | Tagged ,

What’s Your Downtime?

That’s the question this week: What’s your downtime? I thought about this as I read this piece on Azure’s downtime being greater than its rivals in 2014. You do need to provide an email to read the article, but essentially … Continue reading

Posted in Editorial | Tagged