September 2011 - Posts

I’m looking for SQL people all rounders and BI specialists for the data team at the UKs top tech company

On Sunday they were given top spot in the tech 100 list in the Sunday Times

The reason is that tech is the heart of Wonga. Everything they do is tech orientated, highlighted by their in house decision engine that can gives loan decisions online in seconds.

If you are interested in being a part of this great company then drop me a line


We are also looking for application and front end (Drupal) developers. If you know of anyone that would be interested let me know.

Posted by simonsabin | 1 comment(s)
Filed under:

I’m going through my precon for PASS and there is some great stuff in here that addresses many of the failings of reporting services.


Ever wanted to have a report remember the last parameter values you specified for a report.

What about being able to indicate to a procedure the user selected ALL in the parameter and not pass 200 items to the procedure

How about providing friendly groupings for parameter values, like New products this month, or Your top 10 products last year.


Well I’m covering these topics and a whole load more. During my precon at PASS next month.

Posted by simonsabin | 1 comment(s)
Filed under:

The standard pricing for SQLBits ends at midnight on Friday. After that the price rises by £50/day. So make sure you get your registration in before the end of the week.

If you haven’t quite decided yet then maybe the great networking opportunities will convince you.

We know many people that extend their network of SQL people at SQLBits which provides invaluable when back at work trying to solve problems. Often as a SQL person you are the only person in the company, so having a network of people to call upon to help you out when you are stuck is essential. Not only can you connect to fellow professionals but you can also connect to people from the SQL Server product team, MVPs, MCMs and other SQL Server Experts.

This time around we are holding two networking events on the Thursday and Friday evening. The Thursday is going to be a relaxed event with some live music and the Friday is a James Bond themed casino (black tie is optional but prizes and drinks are available for those coming along as a 007, villain or bond girl). The James bond casino will also have three simulators an Aston Martin simulator, a power boat simulator and a laser shooting range.

As well as a supportive network, many people also find there next job through a contact they make at SQLBits so if you are considering moving on then have a think about coming along.

So make sure you get registered

Posted by simonsabin | with no comments
Filed under:

If you want the buttons from the Reporting Services Slicers demos I did last week then here they are.


You can get the presentation and code on putting slicers in reporting services here (

Posted by simonsabin | with no comments

I promised to have my presentation available online. Here is the presentation and and the projects. I will be provided details of how to deploy the assembly and do the drag and drop slicer functionality over the weekend.

You can download the presentation here and the Demo and code here

For screen shots of what the slicers looks like go to

Here are the files from my Advanced Reporting Services 24 Hours of PASS session on how to put slicers in reporting services.

Here is a screen shot of what is possible. One filters the data (Excel style) and the other greys unselected data out (Crescent style)



ps the files will be posted after the session on Thursday night. If you want to watch the session register here

There have been a few blog posts about SQL Azure version numbers and not to rely on the number to figure out if you are connected to azure or not. This is in part due to SQL Server going to one code base for Azure and on premise SQL.

Well SQL Azure is now version 11. Yep thats the version number of Denali but is it really Denali?

Some features will always be turned off in azure as they don’t make sense, like BACKUP and FileTable (in their current guise) but is anything else turned off.

Bob has done a great little piece on this

I’m hoping they can get Full Text in Azure soon.

Posted by simonsabin | with no comments
Filed under: , ,

Looking at our stats for SQLBits and SQLBlogcasts its looks like IE6 is almost dead. a 98% drop over the same period last year.


Whats more the share is less than 2% of total site visits.


Posted by simonsabin | 1 comment(s)