Daily Coping 25 May 2020
I’ve 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-05-25
12 reads
Blog Posts
Explain CROSS APPLY like I’m 5.
A good friend of mine (Randolph West (blog|twitter) asked that someone Explain CROSS APPLY like they are 5. So, here’s ... Continue reading
2020-05-25 (first published: 2020-05-11)
1,823 reads
Find Indexes Used In Query Store
One of the most frequent questions you’ll hear online is how to determine if a particular index is in use. There is no perfect answer to this question. You...
2020-05-25 (first published: 2020-05-11)
430 reads
Ghost is taking full backup and breaking my backup chain . Be careful with Azure VM backup on VM having SQL server installation
I believe that I have strong knowledge in SQL Server backup and recovery process, but recently there was an incident which shook my confidence. I was working on a...
2020-05-25
15 reads
3D Printing Ear Savers
On April 5th, I started printing ear savers for healthcare workers. I started with a single Ender 3 Pro printer with a .4 nozzle. When I made a post...
2020-05-24
7 reads
3D Printing Ear Savers
On April 5th, I started printing ear savers for healthcare workers. I started with a single Ender 3 Pro printer with a .4 nozzle. When I made a post...
2020-05-24
3 reads
3D Printing Ear Savers
On April 5th, I started printing ear savers for healthcare workers. I started with a single Ender 3 Pro printer with a .4 nozzle. When I made a post...
2020-05-24
1 reads
3D Printing Ear Savers
On April 5th, I started printing ear savers for healthcare workers. I started with a single Ender 3 Pro printer with a .4 nozzle. When I made a post...
2020-05-24
6 reads
JSON data and a T-SQL variable.
G’day, You may have noticed when looking at FOR JSON AUTO or FOR JSON PATH that both clauses result in one single column that contains a JSON string. But,...
2020-05-23
1,936 reads
Updated Default Settings for Azure SQL Managed Instance Databases
A common saying about Azure is that it is always changing. This is a very accurate statement, want proof, just take a look at Microsoft Build 2020. Microsoft is...
2020-05-23
14 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