Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Auditing Rss

<< Newer    Items 21 to 40 of 136    Older >>
 

The Future of Auditing

Auditing is a weak point in SQL Server according to Steve Jones. He looks at a few of its flaws.  Read more...
By Steve Jones 2013/12/05 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 193 reads

Security Queries: Server-level

A set of queries which attempt to gather as much security-related information on a server instance as possible.  Read more...
By Greg Drake 2013/11/05 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,812 reads

Security Queries: Database-level

A set of queries which attempt to gather as much security-related information on a single database as possible.  Read more...
By Greg Drake 2015/10/30 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 3,241 reads

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shivaram Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,912 reads

iSpy (on your development)

Using EventNotification (Service Broker - DDL_EVENTS) to audit Schema change on a Server, or any of it's databases  Read more...
By Rob Lobbe 2013/06/19 | Source: SQLServerCentral.com | Category: schemas
Rating: |  Discuss |   Briefcase | 1,398 reads

Event Notification on Server

By Marek Grzymala 2013/05/22 | Category: audit_logout
Rating: (not yet rated) |  Discuss |   Briefcase | 1,734 reads

Double Compliance

Sometimes auditing for one certification might help you pass another, but don't count on it.  Read more...
By Steve Jones 2013/04/08 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 77 reads

Who has accessed my 2005 server?

Find out who has been on my server using the Default trace.  Read more...
By Jack Corbett 2013/04/02 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 15,080 reads

Acing an Audit

Audits for technology groups can be time consuming and stress employees out. An article Steve Jones finds says an insurance company only needed 30 minutes to ace their audit.  Read more...
By Steve Jones 2013/01/29 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 168 reads

The Auditing Poll

Is auditing in use in your applications? Steve Jones wants to know as he thinks it will be more important in the future for most software.  Read more...
By Steve Jones 2013/01/11 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 91 reads

SQLServerCentral Runs sp_Blitz - Security

A series that looks at the SQLServerCentral database servers using the Brent Ozar Unlimited sp_blitz script. Read about what we learned.  Read more...
By Steve Jones 2013/01/10 | Source: SQLServerCentral.com | Category: sqlservercentral
Rating: |  Discuss |   Briefcase | 9,511 reads

List all Usernames, Roles for all the databases.

Generates a list of ALL Users and their database Roles for all Databases (Or for a specific user).  Read more...
By Shivaram Challa 2013/12/30 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 21,912 reads

Regulators, Mount Up

If you are bound by HIPAA regulations, you may have more auditing in your future. If you're not, perhaps you should still pay attention to the criteria being used for auditing.  Read more...
By Steve Jones 2012/11/28 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 105 reads

Auditing changes in Merge Replication

One trick I have learned from the folks on the Replication Support Team is how to proactively audit data changes...  Read more...
By Brandon J Williams 2012/10/17 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,903 reads

SQL Audit 301 – Using Powershell to Manage Audits

Today we’re going to go over some very basic scripts to create, drop, and copy SQL Audit objects using Powershell...  Read more...
By 2012/08/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,943 reads

SQL Audit 201 – Creating an Audit Solution

Welcome back, folks! Ok so, now that we’ve covered the basics of creating a SQL Audit and viewing the output, let’s...  Read more...
By 2012/08/06 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 5,576 reads

How to Audit Login Changes on a SQL Server

I've been charged with coming up with a quick solution to audit login changes on my SQL Servers. However, there's no budget so I'm going to have to come up with basic scripts and the like to do the work. Is this tip we cover a solution for you to audit login changes.  Read more...
By Additional Articles 2012/08/06 | Source: MSSQLTips.com | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,531 reads

SQL Audit 102 – Reading audit output

Last time we went over the basics of creating a SQL Audit. Now obviously once you’ve gotten your audit in...  Read more...
By 2012/07/19 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,163 reads

What, when and who? Auditing 101 - Part 3

Who messed around with my database? Auditing 101. In this article we will take a look at another technique available in SQL 2008 and higher. This new technique is SQL Audit.  Read more...
By Roy Ernest 2014/12/19 (first published: 2012/05/31) | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 13,736 reads

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 1,022 reads
<< Newer    Items 21 to 40 of 136    Older >>
 
Tags
security (22)    
sql server 2008 (18)    
editorial (15)    
administration (6)    
blogs (6)    
sql audit (6)    
sql server 2005 (6)    
triggers (6)    
change data capture (cdc) (5)    
ddl triggers (5)    
logins (5)    
monitoring (5)    
role (4)    
sql trace (4)    
change tracking (3)    
friday poll (3)    
permissions (3)    
profiler (3)    
t-sql (3)    
user (3)    
cdc (2)    
comparison (2)    
ddl (2)    
default trace (2)    
editorial - ipod (2)    
editorial - wmv (2)    
members (2)    
ownership (2)    
principals (2)    
roles (2)    
secure (2)    
sql server (2)    
trace (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)    
ddl_events (1)    
development (1)    
dml tracking (1)    
editorial - mp3 (1)    
eventnotification (1)    
events (1)    
extended events (1)    
extract, transform, load (etl) (1)    
integration services (ssis) (1)    
journal (1)    
login (1)    
microsoft (1)    
notifications (1)    
output (1)    
performance monitoring (1)    
performance tuning (1)    
permission (1)    
powershell (1)    
production support (1)    
replication (1)    
rollback (1)    
schemas (1)    
server security (1)    
server side trace (1)    
server trigger (1)    
software development (1)    
sp_cycle_errorlog (1)    
sql server 2008 r2 (1)    
sqlservercentral (1)    
stairway series (1)    
trigger (1)    
windows (1)