Invitation for T-SQL Tuesday #22 – Data Presentation
Invitation for T-SQL Tuesday #22 – Data Presentation
Whilst I was winding down an eventful day with the family on Labor Day...
2011-09-06
8,643 reads
Blog Posts
Meme Monday: Favorite PASS Memory
Have to complete my assignment from the Rockstar this month since I’ve missed the last several (he gets all weepy,...
2011-09-06
602 reads
New LOGICAL functions in SQL Server Denali
IFF Function
If you are an old Access or Excel “developer” you know this one. This is not a function I...
2011-09-06
2,973 reads
Parallelizing Slow Parts of the Data Flow - Part 1 - Preparation
It's quite common to have parts of your Data Flow that are slow, and there are some techniques you can use to improve performance of those parts. One of...
2011-09-06
6 reads
Parallelizing Slow Parts of the Data Flow - Part 1 - Preparation
It's quite common to have parts of your Data Flow that are slow, and there are some techniques you can...
2011-09-06
850 reads
Parallelizing Slow Parts of the Data Flow - Part 1 - Preparation
It's quite common to have parts of your Data Flow that are slow, and there are some techniques you can use to improve performance of those parts. One of...
2011-09-06
11 reads
PASSMN September Meeting Announced
It’s time to start looking deeper at the next release of SQL Server. As such, the September PASSMN meeting will...
2011-09-06
1,102 reads
S3OLV September 2011
I really meant to get this post out last week. My apologies, but here is the post finally. Along with the post, I also had meant to get the...
2011-09-06
4 reads
S3OLV September 2011
I really meant to get this post out last week. My apologies, but here is the post finally. Along with...
2011-09-06
790 reads
September Monthly SQL Server Checklist
First day of the month and first Tuesday of the month. Yup, the list is late this month because for...
2011-09-06
1,377 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