CU 16 for SQL Server 2008 SP1
Microsoft has recently released a Cumulative Update (CU) # 16 for SQL Server 2008 SP1 which contains hotfixes which were resolved...
2011-09-23
453 reads
Blog Posts
Easily view errors from Script Components
I've been doing quite a bit of work for my upcoming SQL University class next and in it is a Script Component. These are the ones that live inside...
2011-09-23
13 reads
Easily view errors from Script Components
I've been doing quite a bit of work for my upcoming SQL University class next and in it is a...
2011-09-23
773 reads
Easily view errors from Script Components
I've been doing quite a bit of work for my upcoming SQL University class
next and in it is a Script Component. These are the ones that live inside
of...
2011-09-23
17 reads
In The SQL News
There is a lot of stuff going on out there these days. I am looking forward to a few things. And since I am looking forward to them, I...
2011-09-23
12 reads
In The SQL News
There is a lot of stuff going on out there these days. I am looking forward to a few things....
2011-09-23
557 reads
Microsoft Partner Network explained
I’m sure in your travels in the field of IT, you have seen or heard of companies being called a...
2011-09-23
1,490 reads
Partial Cache Lookup with a Date Range
When setting up a lookup in SSIS it is usually just a basic comparison between two key fields like an...
2011-09-23
808 reads
PASS 2011 Countdown – 3 Weeks To Go
Another week down and there are now 3-weeks until this year’s PASS Summit. Take a moment and register now if...
2011-09-23
677 reads
Performance Monitor Counters for SQL Server performance testing
I posted “Window Perfmon scripting, SQL Server perfmon and how to perfmon” which refers to a performance monitor counters.
The perfmon counters...
2011-09-23
3,433 reads
Blogs
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
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