Tag Archives: administration

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

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

Restoring a Striped Backup–#SQLNewBlogger

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I uncompressed some SQL Backup Pro files. Since multiple threads were used to make the backup, I ended … Continue reading

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

Creating a Database Snapshot

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I’ve rarely dealt with database snapshots, outside of lab experimentation. They didn’t exist when I did most of my … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Disabling SQL Server Network Protocols

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across a question on network protocols recently, which is something I rarely deal with. Often the default … Continue reading

Posted in Blog | Tagged , , ,