Melville Thomson's Blog

Data, SQL and Windows Technologies

March, 2006

  • Introductions

    Hello and welcome My name is Melville Thomson, I am an IT Pro Evangelist based in Reading UK This blog will reflect some of my thoughts and information about the technologies that I work with, mainly SQL Server and any other area I think may be...
  • Technet Event 28 Feb Migrating to SQL 2005

    I presented a TechNet evening on the 28 Feb - 'How do I migrate from my existing SQL server and what are my options?' As I only had two hours my aim was to highlight the procedure for upgrading or migrating. In particular the need for planning prior to...
  • 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...
  • Microsoft SQL Server 2005 SP1 (CTP)

    Microsoft SQL Server SP1 has been released on the 16 of March as a Community Technology Preview This service pack can be used to upgrade all editions of SQL Server 2005 to SP1 except Express Edition. You must use Microsoft SQL Server 2005 Express Edition...
  • SQL Server Query Optimization team Blog

    Here is a very useful resource. From SQL Server Query Optimization team lots of hints on query performance. I found the link to this on Magnum B.I. I thought I would share this with you. I get lots of questions relating to query performance.
  • Trouble shooting conectivity with SQL Server Express 2005

    I noticed a question on a list server where they were discusing the Express edition of SQL 2005. I was looking for resources at the time, there was a question about conecting to SQL Express. There is an excelent Blog SQL Protocols which has an article...
  • 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...