Basic Administration Tasks - Level 5 of the Stairway to for Azure SQL Database
In this next level, learn how to accomplish a few simple administration tasks that may help you manage your Azure SQL Database.
2018-10-24
2,031 reads
Arun Sirpal
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
SQL Server – Reading BACPAC Files
If you have been reading my blog for a while now you would know that a common technique to move...
2018-10-19
269 reads
Auto-Scaling Azure SQL DB
When I was presenting my Azure SQL Database session at DataRelay (used to be SQLRelay) I was asked (over coffee)...
2018-10-11
959 reads
Giant Azure SQL Databases
Okay it is not really called Giant Azure SQL Database but its close. There is a new public preview vCore...
2018-10-04
334 reads
Testing Failover for Azure SQL Database
It is always a good idea to test your failover processes when you have setup failover groups in Azure. I...
2018-10-02
345 reads
Using Microsoft Azure – Twitter Analysis
Time for a fun post, I have been working on a mini-project using technology from Microsoft Azure to hook into...
2018-09-27
406 reads
Accidentally deleted an Azure SQL DB?
Okay honestly I have done this once. I have deleted Azure SQL Databases and then try and find the quickest...
2018-09-24
250 reads
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
551 reads
Blogs
Using Flyway Prepare for State-Based Deployments
By Steve Jones
One of the neat enhancements made to Flyway was the addition of state-based workflows...
How I Migrated to Azure PostgreSQL Flex from Single Server
I did a couple of posts previously on dumping/restoring Azure PostgreSQL databases and also...
Have a Plan for Your Personal Downtime
By Brian Kelley
Most of us know that spending a lot of time on social media and...
Forums
Issue with Creating Linked Server from Azure SQL Managed Instance to On-Premises
Hi, Interestingly, I was able to create a linked server in the reverse direction—from...
SQL Monitoring tools
our client wants to implement Third Party SQL Monitoring tool to monitor SQL server...
PowerQuery.... don't meet SSIS
I have a powerQuery that reads and transforms a table in a PDF. Works...