Saving Emergency Space on my Laptop
With my new laptop, one of the things I realized I’d forgotten to do in setup is reserve some space. I wrote about this years ago, but I wanted...
2024-09-11
36 reads
T-SQL Tuesday #178–A Recent Technical Problem
This month we have a good invitation from Deepthi Goguri, where she asks us about a technical problem. I think most of are technical people and we solve problems...
2024-09-10
46 reads
2024-09-10
33 reads
Redgate Clone Graduating Images
I wanted my own custom image in our internal Redgate Clone cluster, so I decided to make one. This is an overview of how this works. This is a...
2024-09-20 (first published: 2024-09-09)
140 reads
SQL Saturday Syracuse 2024 Recap
First Things First Thanks to every who came to my session, Asnwering the Auditor’s Call with Automation. Slides and scripts are posted to my Github.
The Event! This was Syracuse’s...
2024-09-08
23 reads
A New Word: Incidental Contact High
incidental contact high – n. an innocuous touch by someone just doing their job – a barber, yoga instructor, or friendly waitress – that you find more meaningful than...
2024-09-06
27 reads
Azure PostgreSQL Flexible Server and Entra Groups
My company is moving from an Azure PostgreSQL single server to a flexible server. We want to set up managed identity/Entra access instead of having roles with passwords for...
2024-09-23 (first published: 2024-09-05)
66 reads
Take the 2025 State of Database Landscape Survey
The survey is out now and you can share your experiences for a chance at $250 in Amazon vouchers. No matter whether you think your org is great or...
2024-09-06 (first published: 2024-09-05)
49 reads
Developer Q&A: John Kostak of Web Dev USA
"We can really be dangerous if we want, without being too afraid of it."
2024-09-05
30 reads
SQL Server Quickie #47 – Azure SQL Database
Today I have uploaded SQL Server Quickie #47 to YouTube. This time I’m talking about Azure SQL Database. If you are interested in learning more about this very interestingh...
2024-09-20 (first published: 2024-09-05)
226 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
KONTAK BCA KCP Joyoboyo Telp:08218154392
WA CS (08218154392) Jl. Joyoboyo No.34, Kemasan, Kec. Kota, Kota Kediri, Jawa Timur 64125
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...
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