[Video] Azure SQL Database – Import a Database
Quick Video showing you have to use a BACPAC to “import” a database into Azure (Via Storage container),
2020-12-03
86 reads
Requesting Comments on the SQLOrlando Operations Manual
For the past couple weeks I’ve been trying to capture a lot of ideas about how and what and why we do things in Orlando and put them into...
2020-12-02
54 reads
Ignoring Comments in SQL Compare
Recently I had a client that wanted to know how they could use SQL Compare to catch actual changes in their code, but not have comments show up as...
2020-12-14 (first published: 2020-12-02)
220 reads
PASS SQLSaturday’s I will be speaking at
I will be speaking at two upcoming PASS SQLSaturday’s. These are free events that you can attend virtually: Azure Synapse Analytics: A Data Lakehouse 12/5/20, 1:10pm EST, PASS SQL...
2020-12-02
32 reads
T-SQL Tuesday Retrospective #006: What about blob?
I am revisiting old T-SQL Tuesday invitations from the very beginning of the project. On May 3, 2010, Michael Coles invited us to write about how we use LOB...
2020-12-02
26 reads
Daily Coping 2 Dec 2020
I 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-12-02
17 reads
SQL Database Corruption, how to investigate root cause?
Introduction:
In this article, we will discuss the MS SQL Server database corruption.
So, first, we need to understand what the cause of corruption is. Usually, in all the scenarios of...
2020-12-02
24 reads
SQL Database Corruption, how to investigate root cause?
Introduction:
In this article, we will discuss the MS SQL Server database corruption.
So, first, we need to understand what the cause of corruption is. Usually, in all the scenarios of...
2020-12-02
220 reads
New-DbatoolsQuestion | Invoke-DbatoolsDiscussion -Platform Github
Chrissy LeMaire (blog | twitter) pinged me earlier this week to tell me about Github Discussions. It’s a new feature of Github which is similar to Stack Exchange, but...
2020-12-02
7 reads
Would You Pass the SQL Server Certifications Please? What Do You Mean We're Out?
I have held various certifications through my DBA career, from CompTIA A+ certification back when I worked help desk (I'm old) through the various MCxx that Microsoft has offered...
2020-12-10 (first published: 2020-12-01)
672 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
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
BIT_COUNT in SQL Server
Comments posted to this topic are about the item BIT_COUNT in SQL Server
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