Melville Thomson's Blog

Data, SQL and Windows Technologies

Browse by Tags

Related Posts
  • Blog Post: 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 and speak to some more of you. I had a few questions...
  • Blog Post: SQL Server Webcasts for December

    Here is a list of SQL Server Webcasts for December. For links to previous webcasts and labs see my previous post . Introduction to SQL Server 2005 report Builder Join us as we illustrate the architecture behind Report Builder, demonstrate its capabilities, and explain how it helps you to build...
  • Blog Post: 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:30 till 21:00 SQL Server 2005: A Technical Overview...
  • Blog Post: 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 you would use when working with Reporting Services...
  • Blog Post: SQL Server Manageability Team Blog

    I am going to add the SQL Server Manageability Team Blog to my links there is a great post about running reports inside Management Studio . This ability was added with SP2. Both Simon and Dan have mentioned this earlier.
  • Blog Post: '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 Services . A lot of the white papers are located...
  • Blog Post: 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 wondering if that was because we were more open?...
  • Blog Post: Looking for a SQL Server/Business Intelligence IT Pro Evangelist

    Eileen is looking to extend her team and is looking for two new IT Pro Evangelists to join us in the UK. One of these will be a SQL Server/Business Intelligence person. The details for the job are here . What we are looking for is someone who is technical and can enthuse others about the technology....
  • Blog Post: SQL Server Webcasts For Week 11 Dec 2006

    TechNet Webcast: Introduction to SQL Server 2005 Report Builder (Level 200) Monday, December 11, 2006 - 1:00 PM - 2:30 PM Pacific Time John Weston, TechNet Presenter, Microsoft Corporation http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032319566&Culture=en-US TechNet Webcast: Introduction...
  • Blog Post: 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 the Independent Oracle Users Group (IOUG)...
  • Blog Post: 02 June 2006: SQL Server 2005- One-day Technical Overview.

    Keith Burns and I presented a one day technical overview looking at upgrading to SQL 2005 to an audience of 200+ at Cavendish Conference centre in London. Jim Gray presented the keynote speech and then left to go to another meeting and have lunch with some of the Microsoft Valued Professionals (MVP)...
  • Blog Post: 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 your business’s reporting capability: An introduction...
  • Blog Post: Accessing Reports using URL Access in SQL Server 2005

    I was asked today for some resources and information on Report Services. First there is a way to access reports using URL Access; there is a white paper here. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/RSPROG/htm/rsp_prog_urlaccess_374y.asp With URL access we can pass parameters...
  • Blog Post: Microsoft and Hyperion Collaborate on Business Intelligence Solutions

    Another great announcement look here for more details. I think this is fantastic news. On Tuesday 25th April we announced at the Hyperion Users Conference the following four areas of collaboration with Hyperion. • SSRS reporting from Essbase • HYSL System 9 Workspace including SSRS report data • HYSL...
  • Blog Post: 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.
  • Blog Post: Scottish SQL User Group meeting next week (6th Dec) - Edinburgh

    Hi all. Earlier this year we tried to get a Scottish User Group for SQL Server. Martin Bell has agreed to try and kick start it of again. Tony Rogerson is supporting Martin. Please come along and show your support for this. There will be a prize for the best subject idea for future sessions. If anyone...
  • Blog Post: 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 of each and highlights the differences it also compares...
  • Blog Post: Helpful SQL Server 2000 Resources

    Here is a brilliant post from deepakc he works as a Premier Field Engineer based in Bangalore. He has provided a list of SQL Server Support Resources categorised by feature. I do recommend that if you are looking to fix a problem with SQL try here first.
  • Blog Post: SQL Server 2005 April BOL released

    Just to give you a heads up the April books online has been released see link below http://www.microsoft.com/downloads/details.aspx?FamilyID=be6a2c5d-00df-4220-b133-29c1e0b6585f&DisplayLang=en Simon Posted a link on Sunday with this list of information it is very useful stuff.. Do head the...
  • Blog Post: Webcasts for week 11-15 September + On Demand Webcasts

    TechNet Webcast: Technical Benefits of SQL Server 2005 for Every Business (Level 200) Thursday, September 14, 2006 - 9:30 AM - 11:00 AM Pacific Time http://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032306505&Culture=en-US MSDN Webcast: Preparing for Exam 70-431 SQL Server 2005 Implementation...
  • Blog Post: 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 a diagram which is easy to understand. SQL Server...
  • Blog Post: 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 this if required. From the BOL there is a lot...
  • Blog Post: 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, so during an upgrade log shipping stops functioning...
  • Blog Post: 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.
  • Blog Post: SQL Server 2005 Compact Edition

    I would just like to highlight the SQL Server 2005 Compact Edition. The download page is here . This is the latest SQL Server Compact Edition add-ins, updates, tools and all the parts to enable you to build occasionally–connected mobile and desktop applications. To find out more about the product go...