I Don’t Know
I wanted to write this because lately I say “I don’t know” a couple times a day to my client/boss....
2011-09-14
629 reads
Blog Posts
Normalize your Linked Server Names
This is a technique I’m sure many people are already using in their environments. Instead of using the actual name...
2011-09-14
3,609 reads
Speaking at SQL Saturday 89
With a late cancellation with one of our speakers a hole was opened on our speaker lineup. I reached out...
2011-09-14
427 reads
SQL Saturday #92 Lunch: Bend Area Gathering
There's nothing more I love than free food and SQL Server, no joke. I take my free food and SQL...
2011-09-14
528 reads
SQL Server “Denali”: Installing on a Virtual Machine
With CTP3 for SQL Server Denali available, a lot of us want to play with all the new cool features, as well as...
2011-09-14
1,736 reads
SQL Server 2011 “Denali”: Four new useful DMV
SQL Server 2011 “Denali” CTP3 introduced couple of new Dynamic Management Views (DMV). However, documentation says that some of them...
2011-09-14
741 reads
SQL Server 2012 (“Denali”): Installing on a Virtual Machine
With CTP3 for SQL Server 2012 (code name of “Denali”) available, a lot of us want to play with all the new...
2011-09-14
1,655 reads
What Happens in Vegas…
…Need not Stay in Vegas Coming to Las Vegas in 2012 is an event many have been waiting for. Those that have been waiting for this event are the...
2011-09-14
10 reads
What Happens in Vegas…
…Need not Stay in Vegas
Coming to Las Vegas in 2012 is an event many have been waiting for. Those that...
2011-09-14
751 reads
8 Weeks In
I’m about eight weeks into my current project and while I’m certain I don’t know it all, I’m finally at...
2011-09-13
538 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