SQL Server Security Audit (Part 1) - Server Level Audit

The first of this three part series on SQL Server Security Auditing focuses on the SQL Server itself and addressing any of its security vulnerabilities.

Breaking ownership chaining within a schema in SQL Server

I have several objects, all in the same schema. Because of this, ownership chaining is working, as described in this previous tip. However, I don't want ownership chaining to be on, but I need the objects to remain in the same schema. How can I do this?

Login Failed

Find SQL Server Authentication Mode Configuration

Quick Method to find Configured???????????????????????? Authentication Mode

Automate collection and saving of failed logins for SQL Server

I re-cycle my SQL Server log every night using sp_cycle_errorlog. However, before I do, I would like to capture all of the failed logins recorded. I have auditing turned on for failed logins, but I want to make sure that I capture those events into a table so I can report on. How can I do this?

MD2

Cryptography

Grant Mass permissions

Create A role and grant it a permission on a DB Schemas.

Blocking Users by IP

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.

List all permissions in all databases

This script will allow you get all the users and roles with permission on objects on all databases.