SQL Deep Dives 2 on the Kindle
Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted the book for travel purposes. I decided I really...
2011-11-23
5 reads
Blog Posts
SQL Deep Dives 2 on the Kindle
Since Deep Dives 2 came out, I had been putting off getting my copy of the e-book until I wanted...
2011-11-23
787 reads
SQL Server Magazine's Top 10 Blogger....#3
So, it seems that I have been selected by the 2011 SQL Server Community Choice Awards, as among the Top 10...
2011-11-23
1,381 reads
The Mute the Phone Office Prank
The client I work with as a lot of conference rooms, all with the standard Polycom conference phone that works...
2011-11-23
668 reads
DBA in Space: Behind the Scenes—Question 4
This is a continuation of my DBA in Space journal.
With each episode, DBA in Space becomes goofier and goofier. Episode...
2011-11-22
544 reads
Download SQL Server 2008 SP3 CU2
MS has recently released SQL Server 2008 Service Pack 3 Cumulative Update 2 Released? which has fixes reported after SQL...
2011-11-22
963 reads
Monitoring a Rollback and sys.dm_exec_requests
The dynamic management view (DMV) sys.dm_exec_requests returns information about each request that is executing within SQL Server.
Instead of using Activity...
2011-11-22
1,479 reads
Optimizing Backup Performance
If your environment is anything like mine, backups are usually not allocated the speediest disk. Generally speaking, those disks are...
2011-11-22
1,785 reads
Review: Gamma Seal Lids
Last weekend I needed to go to Home Depot to get a five gallon bucket and a lid so we...
2011-11-22
709 reads
SQL Server 2008 Service Pack 2 Cumulative Update 7 Released
Microsoft has released SQL Server 2008 Service Pack 2 Cumulative Update 7, which is Build 10.00.4323.00. I count 18 fixes...
2011-11-22
1,831 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