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

Articles with tag Auditing Rss

Search for any content tagged auditing

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

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,570 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

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,624 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,780 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,914 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,815 reads

Field Level Auditing using Change Data Capture – Part 2

Second part of two part article on Change Data Capture for field level auditing and marting that data using SSIS for reports. I uploaded the entire Word document that includes the images.  Read more...
Rating: |  Discuss |   Briefcase | 4,103 reads

Field Level Auditing using Change Data Capture - Part 1

A two part article on Change Data Capture for field level auditing and marting that data using SSIS for reports.   Read more...
Rating: |  Discuss |   Briefcase | 6,744 reads

Writing Nearly Codeless Apps: Part 3

As we continue in this series, see how auditing tables are used to track all changes that are made to the main data tables.  Read more...
By David Ziffer 2010/10/20 | Source: SQLServerCentral.com | Category: software development
Rating: |  Discuss |   Briefcase | 8,220 reads

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 3

Part 3 of the series on using MAP 5.0 looks at Software Usage Tracker audit mecanism, as well as migrating and uninstalling the MAP database.  Read more...
By Additional Articles 2010/10/12 | Source: SQL Server Performance | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 1,582 reads

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 2

Part 2 of the series on using MAP 5.0 looks at using the toolkit to inventory servers, preparing audit reports and server virtualization planning.  Read more...
By Additional Articles 2010/10/07 | Source: SQL Server Performance | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,008 reads

Auditing with Microsoft Assessment and Planning (MAP) Toolkit 5.0 - Part 1

The first in this three part series on using Microsoft Assessment and Planning (MAP) Toolkit 5.0 introduces the toolkit and gets started with install and using it.  Read more...
By Additional Articles 2010/10/05 | Source: SQL Server Performance | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 1,654 reads

Security Auditing Matching Up Logins And Users

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?  Read more...
By Brian Kelley 2010/08/25 | Source: MSSQLTips.com | Category: security
Rating: (not yet rated)  Rate this |   Briefcase | 3,372 reads

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.  Read more...
By Sean Elliott 2010/08/17 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 7,369 reads

Auditing

For this Friday poll, Steve Jones asks about your auditing requirements.  Read more...
By Steve Jones 2010/07/30 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 1,108 reads

Determining Object Access Using SQL Server Profiler

Deanna Dicken examines a SQL Server Profiler event to determine object access...who is using the object, when, and how. This gives the SQL developer or database administrator much needed information for impact analysis prior to a change or the decommissioning of a SQL Server object.  Read more...
By Additional Articles 2010/06/30 | Source: Database Journal | Category: profiler
Rating: (not yet rated)  Rate this |   Briefcase | 2,540 reads

Default trace - A Beginner's Guide

This article is the beginner's guide to Default Trace. The article outlines how to query the default trace for key trace events, with a focus on DDL history.  Read more...
By Adam Haines 2010/06/11 (first published: 2008/11/11) | Source: SQLServerCentral.com | Category: sql server 2005
Rating: |  Discuss |   Briefcase | 41,870 reads

Tables and Views for Auditing SQL Server Logins

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?  Read more...
By Additional Articles 2010/06/04 | Source: MSSQLTips.com | Category: auditing
Rating:  Rate this |   Briefcase | 4,692 reads

Finding Jobs

This article from Tushar Kanti will help you identify the list of all the Jobs related to a Table/View/Procedure.  Read more...
By Tushar Kanti 2010/05/05 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 6,009 reads

This Can't Happen

A bug reported on Connect has Steve Jones worried. This one could be a big deal in some situations that are concerned about comprehensive auditing.  Read more...
By Steve Jones 2010/05/04 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 138 reads
<< Newer    Items 21 to 40 of 97    Older >>