Iterating Over Calculated Tables using Power Query

Problem Many of us are already aware of the loopin...

Database DevOps is gaining popularity

Fourty-six percent of the State of Database DevOps survey respondents advised they are performing some form of deployment automation. This figure has risen year on year as the conversation of DevOps in Database development continues, and the benefits become more apparent. If you are interested in more insight, you can download a copy of the 2020 State of Database DevOps report here.

Download now

The Staging Phase of Deployment

Despite some humorous examples of deployments gone wrong, failures are not funny. William Brewer explains why staging is so important and how it can help avoid the types of disasters he recalls in this article.

Automate your Morning Checklist

A morning checklist is a good thing, but an automated one is better.

Database Reliability Engineer- The new DBA?

The role of the DBA is evolving! With automated builds, cloud and DevOps being the new A,B,C,Ds in the day to day management of databases, you need to up-skill and learn about Database Reliability Engineering. Join Microsoft MVP Hamish Watson to find out more.

DevOps is Essential for Analytics

Database DevOps means accurate and consistent data which is critical for analytics, artificial intelligence, and machine learning.

Aggregate Data for the Last Day of the Month

On some occasions you will need to aggregate Data for the Last Day of the Month. This article explains how.

SQL Server and Undocumented Extended Procedures

Smart DBAs automate tasks whenever possible. In this article, Greg Moore shows the need to use caution when using undocumented procedures for automating tasks, and that PowerShell may have what you need instead.

Check Your Backup Compliance Against a Data Management Provider

As a database administrator, it's your responsibility to ensure the customer data won't get lost in case of a disaster, so you either provide your own backup strategy, use a third-party script, or hire a data management provider. With the first two options, you have full control over your environment so you can know exactly […]

How to Track Performance of Queries That Use RECOMPILE Hints

Say we have a stored procedure that has two queries in it, the first query will always get the same plan, but the second query will get different plans and return different numbers of rows depending on which reputation we pass in.