SSRS 2005 Error: The Item “/” cannot be found
Couple of months back, one of our SSRS 2005 staging server became inaccessible. When we opened the report manager, it...
2011-09-10
4,062 reads
Blog Posts
SSRS 2008 R2: Object reference not set to an instance of an object
We have a report in SSRS 2008 which calls multiple sub-reports. One of the sub-reports contains a data region (tablix) in...
2011-09-10
2,672 reads
24 Hours of PASS & SQL Saturday(s)
I survived 24 Hours of PASS! Just wrapped up delivering my presentation for the 24 Hours of PASS (24HOP) on...
2011-09-09
657 reads
Come to SQL Saturday 92 in Portland
Are you In Portland, Oregon?
Do you plan to be in Portland on Saturday, October 8th?
Can you be in Portland on...
2011-09-09
506 reads
Little Workaround in Report Manager
I had an issue this week in Report Manager. I was generating a report (we’ll call it General Widgets Report),...
2011-09-09
869 reads
Round Up of Past Week and Upcoming Events.....
Read on to register for cool events, win an iPad2, be inspired, participate in t-sql tuesday, and more!
It's been an...
2011-09-09
1,605 reads
SSRS 2008 R2: Report Server crashing intermittently
One of our report server which is SSRS 2008 R2 (10.50.1720.0) started to crash intermittently. The IE failed with Internet...
2011-09-09
3,891 reads
Using a Display Folder for a SSAS calculation
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will...
2011-09-09
1,385 reads
Configuring Windows 7 For Paired Storage
In recent years solid state drives (SSD for short) have dropped in price enough to be an affordable option in...
2011-09-08
1,179 reads
I need #sqlhelp! BIDS shuts down unexpectedly
I have MS Visual Studio 2008 (BIDS) x86 with SP1. Recently it’s started shutting down without warning whenever I hit...
2011-09-08
597 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