What Do You Want Auditors to Know About Auditing SQL Server?
Right now it looks like I'll be putting a training session on for my local ISACA chapter on SQL Server...
2009-01-22
1,102 reads
Read-Only Access to SQL Server Jobs
This question comes up a lot: how do I give read-only access to job status to a group of people?...
2009-01-22
4,064 reads
Influence
I saw Paul Kenny of Ocean Learningspeak about sales least year at the Business of Software Conference. I thought he...
2009-01-22
904 reads
Notes from the January 2009 oPASS Meeting
We had our first oPASS meeting of the year last week with about 18 attending. Jonathan Kehayias was our featured...
2009-01-21
685 reads
Play the T-SQL Alphabet Game
I recently had the opportunity to play the T-SQL Alphabet Game, which was introduced to me by SQL Server MVP,...
2009-01-21
1,254 reads
Mastering SQL Server Profiler E-Book Available for Free
After a lot of delays, my book on how to use SQL Server Profiler has been published by Simple-Talk Publishing,...
2009-01-21
4,399 reads
Video: xp_cmdshell execution in SQL Server 2005/2008
The video I did for Jumpstart TV on xp_cmdshell execution has hit the front page. Registration on the site is...
2009-01-21
688 reads
Networking - Part 3
Continuing the conversation I began in Part 1 & Part 2, today I want to ruminate some more on networking. I've...
2009-01-20
1,137 reads
Fake LinkedIn profiles with links to malware
This is a little old (five days based on the last update), but TrendMicro put on their blog about fake...
2009-01-20
928 reads
Conficker / Downadup Worm One More Time
Hopefully by now everyone has seen this, but if not, here's a reminder to continue to spread the details. Denis Gobo...
2009-01-20
916 reads
Blogs
How to Provision an Azure SQL Database
Aside from spinning up a SQL Server instance container, the free Azure SQL Database...
Claude finds two cryptographic weaknesses (but the sky isn’t falling)
By Brian Kelley
If you haven't seen the announcement, Anthropic was able to utilize Claude (Mythos Preview)...
Generate Embeddings in SQL with Aurora and Bedrock
Most embedding pipelines on AWS have the same shape: a job reads rows out...
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