Index usage
Last week I blogged about how to get help identifying possible missing indexes by using some of the DMV’s provided...
2011-10-04
804 reads
Blog Posts
Me an MVP? It Really Happened
Yes, I was named a SQL Server MVP the most recent round of awards. I honestly can’t believe it. It is a great honor to have been recognized for...
2011-10-04
6 reads
Me an MVP? It Really Happened
Yes, I was named a SQL Server MVP the most recent round of awards. I honestly can’t believe it. It...
2011-10-04
674 reads
SQL Server Indexing Day, 18. Jänner 2012 in Wien
Sie wollen SQL Server
Abfragen um 100% oder gar 1000% beschleunigt haben? Gleichzeitig wollen Sie Hardware–
und Lizenzkosten Ihrer SQL Server Anwendungen...
2011-10-04
1,084 reads
SQL Server MVP for another year
I’m naturally paranoid. I suppose it keeps me honest. When I went to work for SolidQ earlier this year – and...
2011-10-04
599 reads
TCP Chimney offload
On Windows 2003 Enterprise Edition Service Pack 2 TCP Chimney was enabled by default. It took me a while to...
2011-10-04
1,252 reads
T-SQL Tuesday #23 – Joins
There is something wrong in the SQL force today… here it is the first Tuesday of a month, and we’re...
2011-10-04
796 reads
A "New Guy" Joins Our Team
It's a great day for me and Moulding and Millwork (the company I work for). A few weeks back, I...
2011-10-03
695 reads
A "New Guy" Joins Our Team
It's a great day for me and Moulding and Millwork (the company I work for). A few weeks back, I let you all know that I'd been given the...
2011-10-03
8 reads
A "New Guy" Joins Our Team
It's a great day for me and Moulding and Millwork (the company I work for). A few weeks back, I let you all know that I'd been given the...
2011-10-03
7 reads
Blogs
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...
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
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