Rob Sewell

Rob was a SQL Server DBA with a passion for Powershell, Azure, Automation, and SQL (PaaS geddit?). Now he just helps people. He is a Cloud and Data Center MVP and a Data Platform MVP, an officer for the PASS DevOps Virtual Chapter, co-leader of Data South West and PSConf EU organiser and has spoken at and volunteered at many Data and PowerShell events all over the world. He is a proud supporter of the Data and Powershell communities.

He relishes sharing and learning and can be found doing both via Twitter and his blog. He spends most of his time looking at a screen and loves to solve problems. He knows that looking at a screen so much is bad for him because his wife tells him so. Thus, you can find him on the cricket field in the summer and flying a drone in the winter.

He has a fabulous beard

Twitter: @@SQLDbaWithBeard
LinkedIn: https://linkedin.com/in/robsewellsqldba

Using Docker to run Integration Tests for dbachecks

by Rob Sewell

SQL DBA With A Beard

My wonderful friend André Kamman wrote a fantastic blog post this week SQL Server Container Instances via Cloudshell about how...

2019-02-06 (first published: 2019-01-19)

2,251 reads

Running Windows and Linux SQL Containers together

by Rob Sewell

SQL DBA With A Beard

Just for fun I decided to spend Christmas Eve getting Windows and Linux SQL containers running together.

WARNING
This is NOT a...

2019-01-04 (first published: 2018-12-24)

1,852 reads

SQL Server Availability Group FailoverDetection Utility PowerShell Function Improvements – Named Instances, Archiving Data, Speed

by Rob Sewell

SQL DBA With A Beard

In my last post I wrote about a new function for gathering the data and running the FailoverDetection utility by...

2018-12-19 (first published: 2018-12-01)

1,843 reads

Gathering all the Logs and Running the Availability Group Failover Detection Utility with PowerShell

by Rob Sewell

SQL DBA With A Beard

30/11/2018 – Function has been updated to deal with named instances.
Last week the Tiger Team released their Availability Group Failover Detection...

2018-12-17 (first published: 2018-11-28)

1,960 reads

Getting the SQL Version from a backup using dbatools ………. on PowerShell Core

by Rob Sewell

SQL DBA With A Beard

Following an upgrade to SQL Server the backup share had a number of backups, some from the old version and...

2018-12-12 (first published: 2018-11-26)

1,706 reads

Getting SQL Services, Starting, Stopping and Restarting them with dbatools

by Rob Sewell

SQL DBA With A Beard

There was a question in the #dbatools slack channel

Getting dbatools
dbatools enables you to administer SQL Server with PowerShell. To get...

2018-12-03

245 reads

PASS Summit, SQLTrain and My First US SQL Saturday

by Rob Sewell

SQL DBA With A Beard

Next week is the week when I used to dread looking at Twitter and especially the #PASSsummit hashtag, watching all of...

2018-10-31

251 reads

Checking Trace Flags with dbachecks, online docs and PSPowerHour

by Rob Sewell

SQL DBA With A Beard

It’s been a few weeks since i have blogged as I have been busy with a lot of other things....

2018-10-10 (first published: 2018-09-29)

1,944 reads

Deploying To a Power Bi Report Server with PowerShell

by Rob Sewell

SQL DBA With A Beard

Just a quick post to share some code that I used to solve a problem I had recently.
I needed to...

2018-09-04 (first published: 2018-08-21)

5,327 reads

A PowerShell Conference In A Book

by Rob Sewell

SQL DBA With A Beard

A Question
Shortly after the European PowerShell Conference and the PowerShell and Devops 2018 summit in the USA Mike Robbins b...

2018-08-17 (first published: 2018-08-01)

2,736 reads

Blogs

Day 2 at PASS Data Community Summit 2024

I missed blogging yesterday as I was on stage/backstage for quite a bit of...

PASS Summit 2024 – Wednesday

By Brian Kelley

A common theme in the PASS Summits I've attended is community and that's definitely...

Taming Database Challenges: Insights from Redgate Keynote

I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...

Read the latest Blogs

Forums

Step by step guide to setup PostgreSQL on Docker

By Arvind Toorpu

Comments posted to this topic are about the item Step by step guide to...

Backing up the Database Encryption Key

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Backing up the Database Encryption...

Technology Fears

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Technology Fears

Visit the forum

Question of the Day

Backing up the Database Encryption Key

In my SQL Server 2022 database, I run this:

USE Sales;  
GO  
CREATE DATABASE ENCRYPTION KEY  
WITH ALGORITHM = AES_256  
ENCRYPTION BY SERVER CERTIFICATE MyServerCert;  
GO

This works, but I want to prepare for the future and potential issues. How do I back up my DEK?

See possible answers