Backups for Azure SQL Virtual Machines
When it comes to database backups for IaaS based Azure SQL Servers you have 3 options. Automated Backups, both V1 and V2 depending on the SQL Server version. Azure...
2020-09-16
34 reads
When it comes to database backups for IaaS based Azure SQL Servers you have 3 options. Automated Backups, both V1 and V2 depending on the SQL Server version. Azure...
2020-09-16
34 reads
Warning, this is a longer post from me than usual. The title is a mouthful and so is this post. In the past I have linked to blog posts...
2020-09-09
328 reads
Last month I gave a presentation to The PASS Hybrid VG https://hybrid.pass.org/. Now is a good time to become “cloud ready” as a DBA and my presentation gives a...
2020-09-03
59 reads
One of the main benefits of configuring active geo-replication for Azure SQL Database is leveraging the read-only endpoint, a good technique to split away read only activity from OLTP...
2020-08-25
157 reads
A quick 2 minute overview video (from me) about ADS – Advanced Data Security. The unified package from Microsoft providing the ability to discover / classifying sensitive data, mitigate...
2020-08-19
34 reads
Recently I found out that I passed the BETA exam for Azure Database Administrator Associate qualification. I wanted to share with you my thoughts on the exam and if...
2020-08-11
37 reads
About 1.5 years I wrote about MAXDOP setting within Azure SQL DB, more specifically the fact that the default setting being 0. (https://blobeater.blog/2018/09/12/maxdop-and-azure-sql-db/) Now, you should be aware that...
2020-08-10
305 reads
I thought being an Azure Data/Database blogger I would share some amazing content from Microsoft, an Azure SQL Fundamentals learning path. Following this training you will “Learn how to...
2020-08-05
64 reads
Can you improve on the baseline (service level agreement) SLA of 99.99 % for Azure SQL Database? How can you get 99.995% as shown below, from official Microsoft documentation?...
2020-08-04
112 reads
Since SQL Server 2016 we could leverage Microsoft Azure to dynamically move “cold” portions of data away from on-premises storage for longer retention time periods. Whilst in theory being...
2020-07-27
54 reads
By Steve Jones
I wrote about Flyway Desktop Object History in a previous tip. This feature has...
By Arun Sirpal
AgentDBA (the database agent I have been building) has more than 1000 automated tests,...
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
Comments posted to this topic are about the item Server-level Roles
Comments posted to this topic are about the item Pay for Performance
Comments posted to this topic are about the item Tracking Inserted, Updated, and Deleted...
In SQL Server 2025, can I alter a fixed server role?
See possible answers