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

Content with tag Auditing Rss

   Items 1 to 20 of 127    Older >>
 

Users , Roles and Logins

Useful script in cases where auditors would like to know roles for each user in each database of an instance as well as the status of associated logins.  Read more...
By Kenneth Igiri 2015/02/03 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 1,970 reads

Azure SQL Database Auditing

While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.  Read more...
By Additional Articles 2015/01/22 | Source: Database Journal | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 8,375 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,238 reads

What, when and who? Auditing 101 - Part 2

In my previous article we discussed Change Tracking which is one of the new technologies introduced by Microsoft. This article will focus on Change Data Capture.   Read more...
By Roy Ernest 2014/12/12 (first published: 2012/01/16) | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 12,559 reads

What, When and who? Auditing 101

In this article we will take a look at one of the new technology that was introduced in SQL Server 2008 for Auditing.   Read more...
By Roy Ernest 2014/12/05 (first published: 2011/11/28) | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 15,475 reads

Last Accessed Datetime for table - Most easiest way

This function is used to get the complete table lists are particular table and its last access datetime.  Read more...
By Vignesh Arulmani 2014/11/25 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 1,955 reads

The Need for Auditing

Is C2 auditing widely used? Should it be more widely used? Steve Jones talks about the subject of auditing in today's editorial.  Read more...
By Steve Jones 2014/09/16 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 630 reads

Disconnecting Auditing

Currently we have system administrators responsible for securing our systems, including the auditing capabilities. However that's not the best way to ensure that we can protect our systems.  Read more...
By Steve Jones 2014/08/18 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 86 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 | 321 reads

Auditing Matters

We might not be able to stop hacks, attacks, or issues with our databases, but knowing that they've occurred is important. Steve Jones notes that we might need auditing more than security.  Read more...
By Steve Jones 2014/02/24 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 139 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,134 reads

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 | 187 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,409 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 2013/11/04 | Source: SQLServerCentral.com | Category: secure
Rating: |  Discuss |   Briefcase | 1,983 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,134 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,318 reads

Event Notification on Server

By Marek Grzymala 2013/05/22 | Category: audit_logout
Rating: (not yet rated) |  Discuss |   Briefcase | 1,707 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,064 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 | 158 reads
   Items 1 to 20 of 127    Older >>
 
Tags
security (22)    
sql server 2008 (18)    
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)    
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 side trace (1)    
server trigger (1)    
software development (1)    
sp_cycle_errorlog (1)    
sql server 2008 r2 (1)    
sqlservercentral (1)    
windows (1)