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.
2010-08-20 (first published: 2008-03-13)
55,369 reads
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.
2009-05-18
3,864 reads
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.
2009-05-11
6,381 reads
This should find all tables referenced by an sp. It uses syscomments and hence has a wrap 'issue'.
2008-12-30 (first published: 2008-12-05)
1,037 reads
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.
2008-01-28 (first published: 2007-02-21)
10,630 reads
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.
2007-08-20
5,170 reads
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
This is a generic question. To the moderators, I wasn't sure where to place...
Good Afternoon, I have built a table with four columns: Period(Month), Category, Numerator, Denominator....
Comments posted to this topic are about the item Level 28: DAX Text Functions:...
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( 'City':'Denver') GOSee possible answers