Recently someone asked a good question about SQL Data Compare. How can they add applicationintent to the connection? If you are using Data Compare, and you are reading from...
2020-09-22 (first published: 2020-09-14)
30 reads
Sometime having the right command in place opens up new doors to test things, like a failover for example. In this post we will take a look at a...
2020-09-22
1 reads
It is Tuesday!! Time for Part 3 in the series about SQL Server Agent Job Failures. This installment will show you how to setup SQL Agent Alerts and Operators...
2020-09-22 (first published: 2020-09-15)
72 reads
A quick tip I learned, that has become handy for me. Tl;dr: Try Win+V Often I am moving lots of information between different applications. I might do some editing,...
2020-09-21
2 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...
2020-09-21
3 reads
(2020-Sep-13) Array of arrays, in a JSON world, it’s a very common concept to have a set of sets of other elements in a dataset. Despite how strange it may...
2020-09-21 (first published: 2020-09-14)
146 reads
One of the few good, safe uses for the local SSD D: volume of an Azure VM is for SQL Server TempDB data and log files. There's a gotcha....
2020-09-21 (first published: 2020-09-14)
210 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...
2020-09-18
5 reads
Welcome to Part 2 in the series about SQL Server Agent Job Failures. In this part you are going to learn how to build an HTML report with Failed...
2020-09-18 (first published: 2020-09-10)
431 reads
Want to make sure you don’t have errors, validate performance, and save money while making changes with Azure SQL Database, Azure SQL Managed Instance, SQL Server RDS in Amazon...
2020-09-18 (first published: 2020-09-11)
166 reads
By John
Sometime having the right command in place opens up new doors to test things,...
By Steve Jones
A quick tip I learned, that has become handy for me. Tl;dr: Try Win+V...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Hi we have this procedure to restore a db: On the prod db Generate...
I have opportunity to tune below monster query. Is there anything right off the...
Comments posted to this topic are about the item How Many Distinct Records
Ask SSC