Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Auditing Rss

<< Newer    Items 41 to 60 of 120    Older >>
 

Security Auditing Matching Up Logins And Users

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?  Read more...
By Brian Kelley 2010/08/25 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 3,137 reads

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.  Read more...
By Sean Elliott 2010/08/17 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 7,225 reads

Auditing

For this Friday poll, Steve Jones asks about your auditing requirements.  Read more...
By Steve Jones 2010/07/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 972 reads

Auditing Events

By Steve Jones 2010/07/30 | Category: sql audit
Rating: (not yet rated) |  Discuss |   Briefcase | 2,718 reads

Auditing Foundation

By Steve Jones 2010/07/23 | Category: sql audit
Rating: (not yet rated) |  Discuss |   Briefcase | 2,567 reads

SQL Audit

By Steve Jones 2010/07/16 | Category: auditing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,837 reads

SQL Audit

By Steve Jones 2010/07/09 | Category: auditing
Rating: (not yet rated) |  Discuss |   Briefcase | 2,966 reads

Determining Object Access Using SQL Server Profiler

Deanna Dicken examines a SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object.  Read more...
By Additional Articles 2010/06/30 | Source: Database Journal | Category: profiler
Rating: (not yet rated)  Rate this |   Briefcase | 2,253 reads

Default trace - A Beginner's Guide

This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.  Read more...
By Adam Haines 2010/06/11 (first published: 2008/11/11) | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 39,357 reads

Tables and Views for Auditing SQL Server Logins

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?  Read more...
By Additional Articles 2010/06/04 | Source: MSSQLTips.com | Category: auditing
Rating:  Rate this |   Briefcase | 4,401 reads

Finding Jobs

This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.  Read more...
By Tushar Kanti 2010/05/05 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 5,987 reads

This Can't Happen

A bug reported on Connect has Steve Jones worried. This one could be a big deal in some situations that are concerned about comprehensive auditing.  Read more...
By Steve Jones 2010/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 138 reads

Retrieving Data from an Audit Table

This article examines the various methods for retrieving data from an Audit table.   Read more...
By Additional Articles 2010/04/09 | Source: SQL Server Performance | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 3,351 reads

SQL Server 2008 - Accessing Audit Details

Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.  Read more...
By Additional Articles 2010/03/31 | Source: Database Journal | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,002 reads

SQL Server 2008 Audit Change Group

Auditing your SQL Server instances has become more of a concern these days. SQL Server 2008 introduced a new feature named SQL Server Audit. Enabling this feature can be done in just a few simple steps, but so could disabling this feature. And when it comes to audits, many times you are asked to provide proof that the audit itself has not been tampered with.  Read more...
By Additional Articles 2010/03/15 | Source: MSSQLTips.com | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 1,625 reads

Database Activity Monitoring Part 1 - An Introduction

We are inundated with new technologies and products designed to help make our organisations safe from hackers and other malcontents. One technology that has gained ground over the past few years is database activity monitoring. It makes sense to protect valuable databases, and by adding an intelligent monitor capable of sniffing out threats an additional level of protection can be gained. But what is database activity monitoring and why should you care?   Read more...
By Additional Articles 2010/03/08 | Source: Other | Category: monitoring
Rating: (not yet rated)  Rate this |   Briefcase | 4,364 reads

Database Level Auditing with Microsoft SQL Server 2008

MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in Microsoft SQL Server 2008.  Read more...
By Additional Articles 2010/02/17 | Source: Database Journal | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 5,401 reads

SQL Script to check what was changed in database after 9PM Last night

This script will help the developers in multi-user environment to check if anyone else modified their tables, view, procedures etc..  Read more...
By Chrysanthemum 2010/11/10 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 5,248 reads

Auditing in SQL Server 2008

Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.  Read more...
By Additional Articles 2009/12/28 | Source: SQL Server Performance | Category: auditing
Rating:  Rate this |   Briefcase | 2,169 reads

SQL Server Security Audit Report

If your company needs to go through a SOX (Sarbanes–Oxley) audit or any security audit, the DBA has to provide security information to them. If you have purchased third party tools to provide this information that is great. If you don't have third party tools and need to go through many servers to provide this information it can be a hassle and very time consuming. So I put together a script to generate a report that I could just review. The script generates a report of all elevated level accounts and any possible security holes.  Read more...
By Additional Articles 2009/11/20 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 3,083 reads
<< Newer    Items 41 to 60 of 120    Older >>
 
Tags
security (21)    
sql server 2008 (17)    
editorial (12)    
administration (6)    
blogs (6)    
sql audit (6)    
sql server 2005 (6)    
triggers (6)    
change data capture (cdc) (5)    
monitoring (5)    
ddl triggers (4)    
logins (4)    
role (4)    
sql trace (4)    
change tracking (3)    
permissions (3)    
profiler (3)    
user (3)    
cdc (2)    
comparison (2)    
ddl (2)    
default trace (2)    
editorial - ipod (2)    
editorial - wmv (2)    
friday poll (2)    
members (2)    
ownership (2)    
principals (2)    
roles (2)    
secure (2)    
sql server (2)    
trace (2)    
t-sql (2)    
video (2)    
xml (2)    
audit_login_failed (1)    
audit_logout (1)    
authentication (1)    
c2 audit mode (1)    
ct (1)    
database design (1)    
database trigger (1)    
dml tracking (1)    
editorial - mp3 (1)    
extended events (1)    
extract, transform, load (etl) (1)    
integration services (ssis) (1)    
journal (1)    
login (1)    
microsoft (1)    
output (1)    
performance monitoring (1)    
performance tuning (1)    
permission (1)    
powershell (1)    
production support (1)    
replication (1)    
rollback (1)    
server side trace (1)    
server trigger (1)    
software development (1)    
sp_cycle_errorlog (1)    
sqlservercentral (1)    
windows (1)