Azure Cosmos DB Intro
Cosmos DB falls into the “NoSQL” technology group, call it a buzz word if you like but it is very different to classic Relational Databases such as SQL Server....
2019-06-10
207 reads
Arun Sirpal
Using Azure Data Factory to Migrate Data
Quite simply the objective as follows: Move data from Azure SQL Database to Azure SQL DW via Azure Data Factory v2 (ADF). Overview Before I begin, what exactly is...
2019-05-22
192 reads
Azure SQL Database Serverless
Quite a significant change has taken place within the Azure SQL Database space, more specifically the development of Azure SQL Database Serverless. Currently in preview mode this “compute” tier changes...
2019-05-14
328 reads
Pausing / Resuming Azure SQL DW
Before writing about pausing (and resuming) Azure SQL Data Warehouse (DW) it makes sense to discuss the architecture of this product. At a high level it involves a control...
2019-05-07
112 reads
Video – Creating Azure SQL Database
A quick 2 minute upload (with sound, my voice) showing you how easy it is to create an Azure SQL Database using the Azure portal and then using SSMS...
2019-04-23
40 reads
Scaling SQL Elastic Pools
There are a few ways to scale a SQL elastic pool. For this blog post I show you how to scale up. It can be done via the Azure...
2019-04-15
61 reads
Tuning Azure SQL Elastic Pools
The below image is a beautiful picture, now it could be worse. The red line and the green line could peak at the same time and for a very...
2019-04-11
157 reads
SQL Server 2019 Suspend/Resume TDE
Yes, a really nice new shiny feature where we have the ability to suspend and resume the encryption scan for TDE – Transparent Data Encryption which is available in...
2019-04-02
160 reads
New Improved Azure Elastic Jobs
There is a new way to setup Azure elastic jobs to run against a target group of databases (targeting an elastic pool). I actually found the process quite messy...
2019-03-27
21 reads
Sizing your Azure SQL Database
Do you want to identify the correct Service Tier and Compute Size ( was once known as performance level) for your...
2019-03-20
663 reads
Blogs
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Forums
Optimism Without Illusion or Why AI Needs Blunt Technologists
Comments posted to this topic are about the item Optimism Without Illusion or Why...
SSIS with VS2022 64/32 issue with Excel files
Hi all, I'm trying to do classic scenario for loading multiple Excel files into...
Case part is sloooooow
Hi So the case statement is slowing this down - but for the life...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('tim', 'tom')
Assume preview features are enabled. See possible answers