MAXDOP and Azure SQL DB
The infamous setting that we all know and love – MAXDOP. Did you know that you can actually control MAXDOP when...
2018-09-12
554 reads
All About SQL
Hello Cloud Goodbye DBA
No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs...
2018-09-10
641 reads
Moving an Azure SQL Database across Resource Groups
In my mind there are a couple of ways to move a database across resource groups. They vary from scripting...
2018-09-05
929 reads
Azure SQL Database – Detecting Threats
At first I was nervous but then I realized it was me triggering “Someone has logged on to your server ...
2018-09-03
834 reads
Deleting Azure SQL DB
So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database...
2018-08-28
227 reads
My Azure SQL Database Elastic Job is Broken!
I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is...
2018-08-23
324 reads
The Good The Bad and The SLA
Lets just get straight to the point, Azure SQL Database across all service tiers gives you the customer a SLA...
2018-08-20
255 reads
SQL Reserved vCores
Have you ever heard of SQL Reserved vCores? Well I never until recently. With this concept you have the ability...
2018-08-16
341 reads
Azure SQL DW – Query Labels
Using a query label in Azure SQL DW (Data Warehouse) can be a really handy technique to track queries via...
2018-08-14
356 reads
Azure SQL Data Warehouse and Backups
Just because the cloud movement is strong doesn’t mean the end of “DBA’s”, it does mean a change in skills...
2018-08-07
412 reads
Blogs
Leadership in Times of Change: Guiding Teams Through Uncertainty, Disruption, and Transformation
By Chris Yates
Change is inevitable. What separates thriving organizations from those that falter is not the...
The End of Year Vacation Burn
By Steve Jones
It’s been a good year for me. With my sabbatical, I felt like I’ve...
Speaking at PASS Summit 2025
By alevyinroc
In less than one month, I will be speaking not once but twice at...
Forums
Create an HTML Report on the Status of SQL Server Agent Jobs
Comments posted to this topic are about the item Create an HTML Report on...
Powershell script to generate SQL server Inventory in CSV format
Comments posted to this topic are about the item Powershell script to generate SQL...
Database Ledger in SQL Server 2022
Comments posted to this topic are about the item Database Ledger in SQL Server...
Question of the Day
Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers