Don’t want to read all this? There are two dotnet interactive notebooks here with the relevant information for you to use. https://beard.media/dotnetnotebooks Jaap is awesome I have to start...
2020-07-29 (first published: 2020-07-18)
493 reads
Following on from yesterdays post about creating an overview of SQL Agent Job Results and sending it to a Teams channel, I was given another challenge Can you write...
2020-07-29
651 reads
Following on from my last post about the Secret Management module. I was asked another question. > Can I use this to run applications as my admin account? A...
2020-07-20
78 reads
I have always been extremely proud to be a Cloud and Datacenter Management MVP, and lucky enough to be involved with both the PowerShell community as well as the...
2020-07-01
9 reads
Azure Data Studio is a great tool for connecting with your data platform whether it is in Azure or on your hardware. Jupyter Notebooks are fantastic, you can have...
2020-04-09 (first published: 2020-03-30)
623 reads
I am sat in the PowerShell Saturday in Hamburg. You can see me on the right of this picture writing my previous blog post! I was talking with my...
2020-02-22
42 reads
Data Science folk used Notebooks for documentation and to show re-runnable research. Azure Data Studio included this notebook functionality and added SQL kernel where with a little bit of...
2020-02-07
56 reads
I enjoying maintaining open source GitHub repositories such as dbachecks and ADSNotebook. I absolutely love it when people add more functionality to them. To collaborate with a repository in...
2019-11-29
19 reads
The PowerShell module for validating your SQL Server estate dbachecks is deployed via Azure DevOps, you can see how it is working (or not) via this link
Grrr Automation for...
2019-11-26
89 reads
Now that Azure Data Studio has PowerShell Notebooks and there is a PowerShell Module for creating notebooks. I have been asked, more than once, what is the point? What...
2019-11-21
15 reads
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...
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Generative AI is revolutionizing various industries by streamlining operations and enhancing creativity. In marketing,...
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...
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