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

Making a Change Log Easier With PowerShell

by Rob Sewell

SQL DBA With A Beard

Having a Change Log is a good thing. A quick and simple place to find out what has changed on...

2014-12-16 (first published: 2014-12-08)

5,137 reads

Giving Back – #TSQL2sday

by Rob Sewell

SQL DBA With A Beard

T-SQL Tuesday, which was started by Adam Machanic (blog|twitter) and is now starting its 6th year, is hosted by a...

2014-12-09

787 reads

A look at the SQL Assessment Intelligence Pack in Operational Insights

by Rob Sewell

SQL DBA With A Beard

Operational Insights is a service that has been added in preview to Azure. It enables you to collect, combine, correlate...

2014-11-28 (first published: 2014-11-24)

6,781 reads

Changing Delay Between Responses for SQL Alerts with Powershell

by Rob Sewell

SQL DBA With A Beard

So you have read that you should have alerts for severity levels 16 to 24 and 823,824 and 825 on...

2014-11-28 (first published: 2014-11-18)

7,120 reads

#tsql2sday #60 – Something New Learned – Problem Step Recorder

by Rob Sewell

SQL DBA With A Beard

What is T-SQL Tuesday?

T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party...

2014-11-11

2,399 reads

Generating T-SQL Randomly with Powershell

by Rob Sewell

SQL DBA With A Beard

I have a lab on my laptop running various servers so that I can problem solve and learn and recently...

2014-11-05

540 reads

Emailing Disk Space Alerting With Powershell

by Rob Sewell

SQL DBA With A Beard

A DBA doesn’t want to run out of space on their servers, even in their labs! To avoid this happening...

2014-11-04

4,857 reads

Number of VLFs and Autogrowth Settings Colour Coded to Excel with PowerShell

by Rob Sewell

SQL DBA With A Beard

So you have read up on VLFs
No doubt you will have read this post by Kimberly Tripp and this one...

2014-10-06

694 reads

PowerShell Snippets A Great Learning Tool

by Rob Sewell

SQL DBA With A Beard

When I talk to people about Powershell they often ask how can they easily learn the syntax. Here’s a good...

2014-09-09

707 reads

Find Out Which Indexes are on which Filegroups using PowerShell And How To Find Other Information

by Rob Sewell

SQL DBA With A Beard

A short post today to pass on a script I wrote to fulfil a requirement I had.
Which indexes are on...

2014-09-07

515 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

How Generative AI is Changing the Game for Developers and Businesses

Generative AI is revolutionizing various industries by streamlining operations and enhancing creativity. In marketing,...

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...

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