Scaling SQL Elastic Pools
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
55 reads
All About SQL
Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
150 reads
SQL Server 2019 Suspend/Resume TDE
Yes, a really nice new shiny feature where we have the ability to suspend and resume the encryption scan for TDE – Transparent Data Encryption which is available in...
2019-04-02
155 reads
New Improved Azure Elastic Jobs
There is a new way to setup Azure elastic jobs to run against a target group of databases (targeting an elastic pool). I actually found the process quite messy...
2019-03-27
16 reads
Sizing your Azure SQL Database
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
656 reads
SQL Server – max server memory
Another re-post of a video from last year, this time showing you an in-built protection of setting max server memory...
2019-03-14
479 reads
SQL Server Deadlocks
A quick video clip showing how to create a deadlock in SQL Server and find information about it.
2019-03-13
1,113 reads
T-SQL Tuesday Sharing Cookies
It has been a while since I have participated in a T-SQL Tuesday but I felt the urge to do...
2019-03-12
421 reads
Azure SQL Data Warehouse Query Store
I personally think that query store has been a fantastic feature. I find myself using it for query performance troubleshooting...
2019-03-05
616 reads
Azure SQL Database and Trace Flags
You cannot enable trace flags (globally or by session) within Azure SQL Database but did you know that some global...
2019-02-26
597 reads
Blogs
SQL Saturday Atlanta BI Recap
By DataOnWheels
https://sqlsaturday.com/2025-03-08-sqlsaturday1102/#schedule SQL Saturday Atlanta BI is one of my favorite SQL Saturdays of the...
Mistakes IT Shops Without a DBA Make
By Kevin3NF
We get it. There’s no budget for a DBA on staff, or even a...
A New Word: Waldosia
By Steve Jones
waldosia– n. a condition in which you keep scanning faces in a crowd looking...
Forums
Dynamic T-SQL Script Parameterization Using Python
Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...
SQL 2017 server keeps locking up
I manage a two-node production SQL cluster running SQL Server 2017 CU31 on Windows...
Alternatiives to Junk Dimensions
Hello SSC, I am not sure if I posted this in the right spot,...
Question of the Day
Partial Backups II
What is a partial backup for a read-write database?
See possible answers