Queries that Fail and How to find Them
Queries will fail. That is as inevitable as death and taxes. This article demonstrates how to find some truly horrible queries.
The post Queries that Fail and How to find...
2021-12-29
147 reads
Blog Posts
Saving PowerShell Results to the Clipboard–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Working with results and manipulating them is always...
2021-12-29 (first published: 2021-12-20)
371 reads
Statistics Auditing to make you Omniscient
This article demonstrates a more comprehensive method to audit changes to statistics. This method involves the use of Extended Events.
The post Statistics Auditing to make you Omniscient first appeared...
2021-12-29
91 reads
Understanding SQL Server IO Size
This blog post shows you how NTFS stores data, what the NTFS Allocation Unit means, and how SQL Server performs IOs of variable size.
How NTFS Stores Data on Disk...
2021-12-29 (first published: 2021-12-10)
491 reads
Blocked Process Report: How to Get More Value
By combining the raw power of the Extended Events engine in SQL Server with the Blocked Process Report, we are able to achieve real value in blocking monitoring.
The post...
2021-12-28
819 reads
Daily Coping 28 Dec 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-28
20 reads
Queries that Fail and How to find Them
Queries will fail. That is as inevitable as death and taxes. This article demonstrates how to find some truly horrible queries.
The post Queries that Fail and How to find...
2021-12-28
803 reads
Statistics Auditing to make you Omniscient
This article demonstrates a more comprehensive method to audit changes to statistics. This method involves the use of Extended Events.
The post Statistics Auditing to make you Omniscient first appeared...
2021-12-28
18 reads
“Could not find the modules: 'Az.Accounts' with Version: ''” error message and a story to remember
(2021-Dec-20) Part of the continuous integration and delivery for Azure Data Factory involves pre-deployment and post-deployment steps. Their main role is to stop triggers before deployment and restart them afterward,...
2021-12-27 (first published: 2021-12-20)
3,460 reads
Daily Coping 27 Dec 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-12-27
16 reads
Blogs
PlanTrace Now Supports PostgreSQL
PlanTrace Now Supports PostgreSQL The same plan analysis you know from...
A New Word: the Kinder Surprise
By Steve Jones
the kinder surprise – . the point in your early adolescence when you realize...
Crash-Consistent Snapshot Cloning - Hyper-V Edition
If you’ve been following my T-SQL Snapshot Backup series, most of what I’ve covered...
Forums
Alamat Kantor BCA KCU MATRAMAN Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur,...
BCA KCP Buaran Raya Telp/WA.0851°8812°0691
BCA KCP Buaran Raya Telp/WA.0851°8812°0691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA KCP Permata Ujung Menteng Tlp/WA.(+62 821°3111°179
Tlp/WA.(+62 821°3111°179 Jl. Raya Bekasi Km. 25 Blok A/17, RW.18, Ujung Menteng, Wil, Kota...
Question of the Day
SSoL Support on the OS
On which Linux versions is SQL Server 2025 on Linux supported?
See possible answers