A Break
Only a small one, but I appreciate every one I get. Not often that I get to leave the site...
2008-10-28
1,472 reads
Post Event Notes - SQLSaturday #8
Yesterday I posted an overview of the event, today I want to go over some areas where we excelled, and...
2008-10-27
1,330 reads
Miramar User Group and SQL Saturday Presentations
Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server....
2008-10-27
1,566 reads
Post Event SQL Saturday #8 Orlando
This weekend I spoke at Seminole Community College with a session on Reporting Services 2008. If your interested you can...
2008-10-27
1,419 reads
SQLSaturday #8 - Orlando
The whole idea of having free events, bringing learning to people locally wasn't something that I was thrilled with. It's...
2008-10-26
1,436 reads
Absolutely (Not?) - Why Did I Write This?
I've always been a little bit of a strong DBA. I try to get along and work with people, being...
2008-10-26
1,600 reads
After Event Notes on SQLSaturday #8 in Orlando
By any measure the event was a success. We had a solid 275 attendees this year, up about 50 from last...
2008-10-25
1,500 reads
ways to find the name of a running job
From time to time, I need to check (in my script) which jobs are running at the moment.So far, I...
2008-10-23
1,798 reads
Good Ideas Take Time or How to Brainstorm - Part 2
In Good Ideas Take Time or How to Brainstorm - Part 1 I wrote about how I come up with ideas...
2008-10-23
1,603 reads
Out of Band Security Bulletin Release for Microsoft Windows
Microsoft tries to stick with the second Tuesday for security bulletin releases and has only released out-of-band a handful of...
2008-10-23
1,510 reads
Blogs
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
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...
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