October Question: What one thing do you feel has the greatest impact on SQL Server’s performance?
When it comes to databases, many DBAs obsess over performance, and for good reason, as when user’s begain to complain...
2011-10-01
1,093 reads
Blog Posts
SQL Saturday 97 starts in 7 hours
I flew into Austin Texas today and got to spend time with a lot of great people. The journey started...
2011-10-01
526 reads
A Good Time to Be a SQL Server Professional
Wow! Can't believe today is the last day of September! Fall, here we come! Although Summer is over, Autumn is...
2011-09-30
1,981 reads
Creating your first Data Mining Structure and Model
Data mining is a great way to help your company make decisions and predict future values. The Data Mining Algorithms...
2011-09-30
8,700 reads
Free SQL Server in the City Event to be Held in LA
Red Gate Software will be providing a free, full-day SQL Server event called SQL in the City in Los Angeles,...
2011-09-30
1,412 reads
How to find a string value in all the string columns of a table/view in SQL Server ?
Introduction
I am sure many times we all might have come across situations where we need to search/find a string value...
2011-09-30
6,349 reads
Join the Wolf Pack at PASS Summit 2011
Quick update for all of you!
Hey there everyone! We are going to have some awesome surprises, new software features...
2011-09-30
1,564 reads
Microsoft SQL Server Reference Architecture and Appliances
Microsoft has made available SQL Server appliances and reference architectures that allow customers to deploy data warehouse (DW), business intelligence (BI) and...
2011-09-30
3,773 reads
New website, exciting future for BRSSUG
Just wanted to push out an announcement that the Baton Rouge SQL Server User Group has a new website.
www.brssug.org
We've...
2011-09-30
1,502 reads
Presentation Files: 10 Things All BI Administrators Should Know
Presentation Files: 10 Things All BI Administrators Should Know
I sooooo remember this sign!
I was very excited to get to present...
2011-09-30
2,005 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