PerformancePoint – Using SSAS Actions
The latest project I worked on had a heavy dose of PerformancePoint and one of the requirements was to launch...
2011-09-23
2,300 reads
Blog Posts
Re-blog – September 16 – September 22
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-09-23
611 reads
SQL Saturday 89 has come and gone!
All the planning, stressing, and freaking out about SQL Saturday #89 came to and end this past weekend. We had...
2011-09-23
413 reads
SQLSaturday #85 is Tomorrow!
It’s 7am on Friday and I can’t wait for the day to end, head home to change and then go...
2011-09-23
606 reads
SQLSaturday Orlando Is Tomorrow!
Tomorrow marks the 4th annual SQLSaturday Orlando, held at Seminole State College in Sanford. We've got 46 sessions by 40+...
2011-09-23
871 reads
This field is missing from the returned result set from the data source.
This warning
The dataset ‘dataset1' contains a definition for the Field ‘column1'. This field is missing from the returned result set...
2011-09-23
8,383 reads
Using Unary Operators to control Analysis Services hierarchy aggregations
Analysis Services hierarchy aggregations can be easily controlled using unary operators. For example, in accounting there are GL accounts that...
2011-09-23
2,245 reads
Analytic Functions – PERCENTILE_CONT / PERCENTILE_DISC
This post is part of the series discussing the new Analytic functions in SQL Server “Denali”, CTP3.
Analytic Functions in SQL...
2011-09-22
11,792 reads
Miss 24 Hours of PASS ? No problem, all videos are online
All the videos for the sessions at 24 Hours of PASS are available for free. Check the session schedule for...
2011-09-22
564 reads
MVP Deep Dives 2 – Pre-Order
Every couple days, I’ve been checking for it and finally tonight I saw that the upcoming edition of SQL Server...
2011-09-22
561 reads
Blogs
Resolving SQL Server Transaction Log Issues Efficiently
By Arun Sirpal
Transaction log issues are one of the quietest ways a healthy database turns into...
Adding an HTTP MCP Server to VSCode
By Steve Jones
I wrote earlier this week about the SQL MCP Server using the Data API...
Microsoft announces new cybersecurity AI multi-model
By Brian Kelley
Yesterday, July 27, 2026, Microsoft announced a new cybersecurity effort called Project Perception. Included...
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