Obtain a list of reports in your SQL Server Reporting Services Catalog with this nice query, which you can plug straight into a Reporting Services report. Thanks to Nathon Dalton for this blog http://nathondalton.wordpress.com/2010/02/22/get-reporting-services-report-list-from-database/
Many to many relationships are a fact of life in business intelligence data modelling. Whether you are just starting out or halfway down the road, be sure to read the following article by Marco Russo and Alberto Ferrari – and excellent paper on Many to Many relationships in Analysis Services. http://www.sqlbi.com/wp-content/uploads/The_Many-to-Many_Revolution_2.0.pdf
Adding a linked server through SQL Server Management studio can be a tad confusing. You could be much better off using a standard set of T-SQL commands to help expedite the setup using sp_addlinkedserver and sp_addlinkedsrvlogin. Here goes … SP_ADDLINKEDSERVER The following example creates a linked server to another sql instance : SP_ADDLINKEDSRVLOGIN The following example uses […]
Two useful methods for how to format a timestamp string in SSIS – assign to a package variable via a Script task, or, via a regular expression. Both techniques are outlined. The first option is to use the Script task and then use .Net code to format the timestamp as outlined here… http://www.mssqltips.com/sqlservertip/2530/dynamically-name-text-files-in-sql-server-integration-services/. Another simpler alternative for […]
Report Parts can be managed in SQL Server Data Tools (previously Business Intelligence Development Studio) through the Report Designer, as well as Report Builder 3.0 (available in SQL Server 2008 R2). From your SQL Server Data Tools (SSDT) Project, double click your report, go to the Report Menu and Select Publish Report Parts, then select […]
You get multiple Winlogon.exe – No disk in drive errors on shutdown of Windows 8. Additionally, the PC hangs in a powered state, even though the monitor has switched off. Initially I thought this was due to driver issues with the PC’s card reader, however stumbled on this excellent blog http://www.ptmaroct.com/2012/06/fix-windows-8-rc-shutdown-errors.html. Disabled fast start up (search Control […]
You can format a datetime column as 24 hour time in a Tablix by issuing a capital HH for the hour component in the Format property. e.g. the following expression will show 24 hour time. Note HH will do leading zeros where applicable, H will not. … and the following expression will show regular 12 hour […]
A new Reporting Services Content migration tool is available from Microsoft labs http://www.microsoft.com/en-us/bi/featureVideo.aspx?videoId=ZL8FqCcxBsU – Yay ! It only supports Native mode to Sharepoint deployments – Awwwww ! Support for Native mode to Native mode is supposed to be coming soon – Yay ! First timers can use the GUI option to extract – Yay ! The […]
Those new to Excel, or who have successfully managed to avoid the calls of “who’s an Excel expert here?” over the years, the following site will provide an easy toe in the water experiece, with short, sharp tutorials for most of the Excel basics http://www.excel-easy.com/. Good fodder for your coffee break !
Your SQL Management Studio query session can’t find the table you have just created..sigh. It is likely the new table hasn’t made its way into the local cache. Quickest workaround is to go to the Edit menu, select Intellisense and then Refresh Local Cache.