Performance Tuning Using Extended Events: Part 2
Part 2 of identifying performance puning opportunities using Extended Events. Learn how about shredding XML.
2019-12-23
5,469 reads
Brian Davey
Performance Tuning Using Extended Events: Part 3
Identifying Performance Tuning Opportunities Using Extended Events: Part 3 Aggregate Report
2019-12-20 (first published: 2017-05-04)
4,318 reads
Performance Tuning Using Extended Events: Part 1
In this article, learn how to identify performance tuning opportunities using Extended Events.
2019-12-06 (first published: 2017-04-20)
10,309 reads
How to Setup Log Shipping for Multiple Databases
This article by Brian Davey describes how to setup log shipping for a large number of databases minimizing the number of jobs needed thus significantly reducing CPU and memory usage.
2011-09-28
6,749 reads
Changing Text in Multiple Stored Procedures From a Stored Procedure
In this article Brian Davey present a solution for changing the text in multiple stored procedures using T-SQL.
2011-03-28
9,484 reads
Blogs
Deploy BACPAC to Azure Managed Instance failing from SSMS?
By Daniel Janik
Recently I ran into an error when trying to copy a small database bacpac...
Daily Coping–3 Apr 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is...
Data Céilí 2020 Cancelled
Yesterday we announced that Data Céilí 2020 has been cancelled due to the continuing...
Forums
Need T-SQL to list all tables in database that 'qualify' for Compression
Does anyone know of any existing script that would allow me to list all...
Delet old backup in azure
Hello, How to delete backups in blob storage from azure sql server VM to...
Ask SSC