NJ SQL UG Event: SQL Server 2008 Database mirroring - MAK
May 17th NJSQL UG Meeting - SQL Server 2008 Database mirroring with MAK
Date: Tuesday, May 17th
Topic: SQL Server 2008...
2011-05-17
878 reads
Robert Pearl
SQL Server News, Upcoming Local Events & Webinars.........
Wow! It's only Tuesday, and there's so much going on in the SQL Server World! I wanted to share some...
2011-05-17
661 reads
TSQL Tuesday #18 - Using CTE to Analyze Disk IO
(TSQL Tuesday on Wednesday! - Apologies for the late entry - better late than never)
Today’s topic is CTE’s.Scientifically speaking, solids mostly expand...
2011-05-11
1,999 reads
More SQL Server 2008 Installation Issues
Robert Pearl brings us a few more potential SQL Server 2008 installation issues on Windows 7 and a few workarounds that might help you get around them.
2011-05-05
5,502 reads
SQL Server 2008 Installation Issues - Issues and Workarounds
MVP Robert Pearl explains how to get around some common issues that might occur when installing SQL Server 2008 on Windows 7.
2011-04-28
7,355 reads
Another neat idea - The Mentoring Experiment
Another neat idea from the co-founders of SQLServerCentral.com, Steve Jones and Andy Warren, the mentoring experiment has been launched, and...
2011-04-22
1,804 reads
T-SQL Tuesday - Using APPLY to find out which queries are running on which CPU...
When I saw that Matt Velic's is hosting T-SQL Tuesday, and he has invited the SQL commmunity to participate, I was very...
2011-04-12
2,889 reads
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-07
12,319 reads
SQL Validation Functions - 4 Cool UDF's to have handy
Everyone knows that in SQL 2000, yes 2000, Microsoft jumped aboard the bandwagon of other platforms, and gave the developers...
2011-04-05
40,607 reads
Meme Monday - what the heck? - OK I'll bite!
Thomas "Tommy Boy SQLRockStar" LaRock proposed a Meme Monday and challenged us to write a SQL Server related story in eleven words...
2011-04-04
888 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