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
(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,447 reads
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
8. prosince jsme se opet sešli u obeda nad novinkami ze sveta dat. Je super, že se stále více úcastní i lidé mimo JC – jsme rádi, že se...
2021-12-27 (first published: 2021-12-19)
130 reads
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-24
18 reads
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. If you want to get started blogging, or...
2021-12-24 (first published: 2021-12-08)
171 reads
If you are an avid report designer or user, you may have wanted to see the percent difference between one row and the previous one. Sounds easy right? Well...
2021-12-24 (first published: 2021-12-15)
1,573 reads
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-23
13 reads
Imagine getting SA (sysadmin) access to your RDS SQL Server Instance! Well, that was not possible in the past, but during AWS re:Invent 2021, Amazon RDS Custom for SQL...
2021-12-22 (first published: 2021-12-08)
488 reads
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-22
13 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
hi, in an ssis for each loop over an object variable called MyListVariable, i...
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers