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,819 reads
Blog Posts
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)
427 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
11 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
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
2 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,864 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
12 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
7 reads
Blogs
From OLTP to Analytics: Bridging the Gap with Modern SQL Architectures
By Chris Yates
In the beginning, there was OLTP – Online Transaction Processing. Fast, reliable, and ruthlessly...
Solving SQL Server Mysteries with a Whole Gang of Sleuths -Scooby Dooing Episode 4
One thing I’ve always loved about the Scooby-Doo cartoon is that he never solved...
SQL Server Availability Groups
By Kevin3NF
Flexibility and Scale at the Database Level When SQL Server 2012 introduced Availability Groups...
Forums
SQL Server 2025 Jobs
Hello SQL Server 2022 16.0.4212.1 running on a Windows Server 2025 Std,V 24H2, SO...
how to optimise whole database full of table and sp in one go using githubcopilo
i have subscription of github copilot which i can access in vs 2022 comunity...
Password Guidance
Comments posted to this topic are about the item Password Guidance
Question of the Day
Using table variables in T-SQL
What happens if you run the following code in SQL Server 2022+?
declare @t1 table (id int); insert into @t1 (id) values (NULL), (1), (2), (3); select count(*) from @t1 where @t1.id is distinct from NULL;See possible answers