CREATE ROLE

New User-defined Server Roles in SQL Server 2012

SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.

Disaster Recovery: How to regain your lost sysadmin access

This article shows you the process which you require to regain your sysadmin access.

Query accounts, domain groups, and members who have admin membership.

This script leverages master.sys.server_principals and xp_logininfo to return accounts, domain groups, and members in a SQL Server admin fixed role.

SQL Agent Roles

Rainbow Table

Checking database access

A New SMK

SQL Server stored procedure to generate random passwords

SQL Server is used to support many applications and one such feature of most applications is the storage of passwords. Sometimes there is a need to reset a password using a temporary password or generate a random password for a new user. In this tip I cover a simple stored procedure to generate random passwords that can be incorporated into your applications.

Removing TDE

Enabling TDE is simple to do, but it can be more complex when you look to remove the feature from SQL Server. Steve Perry brings you a procedure you can use to help you.