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

Guest Columnist: David McKinney

SQLServerCentral.com profile

   Items 1 to 5 of 5   

Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part II

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.  Read more...
By David McKinney 2009/05/18 | Source: SQLServerCentral.com | Category: xml
Rating: |  Discuss |   Briefcase | 3,598 reads

Imaginative Auditing with Rollback (Undo) and RollForward (Redo) Part I

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.  Read more...
By David McKinney 2009/05/11 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 6,055 reads

Linking to the Previous Row

One common problem in querying is to reference the previous row in a data set as part of a calculation. David McKinney brings us an interesting solution using SQL Server 2005.  Read more...
By David McKinney 2010/08/20 (first published: 2008/03/13) | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 53,688 reads

An Auditing Solution with XML And XSL

Auditing is something that almost every DBA needs to tackle at some point in his or her career. David McKinney brings a new twist on the solution by using XML and XSL to help implement auditing in your SQL Server application.   Read more...
By David McKinney 2007/08/20 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 5,057 reads

I've Got the XML - Now What?

Getting a result set of XML is the easy part, but what about exporting the data in a human readable format? Most DBAs don't spend a lot of time formatting XML output, but it doesn't hurt to know how. New author David McKinney brings us a technique for generating an XML article and then using SSIS and XSL to transform it into an HTML page.   Read more...
By David McKinney 2007/02/21 | Source: SQLServerCentral.com | Category: xsl
Rating: |  Discuss |   Briefcase | 10,197 reads
   Items 1 to 5 of 5