"To Lead Is To Follow"
I first ran across these words as a Citadel cadet. Now those who know of my days at El Cid...
2008-10-19
829 reads
Run Your Business as a Business
I’ve thought this for a long time: you need to run your business as a business, not an investment. Too...
2008-10-19
881 reads
Speaking in West Palm Beach and Orlando
I have two speaking engagements for the week of October 19:
South Florida SQL Server User Group - West Palm Beach - October...
2008-10-18
694 reads
When Do You Know That You Know
Why, when you can help others, that's when!
In my role as a senior Moderator with the MSDN SQL Forums, I am often...
2008-10-17
455 reads
The Financial Crisis - Why Did I Write This?
I've had a bunch of writings based on finances over the last couple weeks, and I've tried to spread them...
2008-10-17
660 reads
Uninstalling Software (Sucks) and Why Computers Are Still Slow
I've just recently acquired a new laptop and my resolution is to install no software on it that I'm not...
2008-10-16
675 reads
What's Your Job Title?
As I travel and visit DBAs from around the United States, I am always surprised at the job titles DBA...
2008-10-16
641 reads
How Many Drive Letters Do You Use for SQL Server?
I was teaching a private class recently that had both DBA's and network types in the room, one of the...
2008-10-16
822 reads
Looking for Free Educational Events to Attend?
Every week, there are dozen of free educational events to attend throughout the United States. The sad part is that...
2008-10-15
627 reads
Big and Small - Why Did I Write This?
I've always been very concerned about where I work. Well, maybe not always, since early in my career I took...
2008-10-15
633 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