Trefor Davies is trying to get a world record for the most comments to a post, to raise money for charity. Good luck to him, you can add your comment here.

He calculated he needed 1 comment a second but when I tried to post I got



I hope he can sort it out.

Posted by simonsabin | 1 comment(s)

As the technical launch for SQL Server 2012 in the UK, SQLBits is the conference to attend to learn about SQL Server 2012 (Denali).

SQL Server 2012 gives amazing developments in both development, scalability and performance and high availability.

Faster Development

The additions to the TSQL language mean that you will be able to write queries easier and often perform better than previously possible. This in conjunction with the new development toolset mean your development will be faster.

10 fold performance improvement for large queries

Column store indexes will provide orders of magnitude of performance improvement for many queries especially in the BI reporting space.

Offload of backup and ETL from your core OLTP system

The always on features allowing read only mirrors and backups from the mirror mean you can offload your many processes from your hot OLTP system to your backup system.

Multiple mirrors and read only mirrors

SQL Server 2012 takes the mirroring delivered in SQL Server 2005 to another level. Now you can have multiple mirrors and they can be a mixture of synchronous and asynchronous. This means you can have local synchronous mirroring plus offsite asynchronous mirroring providing a standard failover process whether local or remote.


Not only will SQLBits have a keynote from Quentin Clark corporate vice president of Database Systems Group in SQL Server, but we have secured lots more of product team to attend.

There will have more SQL Server product team members at SQLBits X than has been at any previous event in the UK. This is your chance to speak to the people that developed the product. If you want to know about any of the new features this is your chance.

In addition to the people that wrote the product there will be more MVPs and MCMs than ever at SQLBits. These are the people that implement SQL Server and can give you the real world experience of using SQL Server and specifically SQL Server 2012 with many of then having already worked on production deployments of SQL Server 2012.

So don’t hesitate and get registering for SQLBits. The early bird finishes on Thursday so make sure you don’t miss out.

[SS Correction Early bird finished EOP on Thursday this week 5/1/2012]


About Quentin Clark:

Quentin Clark is the corporate vice president of the Database Systems Group in the Microsoft SQL Server organization, reporting to Ted Kummert, senior vice president of the Business Platforms Division. In his current role Clark is responsible for the engineering and business leadership of the database systems of SQL Server - serving Microsoft's OLTP and Data Warehousing capabilities. This responsibility includes the core relational database engine and data access, SQL Server Manageability, Parallel Data Warehouse, and advanced development work in databases, including the Gray Systems Lab in Madison.

A 17-year Microsoft veteran, Clark held a variety of roles mostly in systems technology prior to joining SQL Server, including the Internet Information Server team, Application Center and System Center. In 2002, he joined SQL Server to lead work to bring unstructured data capabilities into the data platform, a vision realized over the recent SQL Server product releases. In 2006 he took the position of general manager overseeing the core relational database engine, which led to his current role.

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

We’ve got a awesome lineup for training days at SQLBits X. 7 sessions from the SQL Server Product Team and 8 from world renowned experts.

You will notice we have 15, this is far more than we’ve had before but we are expecting large numbers and want to ensure that there is enough choice whilst limiting numbers on each seminar.

One session is already 75% full and I would expect it to fill up today or tomorrow, registration has only been open 2 weeks and we’ve already hit almost 500 registrations.

If you are planning on going then make sure you register soon.


An effective (though uncommon) approach to database design. with Hugo Kornelis

No More Guessing! Enlightened Performance Troubleshooting. with Adam Machanic

Storage For the DBA. with Denny Cherry

Putting tabular models into production. with Cathy Dumas

Take Good care of your Data: Introducing SQL 2012 DQS & MDS. with David Faibesh

Deep dive into Analysis Services. with Akshai Mirchandani

A 360-Degree View of SQL Server 2012 Business Intelligence with Stacia Misner

Leadership Skills for the Database Professional. with Kevin Kline

Deploying Highly Available SQL Server 2012 BI Environments. with Chris Testa-O'Neill , Gavin Payne

AlwaysOn: Maximizing High Availability with SQL Server 2012. with Allan Hirt

SSIS Performance Design Patterns. with Matt Masson

SQL Server Workshop for Developers. with Leonard Lobel

SSDT Master Class with Gert Drapers

Beyond Relational in SQL Server 2012 and SQL Azure with Michael Rhys

Programmability in SQL Server 2012 and SQL Azure with Tobias Ternstrom

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

Following on from my previous post ( We’ve changed our facebook setup so we now have a page which you can like.

Whats more we have the SQLBits X event setup so you can tell your friends you are coming.!/events/274105312639118/

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

Wow its been a busy few weeks in SQLBits land.

Session Voting

We’ve opened up voting for the sessions for SQLBits 10 Make sure you vote so we pick the sessions you want.

You’ve got to register on the SQLBits site (this is different from the username and password used on the registration site).

Even though we’ve opened up voting we still have submissions coming in, we have hit 257 sessions being submitted, and currently only space for 70 of them. Thats going to be tough.

Registration is open

Registration is open, and we’ve been overwhelmed with over 400 registrations and we haven’t announced the training day speakers. If I was you I’d get in and register for a training day so that when they are announced you can select yours as quick as possible. To ensure attendees get a quality experience we will be limiting numbers for each training day seminar. We are so excited about the lineup for the training days and they should be announced soon.

I can tell you know when you see the lineup it won#t matter which area of SQL Server you use you will want to attend at least one of the training day seminars. We will have more SQL Server product team members giving training days than ever before.

Tell your friends what sessions you like

We’ve updated the site so that you can “Like” sessions and also easily tweet about the session too.


When you watch a video make sure you tell your friends you like it.

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

Have you voted for the DBA in space competition? If not then make sure you do.

I’ve voted for Victoria, not just because she’s one of only two women finalists but also for the sheer balls of playing the trombone in her video.

Whats more Victoria is a true geek and a great DBA supporting a large SQL infrastructure in the UK.

You can see here video here

Having sent her name on previous space missions vote for her so this time she can go in person.

Posted by simonsabin | 1 comment(s)

Many people have reported that you can’t install the CTP4 of Juneau/SQLServer Data Tools (SSDT) even though you already have Visual Studio SP1 installed.

The problem is the install for SSDT requires Visual Studio SP1 and if it can’t find it, the setup tells you to install it. But you have it installed so what can you do?

Well the team have found one cause of this problem and have detailed in this blog post

For your ease I’ve copied the supported resolution here

“Since the release of SSDT CTP4, we have become aware of an installation issue dealing with Visual Studio 2010 Service Pack 1. We are working on a fix, but below is temporary workaround that can be employed to successfully install SSDT CTP4.

Symptom: When attempting to install SSDT, you will receive an error, stating the following, “You have to upgrade your Visual Studio 2010 to SP1 before installing SQL Server Data Tools,” even when you have previously taken steps to install SP1.

We have identified the primary scenario in which this error is wrongfully encountered:

1. Install VS2010 Professional or above from the install media

2. Install full VS2010 SP1

3. Install SQL Server 2012 setup, including Management Tools

4. Attempt to install SSDT CTP4

Installation of SSDT CTP4 in step 4 of this sequence should be successful, as VS2010 SP1 is applied when SQL Server Management Tools are installed. However, due to an issue in the application of SP1, you will indeed be blocked from installing CTP4.

The suggested workaround for this scenario is to reinstall VS2010 SP1 from Manually reapplying this pack will perform the necessary actions to repair this problem. After reinstalling SP1, you will then be able to successfully install SSDT CTP4.”

There is an unsupported solution but I will let you go to the blog post ( to get those details.

I am looking for 2 SQL Contractors to join my data team to help build our database platform.

The role is for a SQL generalist. The person will be doing TSQL, SSIS, SSRS and maybe some SSAS.

Experience of agile development processes would be great.

This is a great opportunity to work in a great team.

If you are interested them please let me know.

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

If you are looking for SQL Server training they there is no better place to start than a new company Technitrain Its been setup by a fellow MVP and SQLBits Organiser Chris Webb.

Why this company rather than any others?

Training based on real world experience by the best in the business.

The key to Technitrain’s model is not to cram the shelves high with courses and get some average Joe trainers to deliver them. Technitrain bring in world renowned experts in their fields to deliver courses written by the experts themselves based on their experience.

This means the course are focused on what you need to know, not just every feature in SQL Server.

If you’ve got questions then these trainers will definitely know the answer, and if they don’t they will definitely know someone that will and more often than not thats someone on the SQL Server team itself.

So if you are considering training now or in the future then make sure you keep an eye on Technitrain and the courses it is offering.

At the moment they have 4 courses available.

Christian Bolton - Advanced Internals and Troubleshooting Workshop for SQL Server

Jeremy Kashel - Introduction to Master Data Services

Andy Leonard  - From Zero to SSIS

Chris Webb - Introduction To MDX

Chris Webb - Real World Cube Design and Performance Tuning with Analysis Services

Web Edition will have all the features of web edition in 2008 R2 and the following features which are new for 2012

· Windows Server, Server Core Support

· Database Recovery Advisor

Posted by simonsabin | 1 comment(s)
Filed under: ,
More Posts « Previous page - Next page »