Finding nested references
I originally planned this post just as an answer to DBA Stack Overflow question: How can I get the list of tables in all the stored procedure? After preparing...
2024-09-13 (first published: 2024-08-26)
240 reads
I originally planned this post just as an answer to DBA Stack Overflow question: How can I get the list of tables in all the stored procedure? After preparing...
2024-09-13 (first published: 2024-08-26)
240 reads
Make it easier for your audience to engage with you by connecting your site to the fediverse.
2024-09-13
5 reads
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in the Databases module where an unprintable ASCII character was being inserted at the beginning of...
2024-09-12
30 reads
As part of my job, I needed to research how a few things work with Synapse and Fabric. The latter includes the former, mostly. I decided to setup a...
2024-09-11 (first published: 2024-08-26)
139 reads
Are you ready to have conversations with your data? Announced in public preview within Microsoft Fabric is AI Skill, a new capability in Fabric that allows you to build...
2024-09-11 (first published: 2024-08-26)
282 reads
With my new laptop, one of the things I realized I’d forgotten to do in setup is reserve some space. I wrote about this years ago, but I wanted...
2024-09-11
19 reads
This month we have a good invitation from Deepthi Goguri, where she asks us about a technical problem. I think most of are technical people and we solve problems...
2024-09-10
24 reads
2024-09-10
9 reads
I was privileged to host yet another T-SQL Tuesday, for the month of August, 2024. My topic was on Managing database code. I was worried about getting responses, given...
2024-09-09 (first published: 2024-08-18)
291 reads
Yeah, stupid long title. It’s a question I put to several different AI engines. I’m curious what the aggregated knowledge of the internet has to say on the topic...
2024-09-09 (first published: 2024-08-19)
294 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...
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