Azure SQL Database DTU Versus vCore
I wrote a guest article for an IT consultancy on Azure SQL Database, more specifically DTUs and vCore options. At...
2018-12-17
870 reads
All About SQL
SQL Server I/O
Sometimes I like to see and know what SQL server is doing under certain operations and recently I wrote an...
2018-12-11
219 reads
Azure SQL Database “Step By Step” Tutorials
I would like to share a link to my Azure SQL Database Stairway series hosted over at SQLServerCentral. As stated...
2018-12-06
449 reads
Azure SQL Database – Firewall Rules
If you decide to use IP addresses to control what services have access to your Azure SQL Database, then understanding...
2018-12-04
224 reads
Microsoft Professional Program vs Microsoft Certification
When learning new technologies many people will go towards training courses (in person or online) but many also go for...
2018-11-15
255 reads
Azure SQL Database – Fixing My Scaling Failure
This is kind of a follow up from my last blog post about a scale down request issue. (https://blobeater.blog/2018/11/07/azure-sql-database-aborting-scale-request/) I...
2018-11-14
221 reads
Azure SQL Database – Aborting Scale Request
Scaling up or down an Azure SQL Database is a very common task. Whilst common it is also very easy...
2018-11-07
281 reads
Azure SQL Database – Who Changed My Auto Tuning Settings?
One of the features Microsoft wants us to use for Azure SQL Database is Automatic Tuning. Automatic Tuning is a...
2018-11-01
287 reads
Whirlwind Tour of Azure SQL Database
I have finally uploaded my Azure SQL Database presentation, apologies for the delay. I am already working on an improved...
2018-10-24
802 reads
Azure SQL DB – Failed to update database because the database is read-only
Quite an interesting situation I found myself in where I was perplexed for about 5 minutes. I was connected to...
2018-10-22
414 reads
Blogs
My 2024 in Data: Music
By Steve Jones
This is my last week of the year working (I guess I come back...
A New Word: Suente
By Steve Jones
suente– n. the state of being so familiar with someone that you can be...
Side Projects
Anyone (everyone?) who has ever tried to learn a programming language knows that to...
Forums
Automating Export of PowerQuery to SQL Server using DAX Studio...?
I wrote a PowerQuery that parses a table from a PDF, and I want...
Attaching an SQL Server database without Transaction Log Files through SQL Server Management Studio.
Comments posted to this topic are about the item Attaching an SQL Server database...
Superseded Indexes
Comments posted to this topic are about the item Superseded Indexes
Question of the Day
Superseded Indexes
Which of these indexes is superseded by another?
See possible answers