Browse by Tags

Introducing Microsoft SQL Server 2008 – Free eBook Offer!
21 October 09 09:52 | Simon Phillips | with no comments

Just had the MS Press email land in my email this morning and again there is another free eBook offered this time on SQL Server 2008. You can find the link half way down the MS Learning: SQL Server -Training Portal under Special Offers. I was asked last...

Filed under: SQL Server

SQL Server Synonyms in queries using Linked Servers
18 September 09 11:45 | Simon Phillips | with no comments

OK Synonyms are not new in SQL, they were introduced back with SQL Server 2005, but to date I’ve never got round to using them until now. A synonym is really just a shortcut reference to a object (Table, View, Stored Procedure or Function) that resides...

Filed under: SQL Server

Microsoft TechNet Events Today and Tomorrow!!!
25 March 09 02:22 | Simon Phillips | with no comments

Just a reminder that there are a few Microsoft events being run over the next couple of days. ‘Tech Days’ are a collaborative effort between Microsoft and the IT Pro Community to re-deliver the highlights of Tech Ed Conference to IT Pros across Ireland...

Filed under: Events, Gaming, Community, Virtualisation, SharePoint, Business Intelligence, IT Pro, Microsoft, Xbox 360, SQL Server, Windows 7, Home Server, HyperV, Photos

SQL Server Reporting Services - Opening up hyperlink in a new window
28 January 08 11:17 | Simon Phillips | 3 comment(s)

By default if you create a navigation link in Reporting Services it opens the link in the same window. In the majority of cases this is fine as you usually use these for navigating to bookmarks within the same report or other reports. However there are...

Filed under: Business Intelligence, SQL Server

2008 is going to be a busy year! - Events
11 January 08 09:13 | Simon Phillips | with no comments

I've just blogged details about the up and coming Belfast Community Launch for Windows Server 2008, SQL Server 2008 and Visual Studio 2008, as well as some details about the official Microsoft Launch in Belfast later in the year and details about...

Filed under: Events, Community, Visual Studio IDE / Addins, Office 2007, Vista, IT Pro, SQL Server, Developer

Using date parameters in Reporting Services reports built against data cubes
27 September 07 03:20 | Simon Phillips | with no comments

I've came across a newsgroup question today, that I thought that I would blog about. When you create a report in Reporting Services against a SQL AS data cube and create a parameter against a date dimension the VS Report Designer creates a string...

Filed under: SQL, Business Intelligence, SQL Server

Installing Softgrid database on a SQL Server named instance when there is also a default instance - Done!
03 August 07 03:00 | Simon Phillips | with no comments

There is a known problem with the SoftGrid installation program that it can not deal with installing the database on to SQL Server when there is a named instance as well as a default instance installed on the server. IMHO there are a number of down falls...

Filed under: SQL, SoftGrid, SQL Server