2020-07-24
96 reads
Editorials
2020-07-23
91 reads
Hacking the Admin
A Twitter hack brings into the question of who can make changes in production for Steve.
2020-07-22
470 reads
2020-07-21
91 reads
A Dedicated Space
Today Steve looks at one possible future of offices, which might be something we own.
2020-07-20
175 reads
Digging Into Internals
There are plenty of experts that look to teach you about query tuning and the internals of query execution in SQL Server.
2020-07-18
165 reads
Your Data After Life
Today Steve thinks about what to do when planning for your digital assets after you pass.
2020-07-17
375 reads
Carefully Giving Normal Users Security Permissions
When we need to delegate work to less privileged users, Steve has an idea.
2020-07-16
199 reads
2020-07-15
184 reads
2020-07-14
123 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
ALAMAT KONTAK BCA KCP Alaydrus Telp:08218154392
WA CS (08218154392) Jl. Alaydrus No.47 & 47 A, RT.8/RW.2, Petojo Utara, Kecamatan Gambir,...
ALAMAT BCA KCU RAWAMANGUN Telp:08218154392
WA CS (08218154392) Jl. Paus No.81, RT.1/RW.8, Wil, Kec. Pulo Gadung, Kota Jakarta Timur,...
Alamat Kantor BCA KCU City Tower Telp:08218200233
Wa:628218200233 Alamat. Jl. M.H. Thamrin No.81 Ground Floor, RT.1/RW.6, Dukuh Atas, Menteng, Kec. Menteng,...
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