SQL Server 2005 Tools
A good talk on the tools from the guy that's responsible for SSMS,
Configuration Manager, Maintenance plans, Surface Area Configuration
Wizard, and...
2007-06-05
622 reads
Reunion
We're not partners anymore in SQLServerCentral.com, but Andy, Brian,
and myself got together last night for dinner. We haven't seen each
other...
2007-06-05
622 reads
Working Afternoon
I ended up driving around Orlando this afternoon to get books. We'd
printed the next version of our Two Minute SQL...
2007-06-04
576 reads
First Session
I dropped into Brian Knight's "Clustering in 60 Minutes" to say hi. If
you've never seen this, it's pretty cool and...
2007-06-04
564 reads
Tech Ed - Keynote
These will get pretty long as I'm kind of wordy, but these are impressions as things are occurring.
Registration is a...
2007-06-04
748 reads
Clustered Index Seek or Key Lookup
When I teach performance tuning I always remind students to be cautious about service packs because things you "know" may...
2007-06-04
1,761 reads
Midlands PASS Chapter Meeting for June 6, 2007
Our next meeting will be on Thursday, June 7th, at
6:30 PM. Training Concepts will once again be our gracious...
2007-05-29
1,355 reads
Speaking at PASS 2007
I'll be doing a spotlight session called 'Transactional Replication for Beginners' this year. I've been speaking at the Summit since...
2007-05-29
1,364 reads
Book Reviews
I've got a new article running on SSC today with a few more book reviews: http://www.sqlservercentral.com/columnists/awarren/2998.asp.
2007-05-23
1,426 reads
The Developer Differences
Here we are starting to see information on Katmai and I'm just getting around to an article comparing SQL 2005...
2007-05-22
1,322 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