Azure Redundancy for Storage
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-11 (first published: 2022-02-23)
459 reads
Blog Posts
Daily Coping 11 Mar 2022
I 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...
2022-03-11
28 reads
How to find tables with 0 records using space
This is a follow up post to the previous one about tables with no records using data space, with the idea coming from twitter of all places. Sometimes on...
2022-03-11
139 reads
Recipe 3: Merging and manipulating events
Welcome to the third recipe of this Extended Events cookbook! You will find the first blog post of the series here and you can browse all recipes with the...
2022-03-11 (first published: 2022-02-24)
216 reads
Database Code Reviews
I’ll be honest, ever since I did a SQL Homework about doing code reviews I’ve wanted to do a blog ... Continue reading
2022-03-10
13 reads
Database Code Reviews
I’ll be honest, ever since I did a SQL Homework about doing code reviews I’ve wanted to do a blog ... Continue reading
2022-03-10
138 reads
Snowflake Integration to Azure AD
Azure Active Directory is Microsoft Azure’s identity and access management providing authentication and authorization mechanism for internal and external applications in Azure ecosystem. With AD(more...)
The post Snowflake Integration to...
2022-03-10
70 reads
Check if File Exists Before Deploying SQL Script to Azure SQL Managed Instance in Azure Release Pipelines
I have been in Azure DevOps pipelines a lot recently, helping clients set up automated releases. Many of my clients are not in a place where automated build and...
2022-03-09 (first published: 2022-02-22)
392 reads
Daily Coping 9 Feb 2022
I 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...
2022-03-09
20 reads
ETL v ELT
This is part of a series on my preparation for the DP-900 exam. This is the Microsoft Azure Data Fundamentals, part of a number of certification paths. You can...
2022-03-09
63 reads
Blogs
Automatic Index Compaction
By ReviewMyDB
Index maintenance has always meant nightly jobs and a window you have to defend....
Monday Monitor Tips: Virtual Machine Usage and Cost
By Steve Jones
One of the things I’ve been requesting for a number of years is cost...
Advice I Like: Respect
By Steve Jones
“Don’t aim to have others like you; aim to have them respect you.” –...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
SQL Server Still Wins
Comments posted to this topic are about the item SQL Server Still Wins
DBCC CHECKDB Limits I
Comments posted to this topic are about the item DBCC CHECKDB Limits I
Question of the Day
DBCC CHECKDB Limits I
When running DBCC CHECKDB on SQL Server 2025, can I specify only the Resource Database?
See possible answers