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
7,625 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)
5,586 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)
16,154 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
10,170 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
10,616 reads
Blogs
SQL Prompt Quick Access to Helper Code
By Steve Jones
We’ve been doing some events as part of the Redgate Roadshow, and at one...
Eleven chapters of my data architecture book are available
By James Serra
As I have mentioned in prior blog posts, I have been writing a data...
Speaking at SQL Saturday Boston 2023
By alevyinroc
I’m happy to announce that I will be speaking at SQL Saturday Boston on...
Forums
Works on all other sql2022 servers but not on production. - must be dropped
HI We have a small utility that is giving us a "#table is missing...
Convert common Separated number to # table
@reportParameter 1008,1009,1011,1014 values need to insert to #Table Note: @reportParameter is not returning values...
Things to be considered before implementing database auditing
Hi All, As part of security compliance, we are told to audit DML &...
Ask SSC