Fix: When an Availability Group listener’s IP is stolen
When you can connect to the individual nodes of a SQL Server Availability Group (AG), but not the AG listener,...
2018-09-05
888 reads
Dates and Times in SQL Server: AT TIME ZONE
Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the...
2018-09-05
274 reads
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of read-only replicas, for free. As mentioned in my blog Azure...
2018-09-05
130 reads
Azure SQL Database Read Scale-Out
Read Scale-Out is a little-known feature that allows you to load balance Azure SQL Database read-only workloads using the capacity of...
2018-09-17 (first published: 2018-09-05)
2,550 reads
I will be speaking @ SQLSaturday #795 Porto
On 29th September we will have SQL Saturday Porto and I’m proud to announce that I will be speaking!
I will...
2018-09-05
263 reads
I/O vs Logical I/O
tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two...
2018-09-13 (first published: 2018-09-05)
3,663 reads
Back up Encryption
Nowadays security breaches happen way to frequently. As DBA’s we should all take extra care with sensitive data and ensure we...
2018-09-11 (first published: 2018-09-05)
2,098 reads
Moving an Azure SQL Database across Resource Groups
In my mind there are a couple of ways to move a database across resource groups. They vary from scripting...
2018-09-05
939 reads
Podcast Audio Now On SoundCloud
For those of you who don’t have time to watch the videos, the audio stream of our webcasts are now...
2018-09-05
306 reads
Apache Hadoop Release 3.1.1 available
Last month Apache Hadoop also release its latest Stable release version Apache Hadoop 3.1.1 which has major improvement in Hadoop system....
2018-09-05
407 reads
Blogs
Flyway Tips: Object History
By Steve Jones
It’s a small change, but a handy one. Flyway Desktop (FWD) now includes the...
Car Update September 2026
By Steve Jones
Software is hard. While I love our Lucid Gravity, I realize that they are...
Microsoft Tools for Making Data AI-Ready
By James Serra
Making Data AI-Ready, Part 2 (This is the second article in a three-part series...
Forums
Looking for old SQL Server 1.x - 4.21 disks, manuals, boxes, etc.
Hi everyone, I'm hoping some of the longtime SQL Server professionals here might be...
Checking the Error Log II
Comments posted to this topic are about the item Checking the Error Log II
Parameter Sniffing on SQL Server 2025: A Walkthrough with Real Numbers
Comments posted to this topic are about the item Parameter Sniffing on SQL Server...
Question of the Day
Checking the Error Log II
What is the reason I should change my old code that uses xp_readerrorlog?
See possible answers