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

Content with tag Auditing Rss

   Items 1 to 20 of 148    Older >>

Login restriction from selected applications and users

It will help to DBA for restrict the SQL Users login from selected applications programs and track there logins with Host name and other details  Read more...
Rating: |  Discuss |   Briefcase | 305 reads

Ad Hoc Logs

We often make changes to production systems in an ad hoc manner. Steve asks how much auditing we might have in place.  Read more...
By Steve Jones 2018/03/23 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 50 reads

Audit systems: a good idea or a mess to maintain?

Audit systems can be a good idea, but they can also be a mess to maintain.  Read more...
By Ben Kubicek 2018/02/27 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 53 reads

Is This Database Being Used?

Can we delete this database, or is someone still using it?  Read more...
By Ginger Keys 2017/12/04 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,963 reads

Making Good Use of SQL Server Auditing

SQL Server Auditing is a powerful out-of-the box toolset that captures auditing information and writes to a file or the Event Log. This article examines the little things that might snag you up.  Read more...
By John F. Tamburo 2017/10/05 | Source: SQLServerCentral.com | Category: audit specification
Rating: |  Discuss |   Briefcase | 1,388 reads

Free prototype tool to audit SQL Server permissions

Redgate have just released SQL Census, a prototype tool from the Foundry division that makes auditing SQL Server user access permissions much easier. In this post Ally Parker shows how it works, tells us what's up next in the tool's development development, and explains how you can download it for free.  Read more...
By 2017/07/13 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 4,263 reads

3 Solutions For Auditing Long SQL Server Extracts or Loads

In this post, Tim Smith looks at the different options you can use to audit your SQL Server extracts and loads during the ETL process.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,597 reads

Simplifying the user access audit with SQL Census

SQL Census is the latest piece of technology to be developed within Redgate Foundry. Still early in its development, it’s a product that’s designed to help you explain to an auditor which of your colleagues are able to access business-critical SQL Server databases. Here's how it works, and how you can get involved with the early access program.  Read more...
By 2017/06/05 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,977 reads

Audit and compliance survey with prize draw

The Foundry team at Redgate have been investigating how different regulations impact work with SQL Server. They understand the many regulations, but need your help to get a better idea of all the related activities. How has your experience with auditing and compliance been in the past? Fill out this short survey to let the team know, and in return you'll be entered into a draw to win a $100 Amazon gift card.  Read more...
By 2017/03/30 | Source: Redgate | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,308 reads

Only as Good as Your Auditor

Today we have a guest editorial from Andy Warren that talks about auditing your organization.  Read more...
By Andy Warren 2017/03/10 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 60 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 | 267 reads

Change Login Auditing Option

Configure Login Auditing  
By ESAT ERKEC 2016/11/14 | Source: SQLServerCentral.com | Category: security
Rating: (not yet rated) |  Discuss |   Briefcase | 287 reads

Auditing DDL Actions

By Steve Jones 2016/04/11 | Category: auditing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,267 reads

Trigger Happy

This article looks at using triggers to audit and to prevent the performing of unintended actions.  Read more...
By Andy Jones 2016/03/28 | Source: SQLServerCentral.com | Category: trigger
Rating: |  Discuss |   Briefcase | 2,909 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,086 reads

Failed and Successful Login Auditing Using xp_readerrorlog

Script uses undocumented extended stored procedure xp_readerrorlog to find failed logins (grouped) and last successful login  Read more...
By Ryan Loftin 2015/12/30 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 933 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,370 reads

Stairway to SQL Server Security Level 11: Auditing

By defining server- and database-level audits, you can record just about any kind of event that occurs in SQL Server, which can be an invaluable source of security troubleshooting and forensic information when security breaches occur. In this stairway level you’ll learn how to define the various audit specification objects, how to capture audit data, and how to explore and use the data.  Read more...
By Don Kiely 2015/09/23 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 3,102 reads

Architecture for Auditing

The way in which auditing is build into our systems isn't the best way to implement the practice.  Read more...
By Steve Jones 2015/06/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 133 reads

Native Audits

This week Steve Jones asks if you're using the SQL Audit feature built into SQL Server.  Read more...
By Steve Jones 2015/05/22 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 132 reads
   Items 1 to 20 of 148    Older >>
security (24)    
editorial (18)    
sql server 2008 (18)    
administration (7)    
blogs (6)    
logins (6)    
sql audit (6)    
sql server 2005 (6)    
triggers (6)    
change data capture (cdc) (5)    
ddl trigger (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 (extract, transform, and load) (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)