Missing Biometric devices Node in Device Manager
If you have a Windows Hello compatible device (face or finger-print) and you are unable to use it, make sure Device Manager has a node for Biometric devices (see...
2020-05-21
10,642 reads
Blog Posts
Power Up: Exploring the Power BI Ecosystem, May 27-28
Next week I’m speaking at at the Dynamic Communities Power Up event titled “Exploring the Power BI Ecosystem“. It takes place on May 27 & 28, 2020. This exciting...
2020-05-21
24 reads
An insidious form of SQL injection
As longtime readers know, I am also a software developer (we can’t call them engineers in Canada for legal reasons). I took over a complex codebase last year in...
2020-05-20
277 reads
ASF 031: Paul Andrew interview
Introduction Paul Andrew. Principal consultant and architect at Altius specialising in big data solutions on the Microsoft Azure cloud platform. Data engineering competencies include Azure Data Factory, Data Lake,...
2020-05-20 (first published: 2020-05-02)
147 reads
Build announcements: Azure Synapse Analytics in public preview and more
A few data platform announcements yesterday at Microsoft Build that I wanted to blog about. The biggest one is Azure Synapse Analytics is now available in public preview! You...
2020-05-20
334 reads
Connecting to Azure SQL Database: Requested tenant identifier ‘00000000-0000-0000-0000-000000000000’ is not valid.
The other day I got this rather interesting error while connecting to an Azure SQL DB. I was connecting using ... Continue reading
2020-05-20
109 reads
Connecting to SSAS–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. In a previous post, I installed SSAS on...
2020-05-20
35 reads
Daily Coping 20 May 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2020-05-20
23 reads
JSON, SQL Server and Esacpe Characters of the non-printable kind
G’day, We observed in a previous installment that JSON uses the backslash character “” as the escape character. However, what happens if we actually want a backslash in our...
2020-05-20
157 reads
Query Acceleration for ADLS
Just announced is Query Acceleration for Azure Data Lake Storage Gen2 (ADLS) as well as Blob Storage. This is a new capability for ADLS that enables applications and analytics...
2020-05-20 (first published: 2020-05-04)
446 reads
Blogs
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Car Update: August 2026
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
Microsoft Fabric OneLake Shortcuts: When to Use Them and When Not To
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
Forums
Managing Incidents and Fighting Fires
Comments posted to this topic are about the item Managing Incidents and Fighting Fires
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
The Quiet Part
Comments posted to this topic are about the item The Quiet Part
Question of the Day
Backing Up a DMK
In SQL Server 2025, I have a database with a Database Masker Key (DMK). I want to back up this key and keep a copy offline. When do I have to open this key before running the backup?
See possible answers