Category Archives: SQL Server Reporting Services

Finding SSRS Reports Without A Data Source

When deploying reports to different environments it is possible to have reports not link to a data source.  These reports are unusable and it can be time consuming to find them if there are a lot of reports.  I knew … Continue reading

Posted in SQL Server Reporting Services | Tagged , , | Leave a comment

Installing SQL Server 2014 Data Tools

I noticed that SQL Server Data Tools (a.k.a. BIDS) was not listed under Shared Features on the SQL Server 2014 Developer DVD. So where did it go?  With SQL Server 2014, there is a link on the Installation Center window … Continue reading

Posted in Database Administration, Development, SQL Server Integration Services, SQL Server Reporting Services | Tagged , , | Leave a comment

Routinely Check SSRS Log Files

This week I learned that SSRS can run without writing to the SSRS log file.  I am referring to the text file in the  …<InstanceName>\Reporting Services\LogFiles directory.  In this case SSRS had stopped writing log files for over a month.  … Continue reading

Posted in SQL Server Reporting Services | Tagged | Leave a comment

Data Visualization

Passing a long a good article from the MSDN Business Intelligence blog on best practices in data visualization. http://blogs.msdn.com/b/microsoft_business_intelligence1/archive/2012/10/08/best-practices-in-data-visualization.aspx

Posted in SQL Server Reporting Services | Tagged | Leave a comment

Self-Service Reporting in SQL 2012

With the demise of SSRS Report Models in 2012, I thought this article from Paul Turley was very timely. http://blogs.msdn.com/b/mvpawardprogram/archive/2012/09/24/the-state-of-self-service-reporting.aspx

Posted in SQL Server Reporting Services | Tagged , , | Leave a comment

Free SQL Server 2012 Training

I am always on the lookout for some free training.  Registration and a Windows Live ID are are required but there is no cost for the training. http://www.microsoftvirtualacademy.com/colleges/sqlserver

Posted in Database Administration, SQL Server Integration Services, SQL Server Reporting Services | Tagged | Leave a comment

Connecting SSRS to Teradata

I have found that SSRS works quite well with Teradata.  Microsoft has a page on TechNet about using Teradata data sources.  I disagree with some of the directions and would like to see more detail on how to perform the … Continue reading

Posted in SQL Server Reporting Services, Teradata | Tagged , , | Leave a comment