The 9th Day of SQL: Things Aren't as Simple as They Seem
The 12 days of SQL
Brent Ozar (blog | twitter) had an idea: a group of people should blog about writing which...
2010-12-21
707 reads
Kendra Little
Select * from dbo.FAIL: invalid metadata in views and user defined functions
This week a question on the Twitter #sqlhelp hash tag reminded me of a detail of SQL Server that I...
2010-12-16
1,133 reads
Introduction to Partitioning: Resources!
This past Saturday I presented my shiny new Introduction to SQL Server Partitioning session at SQL Saturday 61.
There were two...
2010-12-07
702 reads
TSQL Tuesday #11: Messages and the Clammy Seduction of the Print Statement
Note: Updated 10/28 based on conversation in the comments, and 12/10 with Denali info.
TSQL Tuesday #11: Misconceptions in SQL Server
This...
2010-10-12
1,007 reads
Automation: Granting Read Perms for Developers
Yeah, you heard me.
Do you like to read?
“But Kendra, why would we want to grant developers read permissions? And why...
2010-08-16
944 reads
Learning that Presenting is Worth Doing (T-SQL Tuesday #008: Gettin’ Schooled)
This month’s T-SQL Tuesday topic is hosted by Robert Davis and the topic is “How do you learn? How do you teach?...
2010-07-13
1,350 reads
Error Configuring DataCollector: A collection set cannot start without a schedule
Data Collection, Puppy Style
Update: Based on Bill Ramos’ comment below and a note on Twitter (thanks!!) I have added some...
2010-06-26
1,834 reads
Change Data Capture vs Change Tracking
Make sure to check out the comments on this one!
A short conversation on Twitter Monday night reminded me of this...
2010-06-23
1,119 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