As you probably already know, SQL Server has many DMVs (Dynamic Management Views) and System Objects that helps DBAs, these include performance counters, index statistics, resource locking information, user object IDs and many more.

Read more →

A few months back I needed to grab SSRS schedule information through T-SQL, essentially in a query so I can publish the data through an EXCEL sheet (with a data connection to the database).

Read more →

I scoured the internet for an XSLT template that replaces multiple strings (and multiple occurrences of those strings) and substitutes them with a particular value, I found something that almost does the job at this website, but the solution required an XML file to be referenced from within the XSLT, which meant that my CSharp WebService kicked up a fuss due to not having setup the appropriate security permissions when I was using the XmlTransform object, which needs to be setup by properly instantiating an XmlUrlResolver object.
Read more →