SQL Server 2008 R2 System View Map
Microsoft have a brilliant poster showing all the different system views which are available in SQL Server 2008 R2. The views are split into different sections...
Most recent articles
Demo: Norwich School Viewer
I’ve been playing around with the Silverlight PivotViewer, and used some education data from data.gov.uk to give a different perspective of education...
Silverlight PivotViewer: so fast to develop
On Friday, I created a working demo of the PivotViewer that demo’d in the Silverlight Firestarter keynote, which I blogged about a couple of days ago. Apart from...
Silverlight Firestarter: Silverlight 5
I’ve been watching the Silverlight Firestarter event tonight, via live stream. I’ve not seen all of it, and I’m still watching it now, but this is my...
SQL Server Query Analyser Intellisense: Keeping up to Date
The new IntelliSense in SQL Server 2008 is fantastic, and makes SQL development and maintenance much easier. However, sometimes it can be annoying, as changes and...
SQL Server: converting rows to lists with & without Coalesce
Today I had a data layout issue to solve for a Reporting Services report I was writing. The report had to aggregate data from another table, but lay out the values into...
SQL Server Tip: NULLIF
To my shame, I’d never come across this in-built SQL Server function unless today. The NULLIF function allows you to specify a NULL if the result was going to be...
NAnt task – bat file error codes
Just a quick something I found out a couple of moments ago. The <exec> task in NAnt is a life-saver for gluing together functionality that’s locked up in...
Slow loading site? Set your image sizes for an easy win!
This is a brilliant and simple tip Rob picked up today whilst working on increasing page load times. I’ll leave him to explain all the details whilst deftly...
Reporting Services Job Monitor
I’ve just posted the source code to an application I wrote 2½ years ago, whilst at the same time started using it again. The Reporting Services Job Monitor...
About Me
Hi, I'm Tom. I'm a Microsoft 365 Developer & Architect. I empower developers, architects, and organizations to achive more with Microsoft 365 by creating applications and services with technologies like Microsoft Teams, Microsoft Bot Framework, Microsoft Copilot, Microsoft Graph, Adaptive Cards, and Office Add-Ins.
I'm passionate about creating great software that people will find useful and I want to help you do the same. This is my blog, you can find more about me, speaking engagements, code sample and more on my main site.
My book on building applications for Microsoft Teams has everything you need to get started.
