Wednesday, November 18, 2009

SQL Bits for the asking

I have been getting a little depressed at the way technology has been used to disseminate disinformation over the past few years. However, out of all bad things good things sometimes arise. So I am now very excited about the fact that technology is being addressed to remove disinformation and to return the power that information can provide to the user.

There are several examples of this that I have come across recently. The first is the offer from sky to customise adverts so that you only receive what you want instead of the general rubbish that comes through. Of course if they didn't put it there in the first place it would be even better but alas sometimes we learn by making mistakes.

Much more powerful filtering is however possible by using Business Intelligence techniques on data that we have floating around the organisation in an unwieldy way. If you are going to the SQL Bits conference, http://www.sqlbits.com/, then look out for two excellent sessions by a genius called Mark Whitehorn who works as a Solid Quality Mentor in his spare time (LOL). He is looking at two aspects of data mining that can lead to extracting meaningful information from noisy data. The first deals with Research data:-

Darwin’s Database
Business Intelligence (BI) is about turning data into information. Usually we apply BI to Business data (the clue is, after all, in the name) but it can extract information from any kind of data. Recently a team based Cambridge University has been applying BI to data that was available to Darwin. The results have rewritten our understanding of how Darwin developed the theory of evolution.


and the second with Social data:-

We normally collect and analyse transactional data (who bought what, from whom and when). Recently however, companies like eBay have also been collecting and analysing data about how their customers behave and interact. This social data is valuable – an eBay spokesperson recently said that the social data was more valuable than the transactional. This talk takes a look at social data, what it is, why it is valuable and asks the question “Who’s data is it anyway?”. The final question is “If eBay finds this data so valuable, should your company be taking an interest in it as well?”

Of course there are other geniuses there as well and lots of information in sessions covering various aspects of Database Administration, Development and Business Intelligence.

What is more, if you go to the conference site you will see that the Saturday sessions are absolutely free.

If you want more information about Solid Quality Mentors and what they can do for you, just go to http://www.solidq.com/ and take your pick from the fine offerings!

Saturday, March 28, 2009

Solid Quality Summit Vienna 2009

This is a not to be missed international SQL Server conference to be held in Vienna and provided by Solid Quality Mentors. In case you are not familiar with this organisation, I am sure you will be familiar with some of the renowned SQL Server and Business Intelligence experts that this organisation consists of:-

Dejan Sarka, Herbert Albert, Gianluca Hotz, Itzik Ben-Gan, Andreas Schindler, Helmut Knappe, Davide Mauri, Aaron Johal, Klaus Aschenbrenner

If you have read one of their books, attended one of their classes/ conference sessions or used them on a mentoring project before then you will already have an idea of the level of understanding they allow you to take away from the experience of being with them, even for a short period of time. If not then you most likely will at some point and are in for a treat when this happens.

The summit offers the advantages of a large conference in a pleasant family atmosphere. The environment will allow you to mingle with the experts who between them cover the languages and communication styles of 7 countries and the depth of knowledge and ability rewarded by the Microsoft MVP programme.

You can go directly to the Solid Quality Mentor site and as well as finding further information about the breadth of options available for you to bask in the glow of knowledge delivery made possible by such an ensemble of expert mentors.

If you are self employed, rather than a full time employee who may be able to dip into a strategic technical budget, you can choose a one day session or attend the whole conference. Mix your visit to this beautiful part of the world with pleasure of the more relaxing kind. One thing is for sure - if you want high quality information compressed into the minimum amount of time and be able to maximise the outcome of your financial investment, then you have choices here that can help you meet your needs.

Thursday, January 29, 2009

Become like an oracle by inspecting the entrails of SQL Server

Those nice people at Microsoft, with a little help from others, have just released the latest story on the internals of SQL Server. Go take a look, here is where you will find it, it makes for a great starting point to base your own communications on!