SSIS Date Time Issues with Parameterized Queries

We ran into a major issue with Integration Services, which caused us a major scare, so I wanted to share it. We had a query, which was pulling out a list of items to compare to determine what to load. This list was generated with a simple query, where the date was calculated like this: … Continue reading

Advertisement

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 Subscription Status

Thanks to some SMTP changes, we’ve had tons of reports fail recently!!!! I needed a quick an easy way to see the subscription status of a report, and here is what I have devised: The code above will show ALL reporting services reports on Reporting Services 2005 and 2008, and will give the last 36 … Continue reading

BIDS Helper

I needed to be able to clear my reporting services data cache to get accurate loading times for reports. Unfortunately, you have to manually find the .rdl.data files and delete them, or run command line text to clear them. After a little research, I found an awesome tool which not only added a right click … Continue reading

Gantt Chart of SQL Jobs

Recently, the need to map out SQL Jobs and their times has become more important to me. I needed a listing of SQL Jobs the scheduled times, and their duration, with the status. While our in house management tool provided the information I wanted an easier and more friendly tool to view these through, so … 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