Using Twitter with VS Code
So today I saw this tweet from Mathias in reply to Stefan and Amanda
That looks cool. Twitter in VS Code, one...
2017-04-28 (first published: 2017-04-19)
995 reads
So today I saw this tweet from Mathias in reply to Stefan and Amanda
That looks cool. Twitter in VS Code, one...
2017-04-28 (first published: 2017-04-19)
995 reads
I was chatting on the SQL Community Slack with my friend Sander Stad b | t about some functions he is writing for...
2017-04-26
432 reads
A good security practice is to backup our SQL Servers to a network share but not allow users to be...
2017-04-13 (first published: 2017-04-08)
1,244 reads
Last week I was showing a co-worker some PowerShell code and he asked what the editor was that I was...
2017-04-13
458 reads
In previous posts I have shown how to use Test-DbaLastBackup from dbatools and how you can make use of the...
2017-04-11 (first published: 2017-03-25)
1,615 reads
WARNING – Contains Orange and light-hearted photos
I have returned home from SQLBits 2017 The Disco Edition. I am exhausted, my...
2017-04-11
540 reads
There are times when DBA’s are required to export database user permissions to a file. This may be for a...
2017-04-10
2,207 reads
SQL Server uses identity columns to auto generate values, normally keys. When you create an identity column, it has a...
2017-04-07
555 reads
With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it...
2017-04-06 (first published: 2017-03-22)
1,821 reads
In my last post I showed Get-DbaLastGoodCheckDb from dbatools. This module is a community based project written by excellent, brilliant...
2017-04-06
505 reads
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Steve Jones
I missed blogging yesterday as I was on stage/backstage for quite a bit of...
By Brian Kelley
A common theme in the PASS Summits I've attended is community and that's definitely...
Comments posted to this topic are about the item Step by step guide to...
Comments posted to this topic are about the item Backing up the Database Encryption...
Comments posted to this topic are about the item Technology Fears
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; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers