SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Auditing Rss

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

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,918 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,822 reads

Last Accessed Datetime for table - 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 2016/03/07 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 3,071 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 | 650 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 | 90 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 | 326 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 | 147 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 | 22,157 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 2016/12/22 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 266 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,878 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,335 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 | 22,157 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,422 reads

Event Notification on Server

By Marek Grzymala 2013/05/22 | Category: audit_logout
Rating: (not yet rated) |  Discuss |   Briefcase | 1,743 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 | 80 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,092 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 | 171 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 | 92 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,586 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 | 22,157 reads
<< Newer    Items 21 to 40 of 144    Older >>
 
Tags
security (23)    
sql server 2008 (18)    
editorial (16)    
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)    
redgate (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 specification (1)    
audit_login_failed (1)    
audit_logout (1)    
authentication (1)    
c2 audit mode (1)    
compliance (1)    
ct (1)    
database audit specification (1)    
database design (1)    
database trigger (1)    
ddl_events (1)    
development (1)    
dml tracking (1)    
editorial - mp3 (1)    
etl (1)    
eventnotification (1)    
events (1)    
extended events (xe) (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)    
security log (1)    
server security (1)    
server side trace (1)    
server trigger (1)    
software development (1)    
sp_cycle_errorlog (1)    
sql census (1)    
sql server 2008 r2 (1)    
sqlservercentral (1)    
stairway series (1)    
survey (1)    
trigger (1)    
user permissions (1)    
windows (1)