December 2011 - Posts

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.