SQL Server 2011 “Denali”: Give feedback and win nice gifts
Microsoft SQL Server guys extended periods for Denali’s feedback on Microsoft Connect. And they motivates with really nice gifts for...
2011-09-05
644 reads
Blog Posts
The Principle of Least Privilege – Skill #3
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-09-05
5,538 reads
When technology works.
Living in the South East has it perks with the abundant rivers, lakes, streams, mountains, and friendly people. It also...
2011-09-05
416 reads
Youngest MCM in the world?
As part of my MCM preparation (Have to study aggressively at least for next 2 years) , I have downloaded almost all readiness...
2011-09-05
1,494 reads
OT: Rant About Mail-in Rebates For Computer Hardware
As you may know from reading my blog, I buy quite a bit of computer hardware components from places like...
2011-09-04
733 reads
PASSion Award Nominations
PASSion Award
One of the things that makes PASS a successful organization is the volunteers. To show it’s appreciation for these...
2011-09-04
1,501 reads
2011-09-03
347 reads
Server sudden shutdown unavailable
It’s not always straightforward to diagnose a server problem. You look through the SQL Server Logs and Event Viewer for...
2011-09-03
1,054 reads
Task Factory: Advanced Email and SMS Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,698 reads
Task Factory: Compression Task
Task Factory is a software product created by Pragmatic Works. It provides many custom SSIS components which help developers creating...
2011-09-03
1,392 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