SQL Server 2012 SSIS – Why is my toolbox empty?
So recently I was doing a demonstration using the new SQL 2012 SSIS running in Visual Studio 2010. I needed...
2011-10-13
32,470 reads
Blog Posts
SSRS 2008 R2: Implementing Row-level Security
When working at large organizations with several users, managing security using Windows or SQL authentication could be challenging. However, there...
2011-10-13
9,796 reads
Summit Sessions Day 1 #sqlpass
Today was our first day to attend regular sessions. With over 189 sessions being offered over 3 days there are...
2011-10-13
706 reads
2011 PASS Summit–Report #1
Wednesday morning. I’m at the blogger table waiting on the opening day keynote. LOTS of people here. Summit attendance is...
2011-10-12
697 reads
An Interesting Sort
I just came across a pretty peculiar sort requirement. The requirement made me sit and think a bit. Since it was somewhat peculiar, I decided I would share the...
2011-10-12
8 reads
An Interesting Sort
I just came across a pretty peculiar sort requirement. The requirement made me sit and think a bit. Since it...
2011-10-12
649 reads
Coming to reality near you - DBA in Space - Produced by Red Gate...
Space - the Final Frontier!
Do not adjust your monitor- this blog is NOT a joke - rubbing your eyes will not help!
Now,...
2011-10-12
931 reads
Day three of Summit Keynote
Last year we set out some very high goals. 1 million technical training hours, 250k members in the community, and...
2011-10-12
983 reads
Error configuration in SSAS
In SSAS, there is an Error Configuration object that is central to the management of data integrity errors.
The following picture...
2011-10-12
2,437 reads
Event Driven SSIS with Synchronous Processing and Dynamic Subscriptions
I know the title of this post is a little cryptic and something that only a techie would like but...
2011-10-12
1,868 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