I Learned a New Word
Do you know what a Geoid is?
I’ve been working my way through Beginning Spatial with SQL Server 2008, actually “through”...
2009-06-03
658 reads
Blog Posts
Scripting Our Daily (Professional) Lives
I talk a lot about scripting tasks on our servers to automate our regular processes, but in this case I'm...
2009-06-03
347 reads
Seatguru - Getting a Good Seat on the Plane
Ran across this a while back and just getting to it, Seatguru is a site that lets you figure out...
2009-06-03
391 reads
Speaking at SQLSaturday #14 in Pensacola on June 6, 2009
I'm driving over tonight to spend a long weekend in Pensacola (6-7 hour drive from Orlando) for their first SQLSaturday,...
2009-06-03
470 reads
SQLServerCentral Article on Backup Monitoring and Reporting
The article, Backup Monitoring and Reporting, demonstrates a SQL Server backup reporting solution I use in my production environment. Some highlights of...
2009-06-03
1,328 reads
TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8
This is based on the original post in Franglais.
The goal of this post is to explain how to handle errors...
2009-06-03
2,492 reads
Balancing Priorities
This one isn't a technical post, but it's entirely appropriate to those of us in the IT field. Today was a...
2009-06-02
775 reads
Other Desktops
The USB not in Hyper-V thing is annoying. It actually made me stop and consider my alternatives for a desktop....
2009-06-02
773 reads
Notes on SQLSaturday #7
I flew up to Birmingham Friday for SQLSaturday #7 organized by John Baldwin from Steel City SQL and a lot...
2009-06-01
712 reads
Reminder - SQLSaturday #12 in Portland is June 6, 2009
Ken Starnes from the Portland group will be having their first event on June 6th. I like the way they've...
2009-06-01
299 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Forums
Symmetric Key Encryption
Comments posted to this topic are about the item Symmetric Key Encryption
The “Successful Login” Dilemma: Why Your Login Auditing Strategy Might Be Hurting Your Server
Comments posted to this topic are about the item The “Successful Login” Dilemma: Why...
Building Your Own Software
Comments posted to this topic are about the item Building Your Own Software
Question of the Day
Symmetric Key Encryption
If I run this statement in SQL Server 2025, how is the password encrypted?
CREATE SYMMETRIC KEY MySymmetricKey WITH ALGORITHM = AES_256, KEY_SOURCE = 'My secret key source passphrase', IDENTITY_VALUE = 'My secret identity value' ENCRYPTION BY PASSWORD = 'S&perS#cretP@ssword7'; GOSee possible answers