Find identical duplicate indexes - Revised
I realized yesterday I posted this quickly after testing only against SQL 2016 version. So I decided to also test against SQL 2014 and 2012 versions to make sure...
2019-05-16
61 reads
Blog Posts
New Pluralsight Course – Managing the Kubernetes API Server and Pods
New Pluralsight Course – Managing the Kubernetes API Server and Pods My new course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! Check out the trailer here or if you...
2019-05-16
49 reads
New Pluralsight Course – Managing the Kubernetes API Server and Pods
New Pluralsight Course – Managing the Kubernetes API Server and Pods
My new course “Managing the Kubernetes API Server and Pods” in now available on Pluralsight here! Check out the trailer here or if you...
2019-05-16
2 reads
OpenSSH Resources for Windows and PowerShell
Had a conversation with a good friend in the SQL Community about OpenSSH and how it fits as a transport layer for PowerShell Remoting. I pointed him towards several...
2019-05-16 (first published: 2019-05-04)
530 reads
Track SQL Server Database Recovery Progress – ErrorLog
This question has come up many times how to capture the SQL Server Database Recovery Progress or Total time take to recover a database. It will help to plan...
2019-05-16 (first published: 2019-05-04)
473 reads
How to delete a lot of data from a SQL Server database
How to delete data efficiently When we delete data from a table in SQL Server, we can often find that the delete is slower than even the original insert,...
2019-05-15
334 reads
How to delete a lot of data from a SQL Server database
How to delete data efficiently When we delete data from a table in SQL Server, we can often find that the delete is slower than even the original insert,...
2019-05-15
4 reads
Proposed SQL Server defaults: max server memory
A few months ago I suggested that the following settings should be the default for most SQL Server instances: Set cost threshold for parallelism to 50 Disable lightweight pooling...
2019-05-15
118 reads
SQLDay 2019 – Day 2
Tuesday is the day when SQLDay starts. The doors are opened from 8am but the show begins with a keynote at 9am. This year the keynote talk was done...
2019-05-15
13 reads
Using PowerShell in Containers
The vision for PowerShell Core is to be able to run PowerShell anywhere. In this article, I’m going to discuss how you can use Docker Containers to enable just...
2019-05-15 (first published: 2019-05-02)
2,844 reads
Blogs
2025 Wrapped for Steve
By Steve Jones
I’ve often done some analysis of my year in different ways. Last year I...
The Book of Redgate: Spread across the world
By Steve Jones
This was Redgate in 2010, spread across the globe. First the EU/US Here’s Asia...
Merry Christmas
By John
Today is Christmas and while I do not expect anybody to actual be reading...
Forums
Database security permissions save script
Comments posted to this topic are about the item Database security permissions save script
Database backup job steps
I have a SQL Agent job for backing up a set of Analysis Services...
SQL Server 2025 Backup Compression Algorithm
Comments posted to this topic are about the item SQL Server 2025 Backup Compression...
Question of the Day
The Large Encoded Value
I want to use the new BASE64_ENCODE() function in SQL Server 2025, but return a string that isn't large type. What is the longest varbinary string I can pass in and still get a varchar(8000) returned?
See possible answers