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 61 to 80 of 124    Older >>
 

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,408 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,262 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,180 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,095 reads

Auto Generate an Hourly SQL Server Profiler Trace File

I would like the option on some servers of having a profiler trace running 24x7 in the background. I could then access and read these trace files to investigate issues after the fact - much like the default trace that came out with SQL 2005.   Read more...
By Additional Articles 2009/09/29 | Source: MSSQLTips.com | Category: sql trace
Rating:  Rate this |   Briefcase | 3,470 reads

SQL Server Security Audit (Part 3) - Operating System Level Audit

The final part of the Security Audit series examines how to secure the Windows Server operating system.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,497 reads

Squeezing the DBA

What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.  Read more...
By Steve Jones 2009/09/03 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 291 reads

Squeezing the DBA

What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.  Read more...
By Steve Jones 2014/03/14 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 320 reads

Squeezing the DBA

What do you do as a DBA if you get asked to cook the books? With the economy doing poorly, some executives will be tempted to mis-report earnings and they might ask the technical people to help. Steve Jones has a few thoughts.  Read more...
By Steve Jones 2009/09/03 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 272 reads

SQL Server Security Audit (Part 2) - Database Level Audit

The second in the Security Audit series looks at securing an individual database.  Read more...
By Additional Articles 2009/09/01 | Source: SQL Server Performance | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,934 reads

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.  Read more...
By Additional Articles 2009/08/26 | Source: SQL Server Performance | Category: security
Rating:  Rate this |   Briefcase | 2,804 reads

Auditing with SQL Profiler

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.  Read more...
By Thom Bolin 2009/07/16 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 5,596 reads

The New Reality of an Audit Trail

With a continuation of his last article on auditing, Leo Peysakhovich enhances his solution to capture more details using XML.  Read more...
By Leo Peysakhovich 2009/07/08 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 6,074 reads

Who's been logging into my SQL Server?

In a recent blog post, see the steps Denny Cherry thinks are vital to monitoring both successful and unsuccessful outside user logins to your SQL Server.  Read more...
By Additional Articles 2009/06/29 | Source: SearchSQLServer | Category: auditing
Rating:  Rate this |   Briefcase | 4,694 reads

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?  Read more...
By Additional Articles 2009/05/28 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 2,692 reads

Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part II

Continuing with his series on using auditing information to roll transactions forward or back, David McKinney shows us how to generate audit triggers using XML.  Read more...
By David McKinney 2009/05/18 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 3,573 reads

Rant: Is It an Effective Control or Not?

This is spurred on by a comment a pen tester made. He was referring to a particular technology and said something to the effect of, "What do you expect? It's 30 year-old technology." I was stunned when the comment was relayed to me. My response...  Read more...
By Brian Kelley 2009/05/13 | Source: SQLServerCentral.com | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 1,805 reads

SQL Server Audit: Magic without a Wizard

In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or most highly-regulated industries. SQL Server 2008 Enterprise Edition includes all of the features, whereas SQL Server 2008 Standard Edition only provides a subset. What is most attractive about it, is that it is easy to administer, as Thomas LaRock explains.  Read more...
By Additional Articles 2009/05/12 | Source: SimpleTalk | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,109 reads

Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part I

Using an audit table to rollback changes to data might be a nice addition to many applications. David McKinney's new series looks at how you can use this data for RollBack or RollForward.  Read more...
By David McKinney 2009/05/11 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 6,017 reads

Protect and Monitor

How do you protect and monitor your databases? Auditing is one way, but Steve Jones thinks this subsystem in SQL Server needs to mature.  Read more...
By Steve Jones 2009/05/07 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 299 reads
<< Newer    Items 61 to 80 of 124    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)