SQL Server Configuration Manager : Cannot connect to WMI provider – Invalid class [0x80041010]
Following error dialog pops up today, when I tried connecting to SQL Server Configuration Manager on my SQL Server 2008...
2012-06-06
24,979 reads
Blog Posts
SQLSaturday #164 Cleveland – Tick tock, people!
If you haven’t already heard, Cleveland is hosting SQLSaturday #164 on August 18. That date is coming up fast and...
2012-06-06
634 reads
Unable to recycle SQL Agent log: SQLServerAgent Error: 32.
Today the maintenance job that recycles the SQL Agent error log failed on one of our production SQL Server with...
2012-06-06
2,530 reads
Detecting Database Option Changes with DDL Triggers
One of the keys to managing a large production SQL Server environment is being aware of changes that are taking...
2012-06-05 (first published: 2012-05-29)
5,031 reads
Download: Consolidated Denali a Day – May 2012
Download: Consolidated Denali a Day – May 2012 If you like what’s New in Denali (Sql server 2012) a day, for...
2012-06-05
933 reads
Guest Blog
I was given the opportunity to put together a guest blog post for the MVP blog. I did a little...
2012-06-05
938 reads
New SSIS 2012 Expressions
SSIS 2012 has added a few new expression functions and I thought I’d spend a short time detailing each.
LEFT
The LEFT...
2012-06-05
2,369 reads
Parallel Processing For Pros
Hi,
Yesterday I delivered a session on Parallel Processing at the Israeli User Group.
I had a great time and hope you...
2012-06-05
313 reads
Review of “Start Here! Learn Microsoft Visual C# 2010?
Disclaimer: I wrote this review as a participant to O’Reilly Blogger Review Program.
If you’ve never seen a programming code in...
2012-06-05
1,066 reads
“Green” Database Administration
For the past few years, I have seen tens of sql server boxes added in my work environment every year,...
2012-06-04
4,627 reads
Blogs
Day 2 at PASS Data Community Summit 2024
By Steve Jones
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
By Chris Yates
I am excited to cover the Microsoft Keynote on Day 2: Redgate Keynote: Simplifying...
Forums
Step by step guide to setup PostgreSQL on Docker
Comments posted to this topic are about the item Step by step guide to...
Backing up the Database Encryption Key
Comments posted to this topic are about the item Backing up the Database Encryption...
Technology Fears
Comments posted to this topic are about the item Technology Fears
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; GOThis works, but I want to prepare for the future and potential issues. How do I back up my DEK? See possible answers