Backup and Restore Options for Azure SQL DB
I have decided to do a summary blog post on backup and recovery options for Azure SQL Database. If you...
2018-03-26
580 reads
All About SQL
SQL Vulnerability Assessment for Azure SQL Database
Back in September 2017 Microsoft announced a new security feature for Azure SQL Database called the SQL Vulnerability Assessment (VA)....
2018-03-22
997 reads
Azure SQL Database and Cost Threshold for Parallelism
We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated...
2018-03-26 (first published: 2018-03-16)
2,328 reads
Understanding DBCC FLUSHAUTHCACHE
This command only applies to Azure SQL Database, at a high level it empties the database authentication cache for logins...
2018-03-14
734 reads
Azure SQL Database – Allow Azure Services to Access Server
When you create a “logical” Azure SQL Server (I say logical because we are not really physically creating anything) there...
2018-03-09 (first published: 2018-03-01)
2,487 reads
How to setup Azure SQL Analytics
I am a big fan of this feature, I have written and spoken about it before ( https://blobeater.blog/2018/01/04/azure-sql-analytics/) but I did...
2018-02-26
1,049 reads
Saving Costs in Azure
Nobody wants to waste money and being in the cloud is no exception! Luckily for us Azure is very efficient...
2018-02-27 (first published: 2018-02-15)
1,787 reads
Azure SQL Database sa Connections?
I was using a query on one of my local SQL Servers where I wanted to know what logins were...
2018-02-07
1,087 reads
Deleting Azure SQL Database VNETs
This is quite a new feature (currently in preview) but an important one where we now have the ability to...
2018-02-07 (first published: 2018-01-29)
1,032 reads
The world of Automatic Tuning – SQL Server 2017
Times are changing, 10 years ago I would never have thought that self-tuning databases would be available as a packaged...
2018-01-31 (first published: 2018-01-22)
2,415 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers