Archive for the ‘Data Warehousing’ Category

Datawarehousing news and nice approach for partitioned data

Wednesday, September 30th, 2009
  • [Kickfire Offers Data Warehouse Appliance for the Masses]
    • Kickfire supports a MySQL based data-warehouse appliance targeting 500Gb -5Tb range, starting at $32K.
    • Will have to start monitoring this one. They appear to use similar concept to Netezza by utilizing SQL in hardware for speed, not exactly the same – but interesting to see the appliance trend.
  • [Building the Data Warehouse for bandwidth tracking]
    • This is a worthy read if you need to load and handle lots of naturally partitioned data
    • For those not willing to read, I’ll pose a question – how would you handle 683,460 tables :-)

Microsoft SQL Services is now Microsoft SQL Azure

Wednesday, July 8th, 2009

Microsoft SQL Services is now Microsoft SQL Azure – let the rebranding process begin :-) After not initially supporting TDS the name is now changing to the Azure brand.

Microsoft is updating the branding for SQL Services and SQL Data Services. Effective immediately, SQL Services will be called Microsoft SQL Azure, and SQL Data Services will be Microsoft SQL Azure Database.

There will be more news and updates related to our Software + Services strategy next week at Microsoft’s Worldwide Partner Conference in New Orleans. For those of you not attending in person, all the news and information can be found at: http://www.digitalwpc.com/ . Check back often starting next Monday, July 13, for daily updates.

More about TSQL Support in SQL Data Services can be found here. Another announcement of this can be found at “SQL Azure – Same great platform, just a better aligned name

Apparently its a ‘Cloudy’ week :-)

Gareth

Morning C# news – and more

Monday, June 29th, 2009

This one has just been reported, but if you havnt seen it – it is very exciting!

  • Mono on the iPhone…. To say this is exciting is an understatement. Unfortunately I’m a little afraid that Apple wont like it too much (read allow it in their TOS).

    “3.3.2 An Application may not itself install or launch other executable code by any means, including without limitation through the use of a plug-in architecture, calling other frameworks, other APIs or otherwise. No interpreted code may be downloaded and used in an Application except for code that is interpreted and run by Apple’s Published APIs and built-in interpreter(s)”

    .Mono is normally an interpreted language very similar to Java and the TOS explictly disallows running byte code on the machine.  So this could be VERY interesting, or it could be a nice concept and not never to hit the Apple store. Definitely watch this space!Otherwise we will end up with a compiler than generates Object C code :-(

  • Firefox 3.5 should be out tomorrow.
  • Another EDW appliance comes into the fold with Aster Data.
  • Simple problems highlighted with “SQL Server 2005 reporting in management studio“.

Gareth

Want to install SQL2008 on Windows 2008 RC2 (or Windows 7)?

Thursday, June 25th, 2009

Unfortunately its not as simple as you would think, SQL Server 2008 install requires the .NET 3.5 framework to be installed or will install it as part of the pre-req checking.   Changes in Windows 7 can prevent SQL Server 2008 from installing the .NET 3.5 framework pre-requisite.   Instead you may need to install the framework separately using the “Run this program in compatibility mode”.  Read here for more information.

UPDATE 2009-06-29: It seems there are similar issues with SQL2005 as well, have a look SQL Server version has a known compatibility issues with Windows 7 RC. This warning is genuine and applies to all SQL Server editions, including all Express editions.

Gareth