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.
2012-04-19
4,021 reads
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.
2012-04-19
4,021 reads
2012-01-18
2,252 reads
DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.
2010-08-17
7,536 reads
2010-05-27
3,092 reads
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.
2009-08-17
3,444 reads
Using a DDL trigger, two schemas and a stored procedure recycle bin functionality can be create in SQL Server.
2009-05-20
13,083 reads
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.
2013-11-08 (first published: 2009-03-09)
36,344 reads
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.
2009-02-16
3,195 reads
How to use DDL triggers and Query the Data with minimum performance impact.
2008-10-02
1,801 reads
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.
2008-10-02
10,876 reads
By Steve Jones
In a previous post, I set up the basic databases for the PoC project...
By Steve Jones
Today’s coping tip is to plan something fun and invite others to join you....
When encrypting a database with Transparent Data Encryption (TDE), a vital consideration is to...
I'm sure this has been asked many, many, many times and hoping several optimal...
How do I determine the initialization status of a subscription with T-SQL -- i.e,...
Has anyone migrated databases from on premise SQL Server to Azure Managed instance? If...