Melville Thomson's Blog

Data, SQL and Windows Technologies

Melville Thomson's Blog

  • 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...
  • 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 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...
  • 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....
  • 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...
  • 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...
  • Introduction to SQL Server 2005 Analysis Services, Event 11 July

    Here is another Event for you, this time; ' Introduction to SQL Server 2005 Analysis Services' . this Event is at Microsoft in Reading on the 11th of July, starting at 18:30 till 21:00 In this session I want to look at some of the key areas of interest...
  • Chris Webb's BI Blog

    I found this Blog recently. It belongs to Chris Webb another of our new SQL Server MVPs.. Chris has mentioned in his blog about Reporting Services and server aggregates and raises an interesting issue ‘adding an explicit switch that allows treating...
  • Announcing the new independant BizTalk User Group - 19 Sept 18:00 London

    I would love to share this with you there is a new independent BizTalk user group starting in the UK. This is independent from Microsoft although we are supporting the development by hosting it at our London location. The main user focus is architects...
  • '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...
  • 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...
  • SharePoint 2007 and BI

    This has been a busy week! I attended a TechNet event in Reading last night 20-Sept-06 On SharePoint the presenter was Nick Swan an MVP who also looks after the SharePoint User Group UK . Eileen asked me to make sure everything was ok with Nick as this...
  • SQL Server 2005 Express Editions and Downloads

    I had a question from Martin at the roadshow in Birmingham. He had been given a copy of visual studio at an Microsoft Developer event. Now being a SQL DBA Martin was interested in evaluating SQL Express edition that came with it. Everything installed...
  • Resources - 'An introduction to SQL Server 2005 Reporting Services' - Reading Event - 06 Sept

    These are some resources I found to be very useful for you after the Reading event There are two webcasts then a lot of links to various information. Do look at Brian Welcker's Weblog there is lots of useful information there. TechNet Webcast: Introduction...
  • An introduction to SQL Server 2005 Reporting Services - Reading Event - 06 Sept

    An introduction to SQL Server 2005 Reporting Services - Reading Event - 06 Sept 06 September 2006 18:30 - 06 September 2006 21:00 GMT, London Welcome Time: 18:00 Language: English Microsoft Ltd Chicago 1&2 Building 3 Microsoft Campus...
  • An Evening of Business Intelligence - Chris Webb and Friends

    Chris Webb has arranged in conjunction with Tony from UK SQL User Group . Another evening of BI fun. David Parker (MVP) will be speaking about using Visio to visualise your data. Sanjay Nayyar (IMGroup) will be talking about using Microsoft BI and Reporting...
  • First Event focused on User Experience (UX) and Expression Tools.

    This looks like a great event, John asked me to mention it to you. I think some of you may be interested. I’d really appreciate if you could give mention to the Designer event we’re running with Computer Arts magazine on 10th May in London at the Linbury...
  • Should I move to SQL 2005? (Future Matters)

    I just want to say WOW. Eileen and I went straight from the Birmingham roadshow to Manchester. We presented sessions for Unisys at Their Future Matters Conference today the 3rd of May. That is the reason for the WOW! The conference was at the Manchester...
  • SQL log shipping and migration

    I have been asked for more information on migrating log shipping from SQL 2000 to SQL 2005. There are several white papers covering this in some detail. There is no direct upgrade as the Database Maintenance Plan Wizard is not used in SQL server 2005...
  • BizTalk user group UK (BTUGUK)

    At the meeting last month there was a draw for completeing the session evaluations, Mark Russell was the winner of some BizTalk style swag. I just wanted to highlight some of the points Richard has raised. The next meeting will be in January more details...
  • Tony Rogerson MVP SQL Server

    Once again Tony Rogerson has had his MVP status reawarded that is the nine times in a row. Tony runs the SQL user group here in the UK. I have never met anyone who puts so much time into the community and still manages to run a business. Congratulations...
  • SQL Server 2005: A Technical Overview. Event 11 May

    Several people said they would like an overview session. after the TechNet evening on February 28, where I presented Upgrading to SQL Server 2005. So by popular demand I am pleased to announce a new event on the 11 May 2006 in Reading starting at 18...
  • Really good site on SQL Server Replication

    I have been asked several times for resources to support Replication with SQL Server 2005. I have just found this post by Tony . He found this site www.replicationanswers.com by Paul Ibison. So I thought I would share it with you all. Paul is also an...
  • Oracle on Windows a partnership?

    An interesting thing happened to me on the way to the office today. I turned of at the beginning of Thames Valley Park into the land of Oracle. I usually drive straight past to the last roundabout so it was quite strange. I was attending an event for...