Melville Thomson's Blog

Data, SQL and Windows Technologies

November, 2006

  • Accessing Reports using URL Access in SQL Server 2005

    I was asked today for some resources and information on Report Services. First there is a way to access reports using URL Access; there is a white paper here. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_374y...
  • Configure Reporting Services to Use a Non-Default Web Site

    I was asked about configuring Reporting Services to use a non-default Web Site. The information to do this is in BOL Configure Reporting Services to Use a Non-Default Web Site . This also highlights some workarounds for HTTP 401.1 errors. There is also...
  • Webcasts For SQL Server

    For anyone interested in SQL Server there is loads of content available. There is a new webcast next week for Data Mining add-ins for office 2007 see below. I have also provided links to all the previous SQL Webcasts. by subject area. TechNet Webcast...
  • SQL Server Manageability Team Blog

    I am going to add the SQL Server Manageability Team Blog to my links there is a great post about running reports inside Management Studio . This ability was added with SP2. Both Simon and Dan have mentioned this earlier.
  • Resources for URL Access to Reports

    I have been asked again about URL Access methods with programming again I can expand on the amount of information other than the white papers. See my previous post . I am at a conference for the rest of the week but will try and cover a bit more about...
  • SQL Server 2005 SP2 CTP Download working link

    This is the correct link to the SQL Server 2005 SP2 CTP . There was a slight error on the previous link that I copied from Euan ;-). Sorry
  • SQL Server Webcasts for December

    Here is a list of SQL Server Webcasts for December. For links to previous webcasts and labs see my previous post . Introduction to SQL Server 2005 report Builder Join us as we illustrate the architecture behind Report Builder, demonstrate its capabilities...
  • Resources for Reporting Services

    Just to highlight some of the answers to a lot of questions I get asked. On TechNet there are various Reporting Services InfoCenters . These InfoCenters are navigation topics in the SQL Server Books Online. The information is organized by the roles that...
  • Install Reporting Services side by side with an earlier version

    I was asked on Monday about issues concerning installing SQL 2000 for the Reporting Service database and using SQL 2005 services. There is a whitepaper covering multiple installations . You need to be careful as there are a few caveats to be aware of...
  • Microsoft UK Challenge (my challenge)

    On 20 - 24 June next year I am going to attempt to do the Microsoft UK Challenge event. The reason I'm mentioning this now is my training started last Saturday 18 Nov. Tomorrow I am in the Gym at 0700 here in Reading. This will be a weekly commitment...
  • Microsoft at UK Oracle User Group conference

    Just to bring you up to date last week I was in Birmingham at the UK Oracle User Group for three days. The rest of the team were at IT Forum in Barcelona. I was manning the Microsoft stand in Birmingham. ‘Ah’ I hear you say and I was asked several times...
  • 'Introduction to Report Services' Event in Edinburgh 7 Nov

    I have just got back from the TechNet Event in Edinburgh. Having it in the afternoon rather than the evening seemed to go down very well. We had to bring in extra chairs to fit everyone in. There were a couple of questions about resources for Report...
  • Changing the location of Log files for SQL Server Reporting Services

    I was asked earlier this week by mail this very question. I found the answer on the Microsoft SQL Server Support Blog . It is quite a straight forward procedure. There is a link to this blog on the sidebar.
  • SQL Server 2005, SP2 CTP Available

    Hot from Euan Garden’s Blog SQL Server 2005, SP2 CTP Available. To find out what’s new Also the download page will be live later this link was not active at 23:31 UK time. Chris Webb has bloged about what’s new in Analysis Services already tonight. ...
  • SQL Technet Events in November (UK)

    We are starting to provide TechNet events around the Uk rather than just in London. so please give us feedback. Do check the details for the sessions as some of them may be during day rather than evening sessions. 07 November 2006, Edinburgh: Enhance...