Availability groups (AG’s) is one of my favorite features of SQL Server, despite some DBA’s catalogue them as “too complex” to implement, configure, manage and maintain … I just...
2019-05-13 (first published: 2019-05-01)
759 reads
Watch this week’s episode on YouTube. When you need to filter query results on multiple values, you probably use an IN() statement or multiple predicates separated by ORs: or...
2019-05-13 (first published: 2019-04-30)
1,320 reads
Hello folks! One week passed, another one almost began. And that will be a crazy week on two conferences. Today, I’m in Wroclaw (Poland) where we’re prepping SQLDay conference...
2019-05-13
18 reads
If you haven’t read the proposed changes yet you should do that first and form your own opinion before reading mine. Thoughts here are high level, not a line...
2019-05-10
84 reads
In today's world, people expect to be able to commit one change, then have the entire project re-deployed and automated tests run against it. Using the SSIS PowerShell...
2019-05-10 (first published: 2019-05-01)
937 reads
A short one, but one that took some digging and debugging and help from others. Saving here, so I remember, as do others. I had a VMWare Workstation v12.x...
2019-05-10 (first published: 2019-05-01)
140 reads
This is the third interview we have done. This time our guest is Robert Farley who can be also recognized as the famous guitar player! Here you can find...
2019-05-10
48 reads
If you are like me and were unable to get away from the office to attend Microsoft Build 2019 you will be glad to know that Microsoft has published...
2019-05-10
87 reads
My friend Andy Leonard has written an excellent blog series on getting SSIS up & running in a Docker container. I would never have even tried to go down...
2019-05-09 (first published: 2019-04-30)
2,981 reads
You know what it’s like, you need to fail your AG over but is it safe to fail over? Perhaps you’ve clicked on ‘failover’ for the AG and there’s...
2019-05-09 (first published: 2019-04-29)
854 reads
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Hi! I've been banging my head against the wall for 2 days now trying...
Comments posted to this topic are about the item The Power of Data and...
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers