Red Gate SQL Response Review is up
Full Disclosure: I did receive a trial version of the software and payment for the review. I am also a...
2008-10-08
962 reads
Do You Love PASS?
Recently Tony Davis posted some thoughts (almost a rant) about his opinions of PASS, and there is a great follow...
2008-10-07
699 reads
Database Administration Librarian
If I cannot find a book or info in a library, I always go to a librarian for advice and...
2008-10-07
618 reads
Can't Attend SQL Server Training in Person, Consider Virtual Training
I am one of the biggest advocates there is of self-education. Whether you are a novice, intermediate, or expert-level DBA,...
2008-10-07
1,008 reads
Always more to do
My current "to do" list, which is only partially written down and organized. Putting it all one one list is...
2008-10-07
394 reads
Rendering code nicely in blogs and forums.
I wrote the prettifier specifically to help with posting SQL into blogs and forums. You can find it here http://extras.sqlservercentral.com/prettifier/prettifier.aspx...
2008-10-07
6,674 reads
The Call for Nominations to the SQL PASS Board of Directors is Now Open Until October 24, 2008
If you have ever considered taking a leadership role in PASS, you should seriously consider becoming a SQL PASS board...
2008-10-07
416 reads
The Best Database Engine - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-07
365 reads
Notes on Went Well & What We Could Have Done Better - From SQLSaturday #8
As I mentioned yesterday things went pretty well, but always room for improvement. Here are some notes, if nothing else...
2008-10-06
297 reads
Final Reminder - SQLSaturday #5 & #9 Coming Up on October 11, 2008
You can find details about these great free events at www.sqlsaturday.com. It's definitely been interesting watching them grow from afar...
2008-10-06
312 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
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