SQL 2008 R2 – markwheeler.com

BMC Remedy Assigned Group Incident Transfer(s) Query

January 22, 2015 mmwheeler

Had a request from a customer for a report showing the number of Remedy incidents transferred from his managed group to other groups during a given date range. I figured out a pseudo lead/lag query for SQL Server 2008. This creates an output that aligns the current row with the […]

Rename SQL Server 2008 R2 Reporting Server Databases

June 13, 2012 mmwheeler

Had a task to move the default SQL Reporting Services ReportServer and ReportServerTempDB databases to a new SQL cluster which required a rename to avoid any potential conflicts. These instance of the databases are being used in Sharepoint-Integrated Mode. You could do Step 7 below before you do Steps 4 […]