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
146 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)
367 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
90 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)
486 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
810 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
18 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
799 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,449 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
T-SQL Tuesday #196 – Two risky career decisions I made
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
T-SQL Tuesday #192: What career risks have you taken?
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
T-SQL Tuesday #196: Taking Risks
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Forums
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Going Native with Fabric Spark Pools: The Fabric Modern Data Platform
Comments posted to this topic are about the item Going Native with Fabric Spark...
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers