Melville Thomson's Blog

Data, SQL and Windows Technologies

Melville Thomson's Blog

  • 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...
  • Microsoft SQL Server Webcast for June

    TechNet Webcast: Microsoft Business Intelligence (BI) Using the Kimball Method (Level 200) Tuesday, June 06, 2006 - 9:30 AM - 10:30 AM Pacific Time Warren Thornthwaite, Speaker, Kimball Group Real success in business intelligence (BI) is defined...
  • Microsoft Office Business Scorecard Manager 2005: An Introduction - Event

    Microsoft Office Business Scorecard Manager 2005: An Introduction 27 September 2006 18:30 - 27 September 2006 21:00 GMT, London Welcome Time: 18:00 Language: English Microsoft Ltd Chicago 1&2 Building 3 Microsoft Campus Thames Valley Park...
  • Looking for a SQL Server/Business Intelligence IT Pro Evangelist

    Eileen is looking to extend her team and is looking for two new IT Pro Evangelists to join us in the UK. One of these will be a SQL Server/Business Intelligence person. The details for the job are here . What we are looking for is someone who is technical...
  • Scottish SQL User Group meeting next week (6th Dec) - Edinburgh

    Hi all. Earlier this year we tried to get a Scottish User Group for SQL Server. Martin Bell has agreed to try and kick start it of again. Tony Rogerson is supporting Martin. Please come along and show your support for this. There will be a prize for the...
  • New Viso Diagrams for MOSS2007

    I picked this up from Alexander Windel's Blog. It reminds me of the conversation I had with Tony he was looking to set up reports using SharePoint for a customer. These Visio diagrams are really useful and have lots of info on them. If you don?t have...
  • SQL Server Webcasts for the week of December 18 - 22

    Momentum Webcast: Microsoft Business Intelligence Solutions with SQL Server 2005 (Level 100) Date: Thursday, January 18, 2007 11:00 AM Pacific Time (US & Canada) Momentum Webcast: Microsoft Business Intelligence Solutions with SQL Server 2005 (Level...
  • How Creative are You With System Designs ?

    It seems a strange question, last year we started DesignIT this is a design competition.for charity. Last year it was a great success the aim is to design a solution to benefit a charity in the UK. We will make sure the winning design is implemented up...
  • SQL Server 2005 Compact Edition

    I would just like to highlight the SQL Server 2005 Compact Edition. The download page is here . This is the latest SQL Server Compact Edition add-ins, updates, tools and all the parts to enable you to build occasionally–connected mobile and desktop applications...
  • 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...
  • Microsoft SQL Server Webcast for May

    TechNet Webcast: SQL Server 2005 for the IT Professional (Part 9 of 11): Implementing Database Mirroring (Part 2 of 2) (Level 200) Friday, May 05, 2006 - 9:30 AM - 11:00 AM Pacific Time Kimberly L. Tripp, SQL Server MVP and Microsoft Regional Director...
  • 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...
  • Webcasts for SQL Server for Jan and Feb

    Momentum Webcast: Microsoft Business Intelligence Solutions with SQL Server 2005 (Level 100) Thursday, January 18, 2007 11:00 A.M.–12:00 P.M. Pacific Time TechNet Webcast: Protecting SQL Server with System Center Data Protection Manager (DPM...
  • SQL Server Starter Data Schemas

    I know this is a repeat of the post form Dan but as he is on MSDN and I am on TechNet blogs I think it goes to a slightly different audience. I was asked about schema design by Andy from BETT 2007 where we did technical support for the Microsoft stand...
  • MSDE nearing End of Life - No MSDE Support on Vista

    I know this is going to upset quite a few people and it will cause a bit of pain. Eric Has posted this on MSDN Blogs. As you may be aware MSDE is coming to the end of its support lifecycle. It will not be supported on windows Vista. As a replacement SQL...
  • Microsoft Office PerformancePoint Server 2007

    After the launch event on Tuesday I have had a couple of questions about Microsoft Office PerformancePoint Server 2007. While I was browsing Chris Webb's blog he highlighted a couple of blogs with info so rather than point you to the standard locations...
  • 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...
  • SQL Server - Best Practices

    This is a great resource and I would just like to highlight it in case you missed it. Euan Garden mentioned it in passing before Christmas. The SQL Server - Best Practices Site has loads of great information there are links to Technical White papers....
  • The Microsoft Technical Roadshow 2007

    Hi all now that the launch event is past and we are into a new year, the next Event to look forward to is The Microsoft Technical Roadshow 2007 . The show will visit 5 locations starting on the 20 Feb and finishing on the 20 Mar. There will be sessions...
  • 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...
  • SQL Server Security issues reduced

    In Dan's Blog he talks about the Sans Top 20 Security Vulnerabilities . The main point being Microsoft SQL Server not making the top 20 but other database systems did. I looked back at previous years and we had our own section of vulnerabilities. I am...
  • 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 Week 11 Dec 2006

    TechNet Webcast: Introduction to SQL Server 2005 Report Builder (Level 200) Monday, December 11, 2006 - 1:00 PM - 2:30 PM Pacific Time John Weston, TechNet Presenter, Microsoft Corporation http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032319566&Culture...