SQL Server 2008

Was fortunate enough to get my hands on SQL Server 2008 Developer Edition yesterday. Installed this last night on my DELL Vostro 1510 alongside Visual Studio 2008 SP1.

First impressions are quite good. The installation was really smooth. Noticed that they now provide an option to configure Reporting Services alongside SharePoint. In SQL 2005 this took a little bit of extra configuration work to get it working correctly so this was the first welcome change I noticed.

Once up and running I was able to get a quick look around, immediately noticing the new inclusion of Spatial / Geography Datatypes and Hierarchical ID Datatypes – again all welcome changes. They’ve also updated the Query editor to include IntelliSense – Hooray!!!

Will hopefully post some more on the subject moving forward. Have got my hands on a new SQL Server 2008 book: Beginning SQL Server 2008 for Developers: from Novice to Professional, published by APRESS. I’m not a huge fan of their books, but is the only one I could readily get my hands on at the minute. Will take a read through anyway.

So much to learn and so little time. Am also studying away at IIS7, W2k8, C# 2008, LINQ, and ASP.NET 3.5 amongst a bunch of other stuff. As well as that I’ve been working away on a personal ASP.NET web app I’m hoping to productise by Christmas this year – which, by the way, I transferred my database into SQL 2008 last night also… using the flawless SQL Server Copy Wizard.

Microsoft DreamSpark – Free Development and Design Software for Students!

Today Microsoft announced DreamSpark – a new programme which allows students worldwide to download valuable professional developer and design software – COMPLETELY FREE OF CHARGE!!!

Outgoing Microsoft Chairman Bill Gates unveiled this ultimate software giveaway to millions of students which will enable them to learn industry standard development technologies and design technologies, increasing their potential to be prepared and to succeed in today’s IT industry.

“We want to do everything we can to equip a new generation of technology leaders with the knowledge and tools they need to harness the magic of software to improve lives, solve problems and catalyze economic growth,” Gates said. “Microsoft DreamSpark provides professional-level tools that we hope will inspire students to explore the power of software and encourage them to forge the next wave of software-driven breakthroughs.”

The DreamSpark student program can be accessed by signing up at the following web address: https://downloads.channel8.msdn.com/

Software available through the student program will include:

• Visual Studio 2005 Professional Edition
• Visual Studio 2008 Professional Edition
• XNA Game Studio 2.0
• 12-month free Academic membership in the XNA Creators Club
• Microsoft designer tools. This ultra-versatile suite of tools will enable students to vividly bring their creative visions to life in vibrant new Web site designs and more effective digital content, including animation, imagery and photography.
• Expression Studio, including
• Expression Web
• Expression Blend
• Expression Design
• Expression Media
• Microsoft platform resources. The foundation for development and design platforms, these products deliver a security-enhanced, reliable and manageable environment for students to more quickly turn ideas into reality.
• SQL Server 2005 Developer Edition
• Windows Server, Standard Edition

This really is a huge software giveaway! More cynical members of the IT community are speculating that this giveaway is largely in response to the rapidly growing adoption of free and open source development and design software available on the internet such as Linux, PHP, MySQL, Eclipse and The Gimp, as well as in direct competition to well-ingrained de facto industry standard commercial design software tools from Adobe…

The cynical would suggest that Microsoft is banking on their giveaway to likely have a large impact on personal preferences of graduates joining commercially licensed software development and media design companies in the coming years…