I just found this on a hosted SQL server I use. The query was trying to enable service broker and was just waiting for an exclusive database lock which it wasn’t getting.

So it was sitting there for 58 days.



Do you have a query thats been running for longer ?

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

The demos, presentations and all code from my Advanced Reporting Services precon are now available here



Posted by simonsabin | 1 comment(s)

This is what I like to see. I hope that means no problems with internet today.


Posted by simonsabin | with no comments

if you are looking to work with Analysis Services then you need to learn MDX and there is no better person to learn it from than Chris Webb

Chris is a Microsoft MVP and a leading expert on MDX. He is the co-author of two books, "MDX Solutions" (second edition) and "Expert Cube Development with SQL Server Analysis Services 2008", and blogs about Microsoft BI topics at http://cwebbbi.wordpress.com/

Chris is doing an introduction to MDX course Wednesday, 26 October 2011 to Friday, 28 October 2011

To register for the Introduction to MDX course or get more details click here


Day 1

  • What is MDX and why should I use it?
  • Understanding the structure of a cube: recognizing cubes, measure groups, dimensions and hierarchies
  • Understanding the concepts of members, tuples and sets
  • Writing simple queries: using SQL Management studio to write SELECT statements
  • Creating simple calculated members: when to use query, session and cube-scoped calculations, using simple MDX expressions and functions

Day 2

  • Standard Calculations: looking at the best ways to implement common calculations, such as time series, market shares and rankings
  • Using set functions: using common MDX functions such as Crossjoin, Filter, Order, Generate to create more complex queries
  • Advanced concepts: autoexists, solve order and subselects

Day 3

  • MDX Script Assignments: making scoped assignments, understanding how assignments affect aggregation, using assignments with calculated members
  • MDX for Reporting Services
  • Performance Tuning and Troubleshooting: using Profiler, building aggregations, functions to avoid

Cost £749 + VAT

File:ForensicsScene.jpgI was reading the news today about the Kercher murder trial and the acquittal of Amanda Knox. The reason for the acquittal was the DNA evidence that was collected, and was the foundation of the prosecution in the original trial, could not be relied upon. Over years the forensic community have defined how data should be collected and processed. In this case it doesn’t matter if the DNA evidence was correct or not, the way means by which it was collected and processed could not be relied upon and thus the information is discarded.

How does this relate to BI? 


You are producing data which is going to be the foundation of decisions in your business. If your data can not be relied upon then the business wont trust that data and so the data becomes useless. I’ve seen far too many BI systems where there is no trust of the data. This results in the data being questioned at the slightest hiccup of the data. Rather than looking at what caused the hiccup in the business, the business turn back on the data and say the data is wrong. This means all the time that has been spent building the BI system has been for nothing.

What does this mean for your projects?

Some of the aspects of BI projects that I feel undermine any trust in data are,

1. Not delivering data on time

If data is not delivered on time then questions are raised as to what is wrong with the system. If you can’t deliver data on time then the key thing to do is to inform the business of the situation. Its always better to be upfront about these problems than try and hide the fact. Whats more the problems might be due to a source system, if thats the case then your BI system shouldn’t take the hit for a problem in a source system. Why not have a dashboard informing the users of the status of your BI system and its processing.

2. Changing results

Once a result is delivered to the business it shouldn’t change. Ok its a little more complex than that but in principle you shouldn’t changed something thats already been calculated. If results have to change then you and your users need to be aware of what and why. Do you have a latency problem in collecting information and so it takes 7 days to get to a final figure. If so your daily figures may change for 7 days, but after that they shouldn’t. You should have exception reporting so that if you get late facts after the 7 days you can manage the system by informing the users that a problem with another system and not the BI system, will mean the figures will change.

3. Not informing the business of a problem

If someone makes a decision based on the information in your BI system and 2 days later they are told the system hasn’t been working properly for 2 days they aren’t going to be happy. Its going to make them think twice about using your system as the foundation of their decision in the future. If you had informed them at the time then they would likely understand and whilst the system has had a problem it won’t undermine the trust in the system.

File:Lego tower.jpg


4. Providing two different values at the same time

Many BI systems have evolved over time, usually in a Lego fashion. A bit stuck on hear, a bit stuck on there. This almost always leads to information being consumed by the business from systems with different latencies and potentially different calculations. This is the worst case as the business won’t know which figure to look at and so won’t trust any of them. The single version of the truth is a core concept that I always try to adhere to. If you have to have multiple versions then the end users have to be aware of what the differences are so they can trust the data and your systems.


Information is King, if you have the information then you can do anything you want. However if its wrong then thats the worst situation to be in.

Make sure you do what you need to to make sure that your business trusts your data and doesn’t have reasons not to trust your data.

Posted by simonsabin | 3 comment(s)
Filed under: ,

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

On Sunday they were given top spot in the tech 100 list in the Sunday Times http://www.fasttrack.co.uk/fasttrack/leagues/dbDetails.asp?siteID=3&compID=3164&yr=2011

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 http://sqlblogcasts.com/blogs/simons/contact.aspx


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 (http://sqlblogcasts.com/blogs/simons/archive/2011/09/09/adding-slicers-to-reporting-services-downloads.aspx).

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 http://sqlblogcasts.com/files/folders/reporting_services_presentations_and_demos/entry15872.aspx and the Demo and code here http://sqlblogcasts.com/files/folders/reporting_services_presentations_and_demos/entry15871.aspx

For screen shots of what the slicers looks like go to http://sqlblogcasts.com/blogs/simons/archive/2011/09/07/advanced-reporting-services-slicers-slides-and-demos-from-24hrs-of-pass-session.aspx

More Posts « Previous page - Next page »