Automating AlwaysOn Availability Group Failover for SSISDB 2012/2014
Hopefully not many people are still configuring SSIS instances on SQL 2012 or 2014 – especially HA instances – but if you are, this post is for you. If...
2021-05-28
156 reads
Daily Coping 27 May 2021
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...
2021-05-27
19 reads
The WITDC Mental Health and Wellness day and why July 2020 really sucked for me.
I recently gave a presentation at the WITDC Mental Health and Wellness day. The recordings are out and here’s the ... Continue reading
2021-06-11 (first published: 2021-05-27)
219 reads
A Basic Encryption Primer for SQL Server
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Encryption is a function call in SQL Server,...
2021-06-09 (first published: 2021-05-26)
614 reads
How I tackle disaster recovery
One of my special interests as an autistic person is understanding mechanical components of a computer, both analog and digital. In the olden days, we had devices known as...
2021-05-26
28 reads
Daily Coping 26 May 2021
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...
2021-05-26
24 reads
Daily Coping 25 May 2021
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...
2021-05-25
22 reads
What account is xp_cmdshell using?
It works when I run it this way™ but not when I run it through xp_cmdshell! It’s a permissions issue. ... Continue reading
2021-05-25
136 reads
The Best of Both Worlds: WordPress.com Managed Hosting
How you can get the total freedom to create without the hassles that come with managing your own website. The open source WordPress project has given the world a...
2021-05-24
35 reads
Daily Coping 24 May 2021
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...
2021-05-24
13 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
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