Have You Made a Difference?
In this time of crisis, it's up to each of us to make a difference in some way.
2020-04-06
207 reads
Editorials
Next Person Up
Steve wonders today about the need to compete in our jobs, especially with employers that view us as resources.
2020-04-02
131 reads
Cursors Without Performance Penalties
Imagine how coding might take place if cursors were as efficient as complex SELECT statements.
2020-04-01
365 reads
2020-03-31
67 reads
Now Is a Good Time for Choices
The whole world is going through some interesting times. Chances are pretty high that you’re working from home and your principal interaction with others is through virtual means. I know I’m that way as is my company, Redgate Software. It can be challenging or rewarding, depending on how you go about it. What’s even more […]
2020-03-28
130 reads
Taking Stock of Your Career
With almost a quarter of 2020 gone, Steve notes it's be time to stock of your career.
2020-03-27
498 reads
A Data Controversy
A request to rapidly gather data caused some friction recently. Is that something that organizations ought to be prepared to handle?
2020-03-26
150 reads
The Challenge of Contracting
The nature of work might be changing, and Steve has a few thoughts on thinking about your job as always contracting.
2020-03-25
116 reads
2020-03-24
110 reads
2020-03-23
242 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