April 2012

You are currently browsing the monthly archive for April 2012.

If you have ever had the chance to see a presentation by Rafal Lukawiecki, I’m sure you’ll agree that he surely knows how to deliver his stuff, and on top of that he knows what he’s talking about.

In other words: Rafal is once more in our small country!  Next Thursday he’ll be talking about the present and future of the Microsoft Business Intelligence stack.

Location: Utopolis Mechelen, Spuibeekstraat 5, Mechelen, Belgium.

Date/Time: Thursday April 26th, 0900 – 1700.

Check out the Belgian SQLUG site for more details.

Ow, and it’s a full-day free event, so what are you waiting for?  If you’re into BI, you’d better have a real good excuse to miss this opportunity!  Register now!

See you there!



Tags: ,

You may or may not already have heard about it, but the next version of our favorite database, SQL Server 2012, ships with a client tool called SQL Server Data Tools (SSDT).  Just like the BIDS was actually Visual Studio 2008 (or 2005 if you’re long enough in the business) with BI-related project templates, SSDT is Visual Studio 2010.  But that’s not all: it contains additional functionality!  Do you remember the database projects you could create using the “data dude”, or officially known as Visual Studio 2008 with the GDR2 add-on?  Well, this is version-next of the data dude.

Let’s find out how such a database project can be created!

Getting Started With SSDT

Obviously the first step is installing SQL Server 2012 and making sure to select SQL Server Data Tools in the Feature Selection page:

SQL Server 2012 Feature Selection with the SQL Server Data Tools checked

With that up and running, launch the SQL Server Data Tools from the Microsoft SQL Server 2012 folder in the Start menu and go to File > New Project.

New Project - SQL Server Data Tools

One of the template categories is called SQL Server.  Under that you’ll find a template called SQL Server Data Tools – Database Projects (Web Install).

Erm, hang on, what do you mean, “web install”?  Does that mean it’s not installed yet?  The description on the right also gives some clue to what’s going on: “provides instructions for installing SQL Server Data Tools – Database Projects from the web”.  Okay, let’s get on with it then!

Click the OK button to proceed to the installer.

Installing the SSDT Database Projects template

SQL Server Data Tools - Database Projects (Web Install)

I think the message in that window above is a bit misleading.  It says that “Database Projects” is required, but isn’t that what we’re going to install now?  Sounds like chicken and egg to me!  Let’s just ignore the message then and click the Install button.

Data Developer Center - Download SQL Server Data Tools

We’re now presented with a web page in Internet Explorer.  In this Data Developer Center, click the blue Download SQL Server Data Tools link.

Next, when presented with the following pop-up, click Allow:

Do you want to allow this website to open a program on your computer? Yes we do!

The next window is the Web Platform Installer 3.0 that wants to install the Microsoft SQL Server Data Tools.  Click the Install button to get to the next step.

Web Platform Installer 3.0 - 1 items to be installed

As usual with any installer from Microsoft, we need to accept the license terms so click the Accept button.

Web Platform Installation - Accept License Terms

Finally, the installation begins!

Web Platform Installation - Progress Bar

To keep us busy, we’re presented with another pop-up with a progress bar:


Woah!  Is this thing installing SQL Server 2012 Express LocalDB like it says in the message?  I didn’t ask for that!  MS people, as I already have a version 2012 DB engine running on my machine, please make this optional…

Just a little later we’re presented with this:

Web Platform Installation - Congratulations!

Clicking the Finish button gives us yet one more pop-up:

Web Platform Installer 3.0 - Spotlight

The Web Platform Installer presents us with a list of applications we can install, including Microsoft SQL Server Data Tools.  Oh my, I thought we just finished installing it?  Let’s not be silly and click the Exit button

To conclude, we need to restart Visual Studio 2010, or aka SSDT.

Really Getting Started With SSDT

With everything up and running smoothly this time, open SSDT once more and in File > New Project you’ll now find the SQL Server Database Project under the SQL Server collection:

New Project - SQL Server Database Project

If you also have Visual Studio 2010 installed in Premium or Ultimate edition, you should take care to open up the correct SQL Server template collection.  The reason for that is because the data dude projects are included in those versions of Visual Studio, as shown in the screenshot below:

The SQL Server templates in Visual Studio 2010

So the templates under Database > SQL Server are not what you’re looking for!

That’s it for now, I’ll demonstrate my favorite SSDT feature in an upcoming post!

Have fun!



SSDT Main page on Data Developer Center

SQL Server Data Tools Team Blog


Tags: , ,


Huh, the what?  I know INDEX and I know CLUSTERED INDEX.  Heck, I even know the filtered index, but COLUMNSTORE?  That’s new to me!

If that’s your reaction, or you simply want to find out how this new SQL Server 2012 feature has been used in one of the largest data warehouses in the country, you should be present next Monday for our upcoming SQLUG event.

Location: Microsoft Belgium, Corporate Village, Leonardo Da Vincilaan 3, 1935 Zaventem

Presenter: Ludo Bernaerts (ITN Senior Operational Engineer at Belgacom)

Date: 16/04/2012

Time: 1800 – 2100

Ow yeah, registration goes through here!

See you there!



Tags: ,

© 2008-2019 BI: Beer Intelligence? All Rights Reserved