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
354 reads
Arun Sirpal
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
413 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
261 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
557 reads
Hello Cloud Goodbye DBA
No, not quite. I have had many interesting conversations around this topic and I don’t think (personal opinion) that DBAs...
2018-09-10
643 reads
Moving an Azure SQL Database across Resource Groups
In my mind there are a couple of ways to move a database across resource groups. They vary from scripting...
2018-09-05
932 reads
Azure SQL Database – Detecting Threats
At first I was nervous but then I realized it was me triggering “Someone has logged on to your server ...
2018-09-03
839 reads
Creating an Azure SQL Database - Level 3 of the Stairway to Azure SQL Database
Learn how to create a SQL Server database in Azure in this level.
2018-08-29
2,337 reads
Deleting Azure SQL DB
So you want to do a clean-up exercise in Azure and remove some databases. You go to delete a database...
2018-08-28
229 reads
My Azure SQL Database Elastic Job is Broken!
I use elastic pools. They are a fabulous way of saving money when running many Azure SQL Databases, that is...
2018-08-23
329 reads
Blogs
Blog a Day – Day 1: History of AI
By Vinay Thakur
it has been a year since i have not written much on the blog...
A New Word: on tenderhooks
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
Ramblings about data communities and your contributions, no excuses
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Forums
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
how do i map the "current" object entry in for each to one variable
hi, in an ssis for each loop over an object variable called MyListVariable, i...
Simulating Mercury’s Orbital Motion Using Pure T-SQL (NASA 2025 Dataset)
SQL Server is typically viewed as a transactional or analytical database engine. However, it...
Question of the Day
String Similarity I
On SQL Server 2025, when I run this, what is returned?
SELECT EDIT_DISTANCE_SIMILARITY('SQL Server', 'MySQL') See possible answers