T-SQL Tuesday #135 – The Tools That Make My Job Awesome!
Blog posts have been few and far between from SQL Undercover lately but what better to try and get us back in the swing again than with T-SQL Tuesday....
2021-02-09
146 reads
Statistics and the Ascending Key Problem
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...
2021-02-09
186 reads
Unable to Connect to Target Server? But, I'm Already Connected!
I am working on an Azure SQL Database migration from an on-premises VM, and at the client's request I am working through the BACPAC Import/Export process rather than using...
2021-02-16 (first published: 2021-02-08)
351 reads
Release Your Inner Synapse
I don’t know about you, but as Microsoft has produced the Azure Synapse platform, I see a plethora of needs that could be fulfilled by it. Being in a...
2021-02-12 (first published: 2021-02-08)
338 reads
Using Data Compare with Recent Data Only
This is a post that looks at how to compare data changes in recent data. A customer recently asked me about looking at a table, and choosing specific data...
2021-02-16 (first published: 2021-02-08)
292 reads
How to Prep a SQL Server Availability Group for VM-Level DR Replication
If you have a SQL Server Availability Group (AG) and the VMs are being replicated to a disaster recovery site (cloud or on-prem), chances are the networking topology is...
2021-02-15 (first published: 2021-02-08)
329 reads
Daily Coping 8 Feb 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-02-08
29 reads
SQLpassion Online Training about Locking, Blocking, and Deadlocking
On February 25, 2021 I will run an SQLpassion Online Training about Locking, Blocking, and Deadlocking in SQL Server – one of my favourite topics! Locks are used by...
2021-02-08
18 reads
SQLpassion Online Training about Locking, Blocking, and Deadlocking
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-02-08
7 reads
SQLpassion Online Training about Locking, Blocking, and Deadlocking
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-02-08
6 reads
Blogs
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident
By SQLPals
SQL Server Transaction Log Forensics: Preserving Evidence During an Incident SQL...
What Does It Mean to Make Data AI-Ready?
By James Serra
Making Data AI-Ready, Part 1 (This is the first article in a three-part series...
Using the Data API Builder–VS Live San Diego Resources
By Steve Jones
Thanks for attending my sessions. Resources below: Slides: Using Data API Builder GitHub repo: ...
Forums
Hyperscale Replicas II
Comments posted to this topic are about the item Hyperscale Replicas II
Practical Reporting Queries with CROSS APPLY (Part 3)
Comments posted to this topic are about the item Practical Reporting Queries with CROSS...
Your Favorite Quotes
Comments posted to this topic are about the item Your Favorite Quotes
Question of the Day
Hyperscale Replicas II
How many Azure SQL DB Hyperscale HA replicas can be configured as of Sept 2026?
See possible answers