Flyclear Revisited
Back in May I wrote about signing up for FlyClear as a way to save time travelling and in doing so,...
2008-10-14
524 reads
Financial Trust
I’m sure that the people at Mint and Thrive have people’s best interests at heart. They built services designed to...
2008-10-14
952 reads
Too Good at Data Analysis - Why Did I Write This?
The past few weeks have been a rough one all around the globe as economies aren't doing well. I studied...
2008-10-14
605 reads
Should I Run for the PASS Board of Directors?
I saw the recent Call for Nominations for the election this year, so the title of this post is only...
2008-10-13
521 reads
Double Posting
I think that it’s a great idea to keep a few blogs going, and separate out your thoughts in different...
2008-10-13
636 reads
LiveWriter
I’ve been experimenting a bit in the blogging world, setting up a few blog accounts and trying different services. I...
2008-10-13
636 reads
Post Event Notes on SQLSaturday #5 & SQLSaturday #9, and Future Plans
Thought I'd post these notes based on feedback from the event organizers, wasn't able to attend myself due to scheduling...
2008-10-13
540 reads
Back to 400
I had to research a bit, write some code, and look up things to answer questions this morning. I must...
2008-10-13
700 reads
Data Farming - Why Did I Write This?
I grew up in the Cold War, with real concern that the Russians would attack us someday. I wanted to...
2008-10-13
814 reads
SQL Server MVP
Can't say I ever expected to say this, but as of October 1st I'm a SQL Server MVP. A nice...
2008-10-13
881 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