Book Review: Smarter, Faster, Cheaper
In my continuing quest to not get personal visits from Buck Woody (blog|twitter) I’m making sure that I make good...
2011-09-26
1,481 reads
Blog Posts
Database Properties Health Check
For some time now, I have been working on a new book called How to Perform a SQL Server Health...
2011-09-26
950 reads
Notes from SQLSaturday #85
I’m writing this on Sunday afternoon after the event, thinking about the event and what I want to share with...
2011-09-26
630 reads
PASS 2011 Countdown – 2 Weeks To Go
I’m not sure how we got to 2-weeks until this year’s PASS Summit. If you haven’t registered yet it’s really...
2011-09-26
533 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
9 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone’s clamoring to cut taxes -but no...
2011-09-26
890 reads
Paying for Free
It seems like there is a widespread malaise in the country these days. Everyone's clamoring to cut taxes -but no one wants to have their neighborhood school closed, or...
2011-09-26
7 reads
Recovery Models
In SQL Server we have three basic recovery models: full, bulk-logged, and simple. By default we find that most databases...
2011-09-26
2,857 reads
Small Business Hardware
[NOTE] My blog post scheduling-fu is weak, so this post didn’t go out Friday as planned. My apologies.
This is the...
2011-09-26
1,427 reads
SolidQ Journal September Edition
The 13th edition of The SolidQ Journal has just been released with several insightful articles and continued series updates. In...
2011-09-26
1,057 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