﻿<?xml version="1.0" encoding="utf-8"?><rss xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" version="2.0"><channel><title>SQLServerCentral.com Articles tagged Auditing</title><link>http://www.sqlservercentral.com/</link><description>Articles tagged Auditing posted on SQLServerCentral.com</description><language>en-us</language><ttl>360</ttl><managingEditor>sjones@sqlservercentral.com (Steve Jones)</managingEditor><item><title>Default trace - A Beginner's Guide</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/</guid><pubDate>2008/11/11</pubDate><link>http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/</link></item><item><title>SQL Server 2008 : Accessing Audit Details</title><description><![CDATA[Learn how to use the SQL Server 2008 catalog view and dynamic management view to access the audit details of existing server and database level audits.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69813/</guid><pubDate>2010/03/12</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69813/</link></item><item><title>SQL Server 2008 Audit Change Group </title><description><![CDATA[Auditing your SQL Server instances has become more of a concern these days. SQL Server 2008 introduced a new feature named SQL Server Audit. Enabling this feature can be done in just a few simple steps, but so could disabling this feature. And when it comes to audits, many times you are asked to provide proof that the audit itself has not been tampered with.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69805/</guid><pubDate>2010/03/15</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69805/</link></item><item><title>Database Activity Monitoring Part 1 - An Introduction</title><description><![CDATA[ We are inundated with new technologies and products designed to help make our organisations safe from hackers and other malcontents. One technology that has gained ground over the past few years is database activity monitoring. It makes sense to protect valuable databases, and by adding an intelligent monitor capable of sniffing out threats an additional level of protection can be gained.

But what is database activity monitoring and why should you care? ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69648/</guid><pubDate>2010/03/08</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69648/</link></item><item><title>Database Level Auditing with Microsoft SQL Server 2008</title><description><![CDATA[MAK shows us how easy it is to create a database level audit, test the audit and retrieve the audit records in Microsoft SQL Server 2008.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69534/</guid><pubDate>2010/02/17</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69534/</link></item><item><title>Auditing in SQL Server 2008</title><description><![CDATA[Auditing is not only used to ensure internal compliance with authorization rules, it is increasingly used to comply with new legal compliance requirements. This article provides a detailed walkthrough for using SQL Server 2008's new inbuilt Audit feature.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/69031/</guid><pubDate>2009/12/28</pubDate><link>http://www.sqlservercentral.com/redirect/articles/69031/</link></item><item><title>SQL Server Security Audit Report</title><description><![CDATA[If your company needs to go through a SOX (Sarbanes–Oxley) audit or any security audit, the DBA has to provide security information to them. If you have purchased third party tools to provide this information that is great. If you don't have third party tools and need to go through many servers to provide this information it can be a hassle and very time consuming. So I put together a script to generate a report that I could just review. The script generates a report of all elevated level accounts and any possible security holes.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68795/</guid><pubDate>2009/11/20</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68795/</link></item><item><title>Auto Generate an Hourly SQL Server Profiler Trace File</title><description><![CDATA[I would like the option on some servers of having a profiler trace running 24x7 in the background. I could then access and read these trace files to investigate issues after the fact - much like the default trace that came out with SQL 2005. ]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68286/</guid><pubDate>2009/09/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68286/</link></item><item><title>SQL Server Security Audit (Part 3) - Operating System Level Audit</title><description><![CDATA[The final part of the Security Audit series examines how to secure the Windows Server operating system.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68032/</guid><pubDate>2009/09/07</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68032/</link></item><item><title>Squeezing the DBA</title><description><![CDATA[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.<!-- Free trial of SQL Backup™ -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup"><img alt="SQL Backup" height="68" src="http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Free trial of SQL Backup™</strong><br />“SQL Backup was able to cut down my backup time <br>significantly AND achieved a 90% compression at <br>the same time!” Joe Cheng. <a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup">Download a free trial now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68050/</guid><pubDate>2009/09/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68050/</link></item><item><title>Squeezing the DBA</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/articles/Editorial/68047/</guid><pubDate>2009/09/03</pubDate><link>http://www.sqlservercentral.com/articles/Editorial/68047/</link></item><item><title>Squeezing the DBA</title><description><![CDATA[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.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/68051/</guid><pubDate>2009/09/03</pubDate><link>http://www.sqlservercentral.com/redirect/articles/68051/</link></item><item><title>SQL Server Security Audit (Part 2) - Database Level Audit  </title><description><![CDATA[The second in the Security Audit series looks at securing an individual database.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67883/</guid><pubDate>2009/09/01</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67883/</link></item><item><title>SQL Server Security Audit (Part 1) - Server Level Audit</title><description><![CDATA[The first of this three part series on SQL Server Security Auditing focuses on the SQL Server itself and addressing any of its security vulnerabilities.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67818/</guid><pubDate>2009/08/26</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67818/</link></item><item><title>The New Reality of an Audit Trail</title><description><![CDATA[With a continuation of his last article on auditing, Leo Peysakhovich enhances his solution to capture more details using XML.]]></description><guid>http://www.sqlservercentral.com/articles/Auditing/67224/</guid><pubDate>2009/07/08</pubDate><link>http://www.sqlservercentral.com/articles/Auditing/67224/</link></item><item><title>Who's been logging into my SQL Server?</title><description><![CDATA[In a recent blog post, see the steps Denny Cherry thinks are vital to monitoring both successful and unsuccessful outside user logins to your SQL Server.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/67264/</guid><pubDate>2009/06/29</pubDate><link>http://www.sqlservercentral.com/redirect/articles/67264/</link></item><item><title>Automate collection and saving of failed logins for SQL Server</title><description><![CDATA[I re-cycle my SQL Server log every night using sp_cycle_errorlog. However, before I do, I would like to capture all of the failed logins recorded. I have auditing turned on for failed logins, but I want to make sure that I capture those events into a table so I can report on. How can I do this?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66974/</guid><pubDate>2009/05/28</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66974/</link></item><item><title>Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part II</title><description><![CDATA[Continuing with his series on using auditing information to roll transactions forward or back, David McKinney shows us how to generate audit triggers using XML.]]></description><guid>http://www.sqlservercentral.com/articles/XML/66518/</guid><pubDate>2009/05/18</pubDate><link>http://www.sqlservercentral.com/articles/XML/66518/</link></item><item><title>Rant: Is It an Effective Control or Not?</title><description><![CDATA[This is spurred on by a comment a pen tester made. He was referring to a particular technology and said something to the effect of, &quot;What do you expect? It's 30 year-old technology.&quot; I was stunned when the comment was relayed to me. My response...]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66865/</guid><pubDate>2009/05/13</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66865/</link></item><item><title>SQL Server Audit: Magic without a Wizard</title><description><![CDATA[In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or most highly-regulated industries. SQL Server 2008 Enterprise Edition includes all of the features, whereas SQL Server 2008 Standard Edition only provides a subset. What is most attractive about it, is that it is easy to administer, as Thomas LaRock explains.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66867/</guid><pubDate>2009/05/12</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66867/</link></item><item><title>Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part I</title><description><![CDATA[Using an audit table to rollback changes to data might be a nice addition to many applications. David McKinney's new series looks at how you can use this data for RollBack or RollForward.]]></description><guid>http://www.sqlservercentral.com/articles/Auditing/66517/</guid><pubDate>2009/05/11</pubDate><link>http://www.sqlservercentral.com/articles/Auditing/66517/</link></item><item><title>Protect and Monitor</title><description><![CDATA[How do you protect and monitor your databases? Auditing is one way, but Steve Jones thinks this subsystem in SQL Server needs to mature.]]></description><guid>http://www.sqlservercentral.com/articles/Editorial/66848/</guid><pubDate>2009/05/07</pubDate><link>http://www.sqlservercentral.com/articles/Editorial/66848/</link></item><item><title>Protect and Monitor</title><description><![CDATA[How do you protect and monitor your databases? Auditing is one way, but Steve Jones thinks this subsystem in SQL Server needs to mature.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66857/</guid><pubDate>2009/05/06</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66857/</link></item><item><title>Protect and Monitor</title><description><![CDATA[How do you protect and monitor your databases? Auditing is one way, but Steve Jones thinks this subsystem in SQL Server needs to mature.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66856/</guid><pubDate>2009/05/06</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66856/</link></item><item><title>Protect and Monitor</title><description><![CDATA[How do you protect and monitor your databases? Auditing is one way, but Steve Jones thinks this subsystem in SQL Server needs to mature.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66855/</guid><pubDate>2009/05/06</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66855/</link></item><item><title>Auditing Failed Logins in SQL Server</title><description><![CDATA[An auditor has taken a look at our SQL Servers and has told us that we need to audit login failures to the SQL Servers themselves. How do we do this?]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66768/</guid><pubDate>2009/05/06</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66768/</link></item><item><title>Auditing in SQL Server 2008</title><description><![CDATA[This paper provides a comprehensive description of the new feature along with usage guidance and then provides some practical examples.]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66588/</guid><pubDate>2009/04/23</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66588/</link></item><item><title>Introduction to Profiler</title><description><![CDATA[This article introduces Profiler presenting what it is, how to use it, and why you might want to use it.<!-- Free trial of SQL Backup™ -->
<table border="0" cellpadding="0" cellspacing="10" width="100%">
 <colgroup>
  <col width="68" />
  <col width="1266" />
 </colgroup>
 <tr align="left" valign="top">
  <td><a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup"><img alt="SQL Backup" height="68" src="http://www.red-gate.com/images/sql_server_central/backup3d_68x68.gif" width="68" border="0"/></a></td>
  <td><strong>Free trial of SQL Backup™</strong><br />“SQL Backup was able to cut down my backup time <br>significantly AND achieved a 90% compression at <br>the same time!” Joe Cheng. <a href="http://www.red-gate.com/products\SQL_Backup\offers\backup_free_trial.htm?utm_source=ssc&utm_medium=rss&utm_content=backuptrial200912&utm_campaign=sqlbackup">Download a free trial now.</a><img src="/Images/spacer.gif?d=ad_olr1"/></td>
 </tr>
</table>]]></description><guid>http://www.sqlservercentral.com/articles/Administration/66217/</guid><pubDate>2009/04/16</pubDate><link>http://www.sqlservercentral.com/articles/Administration/66217/</link></item><item><title>Analyzing SQL Server Permissions</title><description><![CDATA[This article shows the steps to analyze SQL Server logins and permissions to ensure that there are no logins and users that exist who are have unnecessary access]]></description><guid>http://www.sqlservercentral.com/redirect/articles/66173/</guid><pubDate>2009/03/17</pubDate><link>http://www.sqlservercentral.com/redirect/articles/66173/</link></item><item><title>Removing Audit History - SQL School Video</title><description><![CDATA[MVP Andy Warren continues his series of videos on auditing with a look at removing old data. In this video, learn how to develop an easy system to keep a rolling history, removing anything older than a set number of days.]]></description><guid>http://www.sqlservercentral.com/articles/Video/65297/</guid><pubDate>2009/03/12</pubDate><link>http://www.sqlservercentral.com/articles/Video/65297/</link></item></channel></rss>