Welcome to EMC Consulting Blogs

November 2004 - Posts

• SQL Server 2000 Gotcha : Creating views on views

  My colleague Karl Grainger has just alerted me to some unexpected behaviour regarding views in SQL Server 2000 Imagine I have 2 views defined as: CREATE VIEW v1 AS SELECT col1, col2 FROM MyTable CREATE VIEW v2 AS SELECT * FROM v1 If I issue the statement: Read More... Posted 30 November 2004 14:32 by jamie.thomson | 2 Comments

• SQL Server 2005 Webcast week

  Next week (beginning 6th December) Microsoft are running SQL Server 2005 Webcast Week during which they will be running webcasts on many subject areas. The interesting looking ones (in my humble opinion) are: Integration Services 2005 Analysis Services Read More... Posted 30 November 2004 09:04 by jamie.thomson | 0 Comments Filed under: SQL Server 2005

• Article: SSIS Package Configurations

  I've been looking into SQL Server Integration Services (SSIS) quite a lot lately and have been writing a couple of articles about what I've been doing. My latest one called Easy Package Configuration is available on http://www.sqlis.com . The article Read More... Posted 29 November 2004 22:38 by jamie.thomson | 7 Comments Filed under: SQL Server Integration Services, SSIS, configurations

• Screensavers: A new approach to fighting spam

  In the ongoing fight against spam Lycos have released a screensaver that overloads the spammers. Apparently you can get the screensaver here although at the time of writing your email gets returned in error. I expect it'll be fixed by the time you read Read More... Posted 29 November 2004 14:04 by jamie.thomson | 2 Comments Filed under: Inane Waffle

• Restart SQL Server without restarting

  Performance testing your T-SQL can be a drag. To do proper controlling of testing variables you essentially need to make sure that you're not running your statements against a server that has the data in cache. Previously the only way I knew of ensuring Read More... Posted 29 November 2004 12:49 by jamie.thomson | 4 Comments Filed under: SQL Server

• FOAF Viewer

  A better way of reading a FOAF file is the FOAF Explorer which presents the information in a FOAF file in a nice easy to read way. Click on the icon here to use it. Here it is at work using my FOAF file: http://xml.mfd-consult.dk/foaf/explorer/?foaf=http%3A%2F%2Fwww.jamie-thomson.net%2Ffoaf.rdf Read More... Posted 13 November 2004 13:50 by jamie.thomson | 0 Comments Filed under: Semantic Web, foaf

• The semantic web and FOAF

  Have you heard of the semantic web? Its the brainchild of Sir Tim Berners-Lee . He invented the world wide web and now he's trying to give us the world wide web v2.0 - and so far its been 15 years in the making. I read an interview with Berners-Lee in Read More... Posted 13 November 2004 13:18 by jamie.thomson | 0 Comments Filed under: Semantic Web, foaf

• Blog from Analysis Services dev leader

  Mosha Pasumansky has a new blog at http://sqljunkies.com/WebLog/mosha/Rss.aspx which looks like it might have some interesting stuff on there for AS 2005. Read More... Posted 11 November 2004 12:21 by jamie.thomson | (Comments Off) Filed under: SQL Server 2005

• Firefox tarnishes MSIE's crown

  Nothing to do with Clint's cold war plane nicking caper ! Internet Explorer's share of the browser market has taken a small knock thanks to an open source browser from The Mozilla Foundation . Read more at http://news.bbc.co.uk/1/hi/technology/3993959.stm Read More... Posted 09 November 2004 12:48 by jamie.thomson | 1 Comments Filed under: Inane Waffle

• SQL Server 2005 BI blog

  A blog from Reed Jacobsen, trainer on SQL Server 2005 BI technologies http://sqljunkies.com/WebLog/hitachiconsulting/ Read More... Posted 07 November 2004 13:17 by jamie.thomson | (Comments Off) Filed under: SQL Server 2005

• MEND

  For non-Conchango people that haven't already seen this on Rory's blog post ... You can now store your phone details on a national database so that if it gets recovered after being lost or stolen it can be traced back to you. Must be worth a moment of Read More... Posted 07 November 2004 11:40 by jamie.thomson | 0 Comments Filed under: Inane Waffle

• Best of Stuff show 2004

  I've just got back from the Best Of Stuff Show 2004 . I was disappointed not to see much (in fact anything) in the way of smartphones and PDAs but there was still some pretty cool stuff there. Star of the show in my book was the Virtual Keyboard which Read More... Posted 06 November 2004 14:46 by jamie.thomson | 1 Comments Filed under: Inane Waffle

• re: Instant Messenger - is it really useful? – are you missing a trick?

  [In reply to Bob's blog post on IM ... (have to post this here cos the Submit button on Bob's blog wasn't working)...] True Bob...but there's still problems with IM. Imagine if I want to phone a friend about going down the pub but I can't because he's Read More... Posted 05 November 2004 16:57 by jamie.thomson | 1 Comments Filed under: Inane Waffle

• What's a blog and why bother?

  Ensconsed as I now am in the sub-geek world of blogging its sometimes hard to remember that there are lesser mortals out there that are as yet untouched by this tidal wave of information that is at our fingertips! Therefore, prior to me sending an email Read More... Posted 05 November 2004 16:39 by jamie.thomson | 0 Comments Filed under: Inane Waffle

• .Net tutorial for SQL Server developers!

  SQL Server 2005 is coming around soon and with the CLR integration bound up tight in it SQL Server developers out there are going to have to start getting their heads around .Net sooner rather than later. Speaking as a .Net novice I can highly recommend Read More... Posted 04 November 2004 22:34 by jamie.thomson | 3 Comments Filed under: SQL Server 2005

• Sharpreader

  If browsing through web pages to read any blogs that you're interested in seems a little tiresome (and let's face it, it is) then I recommend you check out Sharpreader if you haven't already! Its got lots of nice little touches but the main one being Read More... Posted 04 November 2004 22:27 by jamie.thomson | 7 Comments Filed under: Inane Waffle

• Sage snap up Intelligent Apps

  Intelligent Apps, an Analysis Services front-end vendor, have been bought by Sage, the accountancy software firm. Sage have been selling a rebranded version of Intelligent Apps called "Sage BI" for about a year now and have decided to go the whole hog Read More... Posted 04 November 2004 09:45 by jamie.thomson | 0 Comments Filed under: Inane Waffle

• Smartphone or Pocket PC Phone???

  Ever since my girlfriend got hold of a smartphone a few weeks ago I've been jealously looking around to decide which one I'm going to go for. She's gone for the C500 which looks pretty dandy to me! Doesn't have wi-fi though so maybe I'll wait till this Read More... Posted 03 November 2004 14:00 by jamie.thomson | 0 Comments Filed under: Inane Waffle

• Article on SQLIS.com

  SQL Server 2005 is coming and Conchango are heavily involved with Microsoft's SQL Server Beta program so expect plenty of posts here in the run up to release - hopefully next summer. My first article on SQL Server 2005 (more accurately Integration Services) Read More... Posted 03 November 2004 13:50 by jamie.thomson | 0 Comments Filed under: SQL Server Integration Services, SSIS

• Intro

  Welcome, Here be my first entry into the world of blogging courtesy of my lovely paymasters Conchango ! So...I've got a blog. Now the inevitable question...what on earth to put in it? Working as I do in Conchango's BI team I guess it'll be Read More... Posted 03 November 2004 13:38 by jamie.thomson | 4 Comments Filed under: Inane Waffle, Introduction