Should Apps Use a Dedicated Port?
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,969 reads
Most applications connect on whatever the default port is, typically 1433 for SQL, though it’s common to change that to...
2012-07-24 (first published: 2012-07-18)
1,969 reads
The question was posed on Twitter recently (or perhaps more along the lines of “why can’t we”), suggesting that our...
2012-07-23
769 reads
With both Steve Jones and I done with our summer break, we’re ready to continue with several experiments we’ve been...
2012-07-23 (first published: 2012-07-19)
2,558 reads
Back in February I did a presentation for MagicPASS that ran long, maybe 30 minutes over the time allotted. It...
2012-07-20
825 reads
Quick notes from the MagicPASS meeting:
Kendal Van Dyke still the king when it comes to explaining what’s going on with...
2012-07-19
716 reads
If there is anything better than a SQLSaturday it’s a SQLSaturday with a choice of great pre-con speakers. This year...
2012-07-19
700 reads
I’ll be back on the road again in August, heading up to Cleveland for SQLSaturday #164. It’s my first time...
2012-07-17
620 reads
I’m a little late posting this, but I had two sessions accepted out of four I submitted. I’ll be doing...
2012-07-16
536 reads
Nine more speakers we’re pleased to say will be joining us for a fabulous SQLSaturday in Orlando!
Timothy McAliley
Juan Soto
Erika Bakse
Jose...
2012-07-16
656 reads
More speakers from Florida! Scott Klein lives in Seattle now, but we still consider him an honorary Floridian according to...
2012-07-15
640 reads
By Steve Jones
It’s been an amazing week here, as well as a long week. I’m tired,...
By Steve Jones
skidding – v. intr. the practice of making offhand comments that sound sarcastic but...
By Brian Kelley
Let’s start with the keynote. The biggest take away was how having to support...
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