A DDL Auditing Solution

An article discussing DDL Auditing. Learn how to track schema changes that occur in your database, enabling you to see who changed what and when. Free GUI tool included.

DDL trigger

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.

DDL trigger

Granting limited permissions to create views in another schema in SQL Server - Part 2

In a previous tip, Granting limited permissions to create views in another schema in SQL Server, I showed how to use the CREATE VIEW permission and the ALTER SCHEMA permission to allow users to create new views using the same schema as the tables. However, I have found that the users can alter and drop tables in this schema which is beyond what I want them to do. A DENY CREATE TABLE does not work, so what can I do to prevent them from touching the tables in this way? In this tip I will show you how you can use a DDL trigger to prevent this unneeded access.

Creating a recycle bin for SQL Server 2005\2008

Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.

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.

Securing SQL with access control and login monitoring

SQL Server login monitoring and access control are important elements of SQL database security. Learn how DDL triggers can help alert you to security issues.

DDL Triggers Implementation

How to use DDL triggers and Query the Data with minimum performance impact.

Monitoring Changes in Your Database Using DDL Triggers

Auditing and monitoring activity in your databases is becoming more and more important all the time. New author David Dye brings us a short introduction to using DDL triggers to help.