SSIS Variables and Expressions Webinar
Looks like it is that time again… for me to present a FREE webinar for good ol’ Pragmatic Works today...
2011-09-20
670 reads
Blog Posts
Statistics in Execution Plans
I was presenting on execution plans when another question came up that I didn’t know the answer to immediately. Yes,...
2011-09-20
1,356 reads
Stored Procedures – Common Security Practice
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at the document available in that link. To further this...
2011-09-20
22 reads
Stored Procedures – Common Security Practice
In SQL Server a good practice is to access the data via calls through stored procedure. Have a look at...
2011-09-20
903 reads
The Barking Dog Analogy
The Barking Dog Analogy
Maggie and Woody
A discussion started today on Twitter about CXPacket waits. There had been a heated debate...
2011-09-20
1,103 reads
T-SQL Tuesday #22 Round-Up - Data Presentation
T-SQL Tuesday #22 is history, and I was pleased by the many posts and participants in this month’s September blog...
2011-09-20
3,667 reads
Updated Data Migration Assistants (5th Version Already) & Project Template to Help with Your Upgrades
After having spent much time attempting to settle a point regarding my favourite pastime of provincial politics, it has come...
2011-09-20
1,601 reads
Building a Visual Studio project from an existing SSAS database
Imagine you join a company, and there is an existing SSAS database that contains a few cubes that are working nicely. You...
2011-09-19
831 reads
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t know that – you do now. It is...
2011-09-19
38 reads
Column Level Permissions
Did you know that you can grant permissions down to the column level in SQL Server? Well, if you didn’t...
2011-09-19
1,682 reads
Blogs
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...
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...
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