Azure: SQL Database Elastic Pool and using Elastic Jobs
I want to show you how I went from having multiple single SQL databases in Azure to a database elastic...
2017-04-04
576 reads
All About SQL
SQL Server DBCC CHECKDB
A quick video clip where I show two things. Firstly I show how since SQL Server 2014 SP1+ the snapshot...
2017-04-01
364 reads
Azure – SQL Database Premium RS
A very quick post for today, I was navigating my way through the Azure portal within my SQL databases section...
2017-03-28
983 reads
SQLBits 2017
I have never been to SQLBits (https://sqlbits.com/) before (due to budgets) but I am really looking forward to attending which...
2017-03-27
301 reads
Why did my SQL Server database just go offline?
Note: This post contains a video clip where I show quirky behaviour of the scripted offline task. Personally I rarely...
2017-03-24
380 reads
My path from a junior to a senior DBA
A non-technical post but something I have been asked about few times so I thought that I would put pen...
2017-03-22
433 reads
TDE: Looking inside your database and backups
TDE (Transparent Data Encryption) encrypts the data files at rest but don’t forget that it also encrypts your backup file...
2017-03-20
315 reads
Corrupt Database – I need that data now!
My database is in the recovery pending state and I want to get in and extract the data out into...
2017-03-15
353 reads
Extreme situations require extreme commands
The title is adapted from a child-hood movie of mine and is my daily (database-related) WTF moment and it is...
2017-03-14
371 reads
My take on presenting
This idea basically started from Andy Bek’s TSQL Tuesday last year #84 growing new speakers (https://sqlbek.wordpress.com/2016/10/25/t-sql-tuesday-84-growing-new-speakers/ – thanks Andy) and I have...
2017-03-10
377 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