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
6,717 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,018 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)
13,615 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
8,258 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,864 reads
Blogs
Ethics in Modern Data this Saturday with the South Florida Data Geeks
By Will Assaf
This Saturday Aug 7, Christine and I will present our joint presentation on Ethics...
3 Reasons Why Focusing on Tech Is The Worst Way To Deploy a HA/DR Solution
By kleegeek
This past Thursday, Edwin Sarmiento presented a session for our Microsoft Data Platform Continuity...
The PowerBI Volleyball Report – Organizing Data To Start
By Steve Jones
One of my goals this year was to build a report that I can...
Forums
ColumnStore Index Maintenance routines
Hi all I use the Ola Hallengren Index Optimize script for rowstore index maintenance...
Minimun Role Permissions Needed
Hi Friends, Please some guidance, To import a bacpac file in a MI instance,...
Need counts of payment amounts per week grouped by week
Hello, I have a code that suppose to give me weekly(summed) payments, but instead,...
Ask SSC