SQL 2008 R2 Administration Cook Book
Couple of week back I have received a special gift, from the person whom I admire as a elder bro...
2011-09-26
404 reads
Blog Posts
SQL Server – Creating and using Dump Devices for Backups
A dump device is simply a logical device which redirects to a specified physical device. The main advantage of using...
2011-09-26
1,327 reads
SQL Server MVP Deep Dives 2 Released
Exciting news… The second edition of the SQL Server MVP Deep Dives book has been completed and is going to...
2011-09-26
1,038 reads
SQL University SSIS : Named Pipes -- Fundamentals
There comes a time when you look at how something is being done and say, "Does it have to be...
2011-09-26
603 reads
SSIS Lookup Cache Connection Manager with Excel
The lookup transform in SSIS 2008 gives you the ability to join data and eliminate non matching rows. One of...
2011-09-26
1,693 reads
What is a Microsoft Regional Director?
First off, they don’t work for Microsoft. A Microsoft Regional Director (RD) is an unbiased third-party evangelist of Microsoft products and...
2011-09-26
1,479 reads
Download all SQL Server DENALI CTP3 Demo VHD 36 files at once
Microsoft has made available for download the SQL Server DENALI CTP3 Demo VHD several weeks ago at http://www.microsoft.com/download/en/details.aspx?id=27253. The SQL...
2011-09-25
1,536 reads
SQL Saturday #85 Orlando 2011 Presentation
Presentation and scripts from my Storing Powershell Output session at SQL Saturday #85 Orlando 2011:
2011-09-24
971 reads
SQL Server MVP Deep Dives, Volume 2 Available at PASS 2011 Summit
Volume 2 of the SQL Server MVP Deep Dives book is now available for pre-order from Amazon and from Manning....
2011-09-24
1,931 reads
Come see SQLInspire NYC for FREE! and Take Visual Studio 2010 off Michael Coles’ shelf!
Game Changer! Come see SQLInspire NYC for FREE AND take Visual Studio 2010 off Michael Coles’ shelf
SPECIAL LIMITED OFFER!
I...
2011-09-23
2,303 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