Quotename in SQL
Quotename() is a SQL Server String function.
It accepts an input string of of up to 128 characters. Which is a...
2011-11-15
8,085 reads
Blog Posts
Speaking Engagements
It only seems like a couple of weeks ago since I wrote a post about new years resolutions which you...
2011-11-15
521 reads
The Calendar Driven Organization
I’ve had jobs where I might have one meeting a week, I’ve had a few with some type of daily...
2011-11-15
741 reads
The First Thing To Do After Creating Keys
I’ve been looking at some security code in preparation for a few talks I plan on doing next year and...
2011-11-15
1,217 reads
Tuesday Hardware Tidbits, Nov 15, 2011
A couple of interesting developments this week. First, Intel has officially released (and lifted the embargo) on their new high-end,...
2011-11-15
848 reads
Un-SQL Friday: Stop SOPA!
This will be an unusually political Un-SQL Friday – and it’s two days early, to boot – but I’m making an exception...
2011-11-15
1,059 reads
Writing queries without data
Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This...
2011-11-15
703 reads
A Plug for IT Pro Camps
Here is something else that started in Florida (doesn’t everything?), a series of events along the lines of Code Camp...
2011-11-14
582 reads
Another reason that T-SQL beats the GUI
In IT, we have a few very solid and universal principles that no one ever argues with. The first of...
2011-11-14
579 reads
Create Sparklines in SSRS
When creating a SSRS report, you want to add lines that display trends. Sparklines that were introduced in SQL Server 2008 R2...
2011-11-14
3,922 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