Recipe 6: Auditing Successful Logins
Welcome to a new recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-02-28
42 reads
Gianluca Sartori
- Twitter: @spaghettidba
- Website: https://spaghettidba.com
Recipe 2: Writing Extended Events to a table
Welcome to the second recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-02-23
602 reads
10 DBA recipes with XESmartTarget
Some time ago, I started a project called XESmartTarget. I find it super useful and you should probably know about it. It’s totally my fault if you’re not using...
2022-02-21
83 reads
SQLSaturday is dead, long live DataSaturdays
This is a very brief post to inform you that PASS has died, killed by the for-profit company behind it. That’s sad beyond words, but we, as a community,...
2020-12-28 (first published: 2020-12-18)
1,000 reads
Replaying Workloads to a different Database
One of the features I was asked to implement for WorkloadTools is the ability to replay commands to a database name different from the one recorded in the source...
2020-04-09 (first published: 2020-03-31)
399 reads
Performing a real-time replay with WorkloadTools
In a previous blog post, I showed you how to use WorkloadTools to replay a workload in two different scenarios. However, there is a third scenario that is worth...
2020-03-12 (first published: 2020-03-03)
342 reads
Collecting Diagnostic data from multiple SQL Server instances with dbatools
Keeping their SQL Server instances under control is a crucial part of the job of a DBA. SQL Server offers a wide variety of DMVs to query in order...
2019-12-05 (first published: 2019-11-24)
859 reads
Troubleshooting “Could not obtain information about Windows NT group/user”
This is one of those typical blog posts that I write for my future self, the guy who keeps fixing the same stuff over and over and forgets what...
2019-08-28 (first published: 2019-08-16)
2,670 reads
Workload replay with WorkloadTools
In my last post, I described how to capture a workload to a file, in order to run a replay against your target environment at a later time. Well,...
2019-07-08 (first published: 2019-06-20)
1,118 reads
Life behind a proxy server: downloading content for SSMS Help Viewer
Life behind a proxy server can be problematic. Not every software out there is tested correctly for proxy interaction and oftentimes the experience for the corporate user is a...
2019-05-22 (first published: 2019-05-09)
564 reads
Blogs
Advice I Like: Responsibility
By Steve Jones
“The foundation of maturity: Just because it’s not your fault doesn’t mean it’s not...
Power BI Performance in 2026: A Practical Guide to Faster Semantic Models and Reports
By James Serra
Originally published April 2022; substantially updated July 2026. This post is a complete replacement...
Getting Started with Azure SQL Developer on Macbook
The idea behind Azure SQL Developer is for anyone to build, iterate, and test...
Forums
ALAMAT KANTOR BCA KCP Arundina Cibubur Telp:083831618008
WhatsApp:0838-3161-8008 Blk BA, Jl. Cibubur Indah Jl. Lap. Tembak No.26 Blok A/24, RT.2/RW.11, Cibubur,...
Migration Challenge: Excessive FULLSCAN Statistics Update Duration Blocking SQL
Hello everyone , I am planning to migrate a database from SQL Server 2014...
SQL Agent Job Automated Change Capture Process
Comments posted to this topic are about the item SQL Agent Job Automated Change...
Question of the Day
Finding a Database Master Key
Where do I check for the existence of a Database Master Key (DMK) in SQL Server 2025?
See possible answers