Query Another Instance of SQL Server with sp_addlinkedserver and sp_addlinkedsrvlogin

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 […]

Format a Timestamp String Expression for a Filename in SSIS

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 […]

Deploy SSRS Report Parts From Report Designer with SQL Server Data Tools

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 […]

Monday SSRS Quick Tip – Formatting 24 hour time

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 […]

Learn Excel in your Coffee Break

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 !

New Table Not Found in SQL Management Studio

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.