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

    Richard has asked me about resources for certification on Microsoft SQL Server2005. The first place I normally start is on the Microsoft MCP site this gives you resources about all the certifications. Why you should get certification and links to what...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • 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...
  • SP1 for SQL Server 2005 available now and Express Edition

    I’m really impressed that the SP1 for SQL 2005 is out so quick after the release of the CTP. The SQL Server Express Blog has a lot of information on the SP1 downloads. Also they have links to follow up information to help you get the most out of the product...