March 2010 - Posts

SQLBits VI hotel discount extended
30 March 10 09:09 PM | MartinBell | with no comments

Park Plaza have extended the deadline date for the SQLBits discount to 7th April.

If you wish to take advantage of the discount make sure you book early.

For more details see

Scottish Area SQL Server User Group Meeting, Edinburgh - Thursday 25th March
18 March 10 08:58 PM | MartinBell | with no comments

SQL Server 2008 Reporting Services Scalability and Performance – Rob Carrol 

Microsoft SQL Server 2008 Reporting Services provides a complete, server-based platform designed to support a wide variety of reporting needs enabling organizations to deliver relevant information where needed across the entire enterprise. This session covers the new scalability features of SQL Server Reporting Services 2008, such as on-demand processing and improved memory management. The session will demonstrates how to build a high performance, scalable reporting platform and explains performance tuning techniques to ensure that report performance remains optimal as your platform grows.

Rob's blog:


18:30 - 19:00 - Introduction, Networking and Food

19:00 - 20:00 – SQL Server 2008 Reporting Services Scalability and Performance – Rob Carrol

20:00 - 20:10 - Break

20:10 - 20:50 – TBD

20:50 - 21:00 - Close

Register at


SQLBits 6 Registration Now Open
17 March 10 12:01 PM | MartinBell | with no comments

We are pleased to announce that registration for SQLBits VI is now open. It will be held on 16th April 2010 at the Church House Conference Centre, Westminister, London.

I think we have a great line up of speakers and sessions. You can view the agenda here

Even though it is on a week day we have managed to keep this free. It will follow the SQL Server Tech Day, so if you want to stay over check out the discount code we have for the Park Plaza.

Anyone registering before the end of March will be entered into a prize draw for a free entry to PASS Europe.

Filed under:
VBUG Manchester March 3rd 2010 - Slides and examples
15 March 10 10:23 PM | MartinBell | with no comments

At the VBUG meeting in Manchester on 3rd March, I was scheduled to talk about Table Valued Parameters, but when I got there the guys wanted something more general so I talked about some of the new features of SQL 2008. The presentation is here and the TVP demo project is here.

My blog postings on TVPs are listed at Information about the new date and time data types Information on Row Constructors which are now called table valued constructors

Visual Studio Professional 2010 upgrades
13 March 10 12:33 PM | MartinBell | with no comments

Currently I seem to be spending most of my time in Visual Studio, in fact I used VS 2008 for my demos at the Manchester VBUG meeting last week and didn’t touch SQL Server Management Studio at all! During my day job I’m using VS 2010 RC.

I’m fortunate to have my own MSDN subscription, but I know that some people purchase it separately so any chance of getting it cheaper could be useful!

Microsoft Visual Studio 2010 Professional will launch on April 12 and you can pre-order it as an upgrade for £484.99, this includes a subscription to MSDN essentials. If you want to see what you get for this check out although looking at the MSDN essentials edition doesn’t seem to include the TFS features so if you are needing TFS, I would check first.

To qualify for the upgrade you have to be using a previous version of Visual Studio or any other development tool. See Soma’s announcement about the release on his
blog and to order go to

Filed under:
Learning SQL Server
12 March 10 07:21 AM | MartinBell | 2 comment(s)

At the last Edinburgh User group meeting we had a great talk from Alistair about Learning SQL Server. Everyone is different when it comes to learning. In the distant past there was very few learning opportunities other than classroom based courses. Even the number of books on technical subjects were limited.

Nowadays the number of books available are is considerable, some are very focussed, others more general and there can be so many to choose from it is hard to know where to start!

If you prefer to read information more piecemeal then there are plenty of blog posts and white papers available online including sites like SQLServerCentral and SQL-Server-Performance as well as Microsofts own Technet and MSDN where you can also find virtual labs and some videos and here for a more hands on learning experience.

If you are looking for SQL Server certification then Chris Testa-O’Neill’s live meeting should help you decide what to go for, that can be found here on Microsoft has just released the eCourseCollection 6233 - Implementing and Maintaining Business Intelligence in Microsoft® SQL Server® 2008: Integration Services, Reporting Services and Analysis Services, which has been written by fellow MVP, Chris Testa-O’Neill.

This 24-hour collection provides you with the skills and knowledge required to implement and maintain business intelligence solutions on SQL Server 2008.

This collection also helps students to prepare for Exam 70-448 and you can buy each part individually see:

Any article on learning could only touch on what resources are available, and this is no exception, but hopefully this has given you something to think about.

Filed under:
Slides from the Scottish Area User Group Meeting 25th February
04 March 10 09:33 PM | MartinBell | with no comments

I really enjoyed last weeks user group meeting, the interaction from everyone helped make it an excellent evening.

Iain has provided these links for the two products he mentioned in the talk:

The product information for Lightspeed is here and the videos for using the features are here, it can be download from here

For Performance Analysis the data sheet is here and information regarding installing it can be found here with the download here.

Iain’s slides are here.

DDD Scotland Registration is now open!
01 March 10 12:30 PM | MartinBell | with no comments

Registration for DDD Scotland 2010 opened today (1st March) at 12:30.

You can view the agenda as voted for by the community here!.

Filed under: ,

This Blog

SQL Blogs