Installing Windows Server 2016 Nano on a Physical Server
Hey guys! So here's my adventure in deploying Windows Server 2016 Nano on a physical server. It was a hard...
2017-02-27
828 reads
Temporary Post Used For Theme Detection (34836190-9a25-42fe-be54-415469756264 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (4211c8dc-abcd-4ab4-b505-10f305aa9533 - 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2011-12-14
516 reads
2011-12-14
596 reads
WAN Optimization–Part 2
After installing the WAN optimization appliances on all of our main sites, we have liked what we’ve seen thus far....
2011-12-05
660 reads
WAN Optimization Evaluation Review–Part 1
We are evaluating a WAN optimization vendor and have so far installed the appliance at the primary site and end-user’s...
2011-11-30
1,882 reads
WAN Optimization Solutions–Input Needed Please!
I was just wondering if anyone has a WAN optimization solution as part of their infrastructure. I have a few...
2011-11-02
738 reads
Fatal Error Emails This Morning…
So every morning I check my email on my phone. Normally, I don’t see any error emails from SQL Server...
2011-11-01
698 reads
I/O Error On TempDB
I was running a DBCC CHECKDB on a database when I got an error that says:
Msg 0, Level 11, State...
2011-10-28
1,875 reads
An Update To My Previous Post
I have picked Row compression and moved it out of [Primary] and into its own FileGroup and .NDF file. I’ve...
2011-05-13
549 reads
My Partitioning And Compression Quest! (Continued)
Thank you, David C, for your comment! Please see below to the answers to
your questions.
The table structure is:
CREATE TABLE...
2011-05-05
890 reads
Blogs
PASS Data Community Summit 2024 Day 3 Keynote
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
A New Word: Skidding
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
PASS Summit – Thursday
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
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