Melville Thomson's Blog

Data, SQL and Windows Technologies

August, 2006

  • 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...
  • 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...
  • 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 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...
  • 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...
  • 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...
  • 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...
  • Data webcasts for the week 7 – 11 August

    MSDN Webcast: Visual Studio 2005 Team Edition for Database Professionals (Part 3 of 4): Database Testing and Refactoring (Level 200) Tuesday, August 08, 2006 - 11:00 AM - 12:00 PM Pacific Time Gert Drapers, Development Manager, Microsoft Corporation...
  • SQL MVP Jamie Thomson SSIS Jibber Jabber

    Back in June I met up with another SQL MVP Jamie Thomson His blog can be found here SSIS Jibber Jabber . Jamie has lots of cool stuff to do with SQL Server Integration Services. At the moment he a series of articles how common tasks in DTS can now be...
  • Made in Express Contest community vote

    Some of you may be aware of the Made in Express Contest . This is a competition to write an Application using Visual Studio Express and SQL Server Express. It has been running for a while now and the finalists have been selected. I am really impressed...
  • Microsoft SQL Server for the Oracle Professional

    I have found a really useful white paper, Eileen and I receive a technical roll up mail sent to us on a regular basis part of Augusts was a new white paper that provides a comparison of SQL Server 2005 and Oracle . It gives the main features and points...
  • Migrating Access to Microsoft SQL Server - Resources

    I have been asked a question about what resources are available for migrating an Access Database to SQL Server. One of the key things to think about it what are you starting from version etc and what is it moving too. Also I thought about why they would...
  • Using parameters in Reporting Services

    I have been asked about parameters in reports and although I am presenting a TechNet session An introduction to SQL Server 2005 Reporting Services on the 6 Sept here in Reading I thought it would be useful to show where some of the resources are for parameters...
  • Beer and Diapers Myth..

    I just wanted to bring this to your attention mainly because I wanted to congratulate Chris on his new daughter born three weeks ago. I know a little of how he feels as I am a Grandad of five months to a lovely boy called Calum. When I presented the a...
  • Industry Insiders what would you like to share?

    I would like to share this with you, as well as having our own blogs we have access to an industry insiders blog. This inables you to share information that you are passionate about that you think my benifit the community. The blog gets about 96,000 hits...
  • Girly Geek Question Maintenance clean up task

    I attended the Girly Geek Dinner last night in London this was really well attended all our team were there. I really enjoyed it; I would like to thank all those I had a chance to speak with for making me welcome. Hopefully I will attend the next one...
  • Independant Oracle User Group survey and High Availability

    I came across a good post from Duncan Lamb he blogs about BI and other areas he mentions the '24/7 challenge: an IOUG 2006 survey on high availability trends'. I was quite interested as the chart he shows mentioned SQL Server. The report is quite interesting...
  • Improve the next version of Microsoft SQL Server

    Jamie has brought something to my attention which I would like to highlight here He has been trying to get some functionality added to the next version of SQL. This is where each of you can make a difference. Using Microsoft Connect you can report bugs...
  • Useful blog Canadian IT Pro Blogs

    Here is a great blog I met up with Damir at Techready3 in Seattle in July. The Canadian IT Pros have a shared blog. If you check out the links on the left there is some SQL content I like the post by a student who used a SQL Server 2005 to collect IDS...
  • Making contacting us simpler

    Well in the interests of the team being contactable. I have had one or two people who have been unable to send mail through my blog link at the top. So both Eileen , Steve and I are willing to share our contact numbers I will add it to the bottom of the...