Posting This Week
I just wanted to do a quick post to let everyone know that I am in fact going to be...
2011-09-28
496 reads
Blog Posts
RTO in Disaster Recovery
When you have a disaster, the time that you have to restore service is usually referred to as the RTO...
2011-09-28
1,275 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…!
It’s time for another SQL Saturday at the beautiful University...
2011-09-28
719 reads
SQL Saturday 98, Iowa City
Calling all SQL peeps in Chicago, Milwaukee, St. Louis, Minneapolis, Omaha,…! It’s time for another SQL Saturday at the beautiful University of Iowa campus. The speaker lineup looks great....
2011-09-28
11 reads
SQL Table Columns Disappear in Access
A couple weeks ago a user complained that on one of our development databases, one of the views he was...
2011-09-28
1,628 reads
SQL University SSIS : Named Pipes -- Consumer
Welcome to the third and last day of the Named Pipes seminar. Today we will get into the consumer portion...
2011-09-28
547 reads
SSIS Merge with Duplicate Rows
The Merge component in SSIS will take two sorted sources and union them while maintaining the original sort order. The...
2011-09-28
1,327 reads
ALTER AUTHORIZATION sql to change owner of a database
ALTER AUTHORIZATION changes the ownership of entities . Server level entity ownership can be changed to server- level principals. Database level...
2011-09-27
101,515 reads
24 Hours of PASS Questions
I finally found the time to work through the questions from the 24 Hours of PASS session that I did....
2011-09-27
760 reads
Data Head
Well, it’s official. I am a Data Head. It doesn’t change too much my level of geekiness. But I may have to rethink one of the answers given during...
2011-09-27
9 reads
Blogs
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
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