Archive

Archive for June, 2012

XQUERY – Examples and Scripts

June 26th, 2012 No comments

There are tons of thing in this world that I really don’t understand. SQL Server XQuery is just one of those just out of reach.  Poking around trying to answer a question for a developer, I found the following XML script examples. Teh writer provides excellent explanations and examples. Immediately found the right path(pun intended) to go down.  I so wished my brain worked this way!

XQuery Labs – A Collection of XQuery Sample Scripts

Jun 26 2008 3:41PM by Jacob Sebastian   

Read more…

Categories: DBA, Programming, SQL Server, t-sql, XML Tags:

SQL Script to Review Backup and Restore Processes

June 11th, 2012 No comments

A coworker shared this awesome script to monitor backup and restore operation progress. I am not sure of the origin, but is definitely has become an essential member of my SQL scripts folder.

Works on SQL 2005  – SQL2008 R2.  Not tested on SQL 2012.

Read more…

Categories: SQL Server, t-sql Tags: