SQL Server, PostgreSQL and the Future
This is just a quick note to talk about the future, mine, yours and this blog. First, I’m not abandoning SQL Server. I’m actively working on a revision of...
2022-02-09
56 reads
Database Projects 101 in Azure Data Studio (Calgary Data User Group)
On Wednesday February 23rd, 2022, the Calgary Data User Group will be hosting our first user group session of the year, featuring Warwick Rudd. The topic is an introduction...
2022-02-09
22 reads
Daily Coping 9 Feb 2022
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...
2022-02-09
14 reads
Thrilled to #BITS!
2021 was a strange year…mid way through a pandemic, enormously depressing on many fronts to me..and yet, it bought with it some unexpected joys. I never imagined, in the...
2022-02-09
20 reads
BlitzBlockingChain, Getting Blocking Chains from sp_BlitzWho
I’m going to assume that most people will have at least heard of Brent Ozar’s brilliant First Responder Kit. If you haven’t then you’ve been missing out on some...
2022-02-09
116 reads
Data Thoughts – T-SQL Tuesday #147 – Upgrade Strategies
G’day, This months T-SQL Tuesday (January 2022) invite is brought to you by Steve Jones – @way0utwest Steve’s asked us to write about “Planning for upgrades“ In the not...
2022-02-08
19 reads
Upgrade Strategies – T-SQL Tuesday #147
This month’s T-SQL Tuesday is about how we look at SQL Server upgrades, hosted by Steve Jones. My experience of SQL upgrades is that they tend to be largely...
2022-02-08
22 reads
Boost Your Career with #SQLNewBlogger
A few years ago Ed Leighton-Dick started the #SQLNewBlogger challenge. He asked people to start writing about their career and building their own brand. I thought it was a...
2022-02-08
24 reads
Data Lakehouse, Data Mesh, and Data Fabric
(NOTE: I have returned to Microsoft and am working as a Solution Architect in Microsoft Industry Solutions, formally known as Microsoft Consulting Services (MCS), where I help customers build...
2022-02-08
62 reads
Daily Coping 8 Feb 2022
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...
2022-02-08
17 reads
Blogs
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...
SQL Server Security Hardening Guide Using the DoD STIG Checklist
Security on your SQL Server is important. That doesn’t need any explaining. But where...
EightKB 2026: Registration is Open!
It’s that time of year again! EightKB is back on August 20th at 13:00...
Forums
Backing Up a DMK
Comments posted to this topic are about the item Backing Up a DMK
Are You Working More Hours?
Comments posted to this topic are about the item Are You Working More Hours?
Stairway to Reliable Database Deployments Level 6 – Managing Changesets Over Time
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
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