I need #sqlhelp! BIDS shuts down unexpectedly – SOLVED
Edit: See end of blog for solution.
I have MS Visual Studio 2008 (BIDS) x86 with SP1. Recently it’s started shutting...
2011-09-08
694 reads
Blog Posts
Prepping for Certification
Having prepped for, taken, and then failed the MCM exam this year, perhaps I’m not the best person to give...
2011-09-08
1,345 reads
SQL Saturday #97 – Austin TX
The schedule for SQL Saturday 97 has been posted and I was selected to give my “It’s TempDB, Why Should...
2011-09-08
468 reads
SQL Server DMV Views: Getting slow queries within stored procedure
SQL Server DMV Views might be very helpful. Let’s imagine that you have a couple of nested stored procedures and...
2011-09-08
1,853 reads
SQLSaturday #97 Speaker Selection Process
Hard Choices
First, thank you for submitting to speak at SQLSaturday #97 in Austin, TX. Myself, Richard Heim and Mike Byrd...
2011-09-08
795 reads
TPC-H generate test data , test queries and sql database benchmark
This is a followup on my earlier post ofSQL Server test data generation testing tools.
I had some requests for my...
2011-09-08
5,652 reads
Hello…
Here i come… this is my first post at http://svangasql.wordpress.com. Here, you will see posts related to sql server, reporting...
2011-09-07
520 reads
Hustle and Bustle to Kick off September
September is kicking off with a boom for me. In one week, it seems I will be here, there and everywhere. Between SQL, PASS, Family, and User Group –...
2011-09-07
7 reads
Hustle and Bustle to Kick off September
September is kicking off with a boom for me. In one week, it seems I will be here, there and...
2011-09-07
819 reads
One hectic month ahead
The SQL Pass community summit is just around the corner. There is so little time and so much to do....
2011-09-07
1,388 reads
Blogs
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
Getting the SQL Server MCP Server Running
By Steve Jones
If you’ve wanted a SQL Server MCP server for your databases, it’s available. The...
Introducing azsql-migration-test: Test and Validate Azure SQL Database Migrations
Introducing azsql-migration-test, a small open-source CLI that validates your Azure SQL Database migrations against...
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