Tag Archives: administration

When were statistics updated?–#SQLNewBlogger

Posted on June 16, 2016 by way0utwest

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. I ran across the STATS_DATE function recently, and it’s one that I hadn’t used in production code. I’m not … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

What’s Your Test Plan?

Posted on May 20, 2016 by way0utwest

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 , , | Comments Off on What’s Your Test Plan?

Solving Tempdb Issues

Posted on May 12, 2016 by way0utwest

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 , | Comments Off on Solving Tempdb Issues

Stress Testing

Posted on April 29, 2016 by way0utwest

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 , | Comments Off on Stress Testing