Filed under Useful T-SQL

Dynamic Pivot Table SQL Server 2008

We have a scenario where we need a dynamic pivot table from SQL data. I’m going to try and make this generic, so if there is confusion, please let me know. The scenario: We have a parent database and a child database. The child database has “attributes” for the parent database with values. SQL to … Continue reading

Logon Auditing in SQL Server

Currently at our business, the need for auditing Logons to a server, and some basic activity has came up recently. While the solution below was not implemented in our corproration. This is an elegant solution for a small SQL Server farm, with only a few instances of SQL Server. Some people may chose to do … Continue reading

Reporting Services 2005/2008 Job Lookup

Ever needed to manually run a report from Reporting Services, following the rules of a subscription, but don’t want to go through the effort of editing an existing subscription, letting it run, then editing it back or creating a new one? The following T-SQL Statement, when ran against the Reporting Services Database will allow you … Continue reading