Browse by Tags

All Tags » SQL (RSS)
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: , ,
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: , ,
Uninstalling Applications that do not appear in the Add / Remove Program
10 July 07 10:43 | Simon Phillips | with no comments
I recently instaled an appliaction (Laptop version of CRM Client which installed an instance of MS SQL Server 2005 express on to my machine which I wanted complete rid of, after uninstalling the application I was dismayed to find that the SQL express...
Filed under: ,
TechNet Magazine - March 2007 "SQL Server Month"
05 March 07 04:27 | Simon Phillips | with no comments
In the March edition of the TechNet Magazine (US Edition) there are some good starting articles on SQL Server IT Pros (but IMHO all Devs who use SQL Server should have at least an understanding in these topics). New Tools to Diagnose Index Health To get...
Filed under: ,
Roll up of the Latest Software and Services packs
23 February 07 02:29 | Simon Phillips | with no comments
SQL Server 2005 SP2 - This has been in CTP for what seams like ages, and I for all but one project have been holding off installing it for my development environments. As well as the usual fixes and enchancements they have put alot of work in data anaylsis...
Filed under: , ,
SQL Reporting Services: Using Parameter Queries with Oracle Sources
09 January 07 08:10 | Simon Phillips | with no comments
I came across this today when I tried to create a report in SQL Server Reporting Services against an Oracle database using the Oracle .Net Provider. Against SQL you can define parameters in the report query using @paramname syntax. This doesn't work against...
Filed under: ,
Error trying to browse cubes with SSMS
02 January 07 01:11 | Simon Phillips | with no comments
First of all Happy New Year everyone!! Every since I've moved to Office 2007 and uninstalled Office 2003, I've been having problems when I try and browse Cubes in Microsoft SQL Server Management Studio (SSMS). I was getting the following error Class not...
Filed under: ,
The FRED SCRIPT v2.0 (FOR DAVID AND MARK)
06 October 06 11:25 | Simon Phillips | with no comments
Years ago while I was with Parity, we were always having to truncate the log file on our development servers as we were always running out to disk space. We wrote a small little script which would truncate and shrink the log file and for some reason we...
Filed under:
Presentation Files from last week's TechNet SQL Server Events
02 October 06 04:19 | Simon Phillips | with no comments
TechNet Ireland have posted the presentations from last weeks TechNet events. Advanced SQL Server 2005 Reporting Services Advanced SQL Server 2005 Integration Services SQL 2005 Upgrade and Migration processes Source: Presentations from: Microsoft's SQL...
Filed under: ,