Revisit What You Know - Published on SSC
The article went live earlier this week. Didn't quite accomplish what I had hoped I think, which was to point...
2007-08-02
447 reads
Katmai July 2008 CTP is Out
I'm downloading now, and you need some sort of inviation to do so, but it's available and ready for you...
2007-08-01
613 reads
Undocumented use of the Columns_Updated() function
Q I need an easy way to see if a delete transaction has fired a trigger. Do you have any...
2007-08-01
628 reads
Midlands PASS Chapter - August 2, 2007
"Database Professional Toolkit" with Brian and Jeremy
Midlands PASS Chapter - August 2, 2007 Meeting
Sponsored by Red Gate Software
The Midlands PASS Chapter...
2007-07-31
1,563 reads
User Groups Moved to New Domain
We've just moved all the PASS chapters that were hosted on ~.ssc.com domains over to ~.sqlgroups.com. This is part of...
2007-07-27
1,556 reads
ApexSQL's Industry Experts program
If you're a Microsoft MVP, ApexSQL has brought back their industry experts program. You can find out more about it...
2007-07-25
1,732 reads
SQLSaturday in Orlando
I imagine many of you have seen or attended a Code Camp, a one day free mini conference type event...
2007-07-23
1,500 reads
What is BI?
I actually started writing an article on this, but it's been sidetracked with travel and other stuff. However I do...
2007-07-21
1,477 reads
A Graphical View of the Physical Allocation of a Database
First saw information about a tool called SQL Internals Viewer in a blog post here at Kalen Delaney's blog. The...
2007-07-20
1,657 reads
More Navigation
I've looked at the daily newsletter for a year now and I've wondered about the table of contents. It seems...
2007-07-19
1,402 reads
Blogs
Methodology for dealing with bad data in production
By Brian Kelley
Pinal Dave wrote up his methodology for what to do when you discover bad...
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)...
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