Open Source Software and Cacoëthes Scribendi
Phil Factor on the irresistible urge to write code in the public domain, and the occasional desire to be free from the snails-trail of software that needs maintainence.
2012-04-16
100 reads
Editorials
Key Storage
Today Steve Jones asks about how you secure the keys that secure your other data. Is there a good way that you've found to handle this?
2012-04-13
163 reads
Transfer Times in the Cloud
Today Steve Jones talks about a problem in the cloud computing world: getting your data back.
2012-04-12
160 reads
Wasting Time
Focusing in one area for long periods of time is hard. Steve Jones thinks that people taking a little time at work to recharge is a good idea, and something companies might want to encourage.
2012-04-11
261 reads
Certificates Everywhere
Today Steve Jones talks about security and his desire to have certificates be the primary means of securing communications and verifying authenticity.
2012-04-10
199 reads
Get Some Cross Training Today
There's an IT skills gap in many companies, which is forcing managers to get creative. Steve Jones says now is the time to look for some cross training at work.
2012-04-09
186 reads
2012-04-09
57 reads
The On-call Demands
This Friday Steve Jones asks about your on-call responsibilities and the load you face from after hours calls. If you're a DBA that doesn't work strictly 9-5 every week, let us know.
2012-04-06
175 reads
Treat the Database like Code
Steve Jones reminds us that our databases contain code, and as such, they ought to be under some type of version control.
2012-04-05
229 reads
My Little Friend
Today Steve Jones talks about his favorite feature in SSMS 2012 and why everyone should use it.
2012-04-04
633 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