SQL University: Architecture for Small Businesses
Welcome back to SQL University! This week we’re going to be discussing architecture. In previous weeks we’ve discussed architecture at...
2011-09-19
835 reads
Blog Posts
SQLInspire NYC - SQLPeople Just Got Even More Inspiring!
is all set for Saturday, November 12, 2011, with only 53 days remaining to this fantastic gathering
of assorted SQL Server,...
2011-09-19
1,625 reads
Find the largest tables in a database (II)
I once wrote a post to find the largest tables in a database, and now after studying PowerShell, I feel...
2011-09-18
2,041 reads
Overcome update conflict in P2P replication
When we have Peer to Peer (P2P) replication in place on SQL Server 2008, probably we would see a conflict...
2011-09-18
1,774 reads
PASS First Timers Guide
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
636 reads
PASS First Timers Guide and Schedule
Hi there ho there everybody! I am now a Big SisterFearless Leader of a group of PASS Summit first timers!...
2011-09-17
775 reads
Beyonders
It has been a looooong time since I wrote a little book review. It’s nice to take time out with a little fantasy to ease and please the brain....
2011-09-16
6 reads
Beyonders
It has been a looooong time since I wrote a little book review. It’s nice to take time out with...
2011-09-16
557 reads
Come and get your Data Education!
We all have been to various training courses throughout our professional career. Many follow a similar standard curriculum or course...
2011-09-16
922 reads
Conflict Resolution
More than once I’ve run into situations where I’m working with two people/groups that don’t get along. Especially as a...
2011-09-16
622 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