The Little Things
This year I've been lucky enough to have been offered some prizes or promotions from a few different companies for...
2008-05-15
1,208 reads
FlyClear, Privacy, and Time
Recently I signed up for the FlyClear program (www.flyclear.com), a registered traveler program. Over the past year I've been travelling...
2008-05-15
722 reads
A Display Challenge
I've grown to like the presenter view in Powerpoint 2007; let's me navigate easily, and more important, lets me easily...
2008-05-13
461 reads
The CLR
Some very interesting responses to my CLR editorial today including some good details that I haven't seen elsewhere. I'm still...
2008-05-13
912 reads
Visiting Boston This Week
I get busy and usually forget to post when I'm out and about, but for once I've remembered. I'll be...
2008-05-11
461 reads
Possible interview questions for Intern/Junior DBA or Developer
I wrote these questions thinking about what some basic t-sql statements that I would want to see if I were...
2008-05-10
3,820 reads
A View Variable
I saw that Erland Sommerskag posted a Connect item that asked for a "View Variable" to be added to the...
2008-05-09
1,260 reads
Follow Up Notes on SQLSaturday #3
Our most recent SQLSaturday went well, but there is always room for improvement. Here are my notes from this event:
The...
2008-05-08
395 reads
A little fun with SSIS Expression Language
The SSIS expression language is a powerful yet enigmatic entity. Once you get used to its syntax - which is part...
2008-05-08
4,886 reads
Kindle Research - Procs and Cons with the Sony Reader
After the editorial on the Kindle, which got quite a few responses, I've continued to look around and research things....
2008-05-08
961 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