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,387 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,869 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,396 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,040 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,638 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,188 reads
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
WhatsApp:0838-3161-8008 Jl. Pemuda No.90-92, Kembangsari, Kec. Semarang Tengah, Kota Semarang, Jawa Tengah 50133
Yeah, I know this is a 2022 forum, but I don't see a 2025...
I don't see a PowerBI forum, so I'm posting here. I have a need...
Which of these is not true for certificates used for SQL Server connections?
See possible answers