SQL PASS 2011 Keynote, Day 1
It’s that time of the year again – the SQL PASS summit 2011 is underway! Today I’m participating in the blogger...
2011-10-12
1,333 reads
Blog Posts
SQL PASS Summit–Day 3 (Keynote)
From the PASS president, Rushabh Mehta. PASS has facilitated 430,000 hours of training and expansion into the global community. These...
2011-10-12
464 reads
SQL Pass Update - Day 1
So far SQL Pass Summit has been great for me. I have had a great time from day one onwards....
2011-10-12
1,745 reads
SQL Run was awesome
When Jes Borland suggested we do a group SQL Run in Seattle, I was thinking that we’d have a few...
2011-10-12
1,628 reads
Analysis Services 2008 R2 Performance Guide
You must read this if you work with SSAS:
Analysis Services 2008 R2 Performance Guide
Infact, I would recommend re-reading it a number...
2011-10-11
1,009 reads
Dude, Where is my memory?
We all know that SQL Server loves memory, and in my opinion SQL Server can never have to much RAM....
2011-10-11
685 reads
First Day of Summit
My first day in Seattle has ended. My flight arrived around 12:30 and I was in good company with John...
2011-10-11
742 reads
Hardware 301: Diving Deeper into Database Hardware
On Wednesday, October 12, at 10:15AM, I am going to get the pleasure of presenting my Hardware 301: Diving Deeper...
2011-10-11
1,099 reads
Learn to Help Yourself
I used to work with a guy who was adamant that before you asked him for help, you had done the...
2011-10-11
1,305 reads
Lyrics for “Hold On”
Since I put up the lyrics for “SQL and I Know It”, it only makes sense to continue the tradition...
2011-10-11
528 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