In this video Brent takes a 40-minute look at some of his favorite new features: deferred compilation for table variables, adaptive memory grants, adaptive joins, and air_quote_actual plans

How Did I Do?

by Steve Jones

SQLServerCentral

PASS Summit

Steve looks back at his predictions for the PASS Summit.

How Fiducia & GAD scaled with SQL Monitor

by Additional Articles

Redgate

When growth was expected on the horizon for Fiducia & GAD, hiring more DBAs was not an option. With SQL Monitor they were able to scale at an unprecedented rate- 150 new servers and 70+ applications in one year.

Introduction to DevOps: Database Delivery

by Additional Articles

SimpleTalk

DevOps and Continuous Delivery (CI/CD)

Before including the database in your DevOps pipeline, you’ll need to decide if you are going to use a state-based or migrations-based approach. In this article, Robert Sheldon explains the difference between them and discusses the benefits of each.

Predictions for PASS

by Steve Jones

SQLServerCentral

PASS Summit

Steve is missing the PASS opening keynote, but he has a few predictions for the day.

Recover SQL Server Resource Database

by Additional Articles

MSSQLTips.com

Resource Database

SQL Server Post Update Failure | Troubleshooting - In this tip we look at the steps to recover missing SQL Server mssqlsystemresource database files that cause SQL Server not to startup. This can occur when an update to SQL Server does not complete successfully therefore making these files absent from the folder where they need to reside.

Logging Tables

by Steve Jones

SQLServerCentral.com

Editorial

Today Steve Jones looks at the need to log data from an application or process. Are there good and bad ways to design the structures to log information?

Managing Recursive Group on SSRS Reporting Services Reports

by Mohamed Idttalbe

SQLServerCentral

Learn how to implement a report that recursively walks a hierarchy in a table.

Set yourself up for success in 2020

by Additional Articles

Redgate

DevOps and Continuous Delivery (CI/CD)

Is DevOps central to your 2020 IT Digital transformation? How does your IT strategy underpin the business objectives? Read our latest blog to ensure you’re ready for success next year.