SQL Server 2005 SP2: Released, and Vista-ready

SQL Server 2005 Service Pack 2 was released yesterday, and I’ve just downloaded and installed the Express Edition with Advanced Services SP2 onto my Vista PC.  Smooth sailing all the way, and no compatibility warnings.  Hooray! Here’s a link to SQL Server 2005 SP2 on the TechNet site, and you can review this document on…

4

SQL Server Management Studio Tip: Show Execution Plan

If you’re looking to better understand what’s happening under the hood when you execute a query against SQL Server 2005, here’s a really cool feature of SQL Server Management Studio (and SQL Server Management Studio Express) that I only just discovered: the ability to inspect the execution plan of a query. Here’s how: Click this button…

3

Upcoming Dublin Event: 'A Day of Connected Systems'

What do the Windows Communication Framework (WCF), BizTalk 2006 and SQL Server Service Broker have in common?  They’re three strategic Microsoft technologies that offer developers opportunities to build applications that tightly link together users in the organisation, customers, and business partners. As a developer or architect, you may see the value of these tools… but…

0

Develop, Design, Deploy

Over the holidays, I built a data-driven website for a family member.  It gave me a chance to explore some new Microsoft web technologies and tools hands-on.  Here’s how I developed, designed, and deployed the site: Develop: using ASP.NET AJAX and Visual Studio Web Developer Express Edition I wanted to use the features of ASP.NET…

4

Back in action

There wasn’t a whole of blogging (or snowing) going on while I was visiting family and friends back in Canada last week.  The sunsets, however, were gorgeous! I’m back in action today, knee-deep in the e-mail.  Events: I’ve had a few people mail me asking about upcoming MSDN and community events in Ireland.  Here are…

1

Visual Studio Team Edition for Database Professionals - Released

A very impressive addition to the Visual Studio Team System has been released for database professionals – and I’ve been neglecting to write about it! Team Edition for Database Professionals is designed to manage database change, improve software quality through database testing, and bring thebenefits of Visual Studio Team System and life-cycle development to the…

0

SQL Server 2005 - scripting your database for moving to your hoster - Hosting Toolkit

I’ve written before about how to ease the challenge of scripting your data to move it from a local SQL Server 2005 .mdf database to a hoster. Things got a little easier today with the SQL Server Hosting Toolkit, which, in its first incarnation, is a command line tool that generates a T-SQL script designed…

0

Students ask the most interesting things

Last Wednesday I gave a presentation to SkyNet, the University of Limerick Computer Society.  About 30 undergrad and graduate students turned up for Atlas, Vista and pizza, in that order. What I showed them was basically a riff on my ASP.NET “Atlas” presentation from ApacheCon Europe, but I also spent some time talking about the…

2

Top Tips for free Microsoft support and training resources

Clare asked Dave and me to reveal some hidden gems that are available from Microsoft for technical support and learning.  This was our list of the shiniest gems that we find devs and IT pros don’t always know about.  I also posted the Best of the Rest as an article.   1. MSDN Forums –…

5