Analyzing SQL Server Permissions
This article shows the steps to analyze SQL Server logins and permissions to ensure that there are no logins and users that exist who are have unnecessary access
2009-03-17
3,464 reads
This article shows the steps to analyze SQL Server logins and permissions to ensure that there are no logins and users that exist who are have unnecessary access
2009-03-17
3,464 reads
2009-02-09
4,882 reads
This Article shows a method to audit ETL-Processes to be able to retrace processes and affected data.
2008-12-12
11,154 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
11,247 reads
This is the final article of a three part series on Auditing in SQL Server 2008. This article shows how to setup a Database Audit Specification.
2008-09-30
2,246 reads
2013-04-02 (first published: 2008-09-11)
15,329 reads
SQL Server 2005 introduces the OUTPUT clause, a bit of magic that allows us to get the identity value, plus a number of other values, from an INSERT, UPDATE, or DELETE, which all have different interaction with OUTPUT. This article concentrates on INSERT.
2008-08-04
3,369 reads
Learn how to monitor database-level actions and write audit results to files.
2008-07-22
2,557 reads
In this article TJay Belt describes a process to help respond to audit requests in a timely manner
2008-06-18
2,393 reads
SQL Server 2008 February CTP introduces a new feature, SQL Server Audit. This feature facilitates auditing of Database Engine events by providing simple T-SQL statements to enable, store, and view audits on server and database objects. Part 1 of this series focuses on the server level events.
2008-06-16
2,860 reads
By DataOnWheels
Over the past couple of months, I have started losing my ability to talk...
By Steve Jones
apolytus– n. the moment you realize you are changing as a person, finally outgrowing...
If you've ever wrestled with complex SQL code, you know the drill. Hours spent...
Comments posted to this topic are about the item Do you listen to music...
I have a job running each night starting at 4:30AM and usually finishing at...
hi guys, I have a partitioned table AM_ITM_INSTNC_MSS and I want to get...
Our environment runs using SQL Server Standard. We are implementing Availability groups. Our database has been experiencing high read volumes, so I want to let the application read the Synchronized Secondary replica, as I read that HADR does this. Can we implement this?
See possible answers