Melville Thomson's Blog

Data, SQL and Windows Technologies

Melville Thomson's Blog

  • 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...
  • 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 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 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...
  • 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...
  • 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.
  • 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...
  • '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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • Configuring SQL Server 2005 Logins

    One question I have been asked is about SQL Server 2005 Logins . Logins are the Server principles which give user’s access to SQL Server. We can create Logins using the SQL Server Management Studio (SSMS) graphically or use the CREATE LOGIN statement...
  • 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...