TechNet Gallery - resources for IT professionals

Download resources and applications for Windows 7, Windows Server 2008 R2, Windows Server 2008, SharePoint, System Center, Office, and other products. Find resources written in VB Script, PowerShell, SQL, JavaScript, or other script languages. New resources are added frequently so check often and see what's new.

Each contribution is licensed to you under a License Agreement by its owner, not Microsoft. Microsoft does not guarantee the contribution or purport to grant rights to it.
Sort by: rss
5 results in Security > SQL [Clear]
Durval Ramos
Using an encryption algorithm powerful 256-bit SQL Server, AES encryption can guarantee the security of your most sensitive data. Once one of the data is encrypted, you do not have to worry about a person who reads your confidential information. See more...
(2)
Updated 10/16/2013
Released 10/16/2013
364 Downloads
SQL
Olaf Helper
This Transact-SQL script list all roles of the current database with their members. Additonal the associated SQL Server login is listed.
(6)
Updated 9/15/2011
Released 9/15/2011
1,274 Downloads
SQL
Olaf Helper
This Transact-SQL statement links orphaned user like "sys.sp_change_users_login" to existing principals with same name, but in regard of security this script don't add a new principal if none with same name was found; as the SP with option AUTO_FIX do.
(4)
Updated 9/8/2011
Released 9/8/2011
1,469 Downloads
SQL
Microsoft All-In-One Script Framework - Microsoft
This T-SQL sample script checks permissions for guest user in all databases. This script applies to system and to user databases.
(0)
Updated 10/8/2013
Released 5/7/2013
133 Downloads
SQL
Olaf Helper
This Transact-SQL script list all server principals with their permissions on server level to give a quick overview of security. For given permissions on server object like endpoints or impersonate other login it returns also the object / login etc name.
(3)
Updated 10/12/2011
Released 10/12/2011
1,105 Downloads
SQL