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...
  • SQL Server 2005 Encryption

    Steve asked me about encryption in SQL Server 2005. I have found a few areas of information that are useful. In BOL there is an article about the Encryption Hierarchy this explains quite a lot about how it is organised. I quite like it because it has...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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 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...
  • 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...
  • 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 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...
  • Follow up to MSDE support on Vista

    Just to follow up on my post MSDE nearing End of Life - No MSDE Support on Vista and from Eric’s post. SQL Server Express WebLog has followed up with a lot more information to clarify some of the terms and what is or is not supported. MSDE will continue...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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 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...
  • 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...