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
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
Percent of Totals in Reporting Services (Simple way without Data Set editing)
Suppose you have the following data set: and you wanted to display this in reporting services, but also have the % of totals (i.e. Gold = 50% of all In Store Purchases). Turns out there is a very easy way to do this, assuming you are only basing this off of a Grand Total or total … 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
ERMAHBLERG 