Is NoSQL still a thing?
G’day, Looking back, perhaps one of the (many) mistakes that I’ve made in my career was to initially ignore the N0SQL movement. I’ve focused my career on Relational Database...
2020-01-27
40 reads
Blog Posts
sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue reading sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019 ?
2020-01-27
609 reads
Do It Live! A First Look at Redgate’s Hybrid Model for SQL Source Control and SQL Change Automation (video)
In this 70 minute livestream recording, I kick the tires of a fresh new Azure DevOps demo environment showing Redgate’s Hybrid Model for SQL Source Control and SQL Change...
2020-01-25
42 reads
Azure Storage tips
As a followup to my blog post Azure Data Lake Store Gen2 is GA, I wanted to give some pointers when using ADLS Gen2 as well as blob storage,...
2020-01-24 (first published: 2020-01-16)
442 reads
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own key (BYOK) functionality for transparent data encryption (TDE). This functionality has been in the singleton...
2020-01-24
42 reads
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own key (BYOK) functionality for transparent data encryption (TDE). This functionality has been in the singleton...
2020-01-24
35 reads
Bring Your Own Key to Azure SQL Database Managed Instance TDE
Last year Azure SQL Database Managed Instance saw the introduction of bring your own key (BYOK) functionality for transparent data encryption (TDE). This functionality has been in the singleton...
2020-01-24
36 reads
How I passed the 70-761 certification exam
FUN FACT: I have been a Microsoft Certified Professional for SQL Server for over 20 years. Second FUN FACT: the last time I took a Microsoft certification exam was...
2020-01-24 (first published: 2020-01-18)
1,147 reads
CRM Data Source Connection Error
This article takes us to the edge with a couple of CRM related errors after changing the service account to a more secure Managed Service Account. Despite the CRM...
2020-01-23
18 reads
Looking forward to 2020
2019 was a busy year for me. I presented sessions in over 10 countries, averaging speaking at two conferences per month. I also helped organise Data Relay and attended...
2020-01-23
11 reads
Blogs
Prep data for AI vs. Fabric Data Agent Instructions: What Goes Where?
By James Serra
Making Data AI-Ready, Part 3 (This is the final article in a three-part series...
Keeping Track of my ConEmu CLIs
By Steve Jones
I use ConEmu for my terminal interface. I’m still on Windows 10 at home,...
10 Decisions to Make Before You Create A Fabric Workspace
Creating a Fabric workspace takes about 30 seconds. Restructuring workspaces after people have built...
Forums
Hyperscale Replicas III
Comments posted to this topic are about the item Hyperscale Replicas III
Development Is Fun
Comments posted to this topic are about the item Development Is Fun
Optimized Locking in SQL Server 2025
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Question of the Day
Hyperscale Replicas III
In an Azure SQL Database Hyperscale Edition, how many named replicas can be configured?
See possible answers