Attend the PASS Summit from Home, 2011 edition
Hidy-ho there, neighbors! This is an update of last year’s Attend the PASS Summit from Home blog. I’ll be updating this...
2011-10-03
1,537 reads
Blog Posts
BI’s pretty boy goes down!
It?s never easy to beat up on a friend. Sometimes they have it coming though!.
The Webinar smackdown is over....
2011-10-03
782 reads
It's NOT too late Win an iPad2 - Share you SQL Story!
Happy October!
Last month I announced a cool new SQL challenge to simply share your SQL Server Performance story with us,...
2011-10-03
706 reads
Networking
No, I’m not talking about hubs and switches. I’m talking about people. Networking is a major component of an event...
2011-10-03
1,151 reads
October Monthly SQL Server Checklist
It’s the first Monday of the October and it’s time to do a monthly checkup. If you are like me,...
2011-10-03
575 reads
SQL Authentication – Forcing Password Changes
When you create a SQL Server login (with SQL authentication), you have the option of enforcing password policies from Windows...
2011-10-03
6,218 reads
SQL Bits 9
SQL Bits was great
It’s been two years or more that I’ve been invited to SQL Bits. Not by email, but...
2011-10-03
1,267 reads
SQL Server – Marking a stored procedure as system object
Marking a stored procedure as system object allows to run the procedure in a user database context. There are two...
2011-10-03
2,705 reads
SQL Server Database SUSPECT state
According to BOL , a database in SUSPECT state is : “At least the primary filegroup is suspect and may be damaged....
2011-10-03
1,202 reads
Using Configuration Tables in SSIS 2008/2005
SSIS packages are great ETL tools and can do just about anything you need in terms of ETL. Most organizations...
2011-10-03
1,268 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