Category Archives: SSRS

SQL Saturday May 2016, Jacksonville, FL

Hey, Everyone… our annual get-together of SQL professionals is happening on May 7th, at UNF, here in Jacksonville.  I will be speaking at 9 AM on breaking into the world of Azure & PowerBI, using (mostly) the skills you likely … Continue reading

Posted in Azure, Career, Performance Tuning, PowerBI, SQL Administration, SSAS, SSIS, SSRS | Leave a comment

SSRS Data Source Lister

Hello, Sometimes, you’re in the middle of doing something, and you need an answer.  You google it and find such a great solution, you want to keep it handy for … whenever!  Here is such a post.  As the title … Continue reading

Posted in SQL 2005, SQL 2008, SSRS | 1 Comment

SSAS not logging?

So you’ve followed all the advice and set up logging so that you can know who is using your cubes.  Things are good.  One day you wake up and see that your logs no longer are logging.  You open your cube … Continue reading

Posted in SQL 2008, SSAS, SSRS | Tagged , | 1 Comment

SSRS subscriptions not working

The problem: SSRS Subscription is not sending out emails. Where to find a typical error-log: C:\SQLServer\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles

Posted in SSRS | 2 Comments

SSRS Report History – keep more than 60 days

Many may know that the following query can get information about the history of reports being called. SELECT ss.UserName, ss.Format, ss.TimeStart, cat.Name, ss.Parameters, CONVERT(nvarchar(10), ss.TimeStart, 101) AS rundate FROM reportServer.dbo.ExecutionLog AS ss INNER JOIN Catalog AS cat ON ss.ReportID = … Continue reading

Posted in SSRS | Tagged | 1 Comment