You are currently browsing articles tagged SQLUG.


Regular readers of this blog know that I was one of the speakers at our Belgian SQL Server Days event last Thursday and Friday.

I have to admit that I underestimated the amount of work a little: working full time for a customer, preparing a one-hour session, preparing the SQL Server Days (luckily we’ve got a great team at the SQLUG for this part!) and still having some kind of personal life as well.

On day two we had the pleasure of welcoming 279 attendees all ready to attend sessions in our five different tracks.  And about 70 of those people were in my room!!  I had practically no stress before or during the start of my session, except for the moment when I had to get the microphone wire attached to my head somehow (luckily the technician was still around!)…  In fact, I was more stressed for my dry run session three days earlier.

Would I do it again?  Ow yeah, absolutely!  Even though it requires quite some time in preparation, the applause at the end of the session makes up for that! Smile

And now the moment you’ve all been waiting for: my slides and demos are available for download from my Skydrive.


For those seeking more information, here are some references related to my session content:

The official Data Quality Services blog (a lot of useful content on DQS!!)

SSIS DQS Matching Transformation

SSIS DQS Domain Value Import

Creating a Synchronous Transformation with the Script Component

Fuzzy Lookup Transformation

DQS Cleansing Transformation

Finding Similar Strings With Fuzzy Logic Functions Built Into MDS

Have fun, and see you next time!



Tags: , ,

SQL Server Days 2013For the first time ever am I not only participating in the organization of the SQL Server Days, I’ll be speaking as well!  Exciting times!

In my session, Cleaning up the mess with SSIS and DQS, you’ll learn a couple of tricks on dealing with dirty data.

Here’s the abstract for my session:

Are you loading data from exotic sources such as Excel and flat file?

Or are you dealing with manually-entered data through an application that allows, well, practically anything?  And do you sometimes run into trouble because the incoming data is not as expected?

Then you should really join us in this session in which I’ll demonstrate (yes, demos!) several different techniques that can be used to cleanse your dirty data!

Check out the agenda for more details!

We’ve got speakers from all over the world: South-Africa, Italy, Slovenia, UK, US and of course… Belgium!

Not registered yet?  Do it now!

Ow, and did you know we’ve introduced a special feature?  It’s called Bring a colleague for free.  If you register you can register an additional person for free, as long as there aren’t 50 of those free ones registered that is so be fast!

Bring your colleague

In the meantime: have fun and see you there!



Tags: , , , , ,

In case you’ve never heard of Community Day, despite that it’s the largest Belgian community event of the year, it’s an event in which several user groups join forces to provide a nice learning experience to the attendees.

The participating user groups this year are VISUG, AZUG, Belgian C++ user group, BIWUG, CLUG, Pro-Exchange, SCUG, SQLUG, ACCB.net/VBIB, WinTalks, DotNetHub, MADN, TechNine, IAMCT and PHP Benelux.

And guess what: I’m a speaker! My colleague Koen Verbeeck and myself have once more decided to share a presenting slot that day.  And we’ll be sharing some Data Visualization Tips & Tricks with you!

Koen will be talking about how to best visualize data: should I use a pie chart or would a bar chart provide a more interesting result, is it really a good idea to use red and green, that kind of stuff.

When he’s finished I’ll be taking over to show you some cool things you can do with SQL Server Reporting Services.  Yes, that’s lots of demos and practically no slides!  Cool?

The expected level is 300.  Don’t worry though, we know that the Community Day crowd consists mainly of developers so we’ll be taking that into account.

Ow, and I’m accepting topic suggestions! If you’ve been wondering about how to get something visualized but never got it to work, don’t hesitate to contact me by either posting a comment here or through email (found on my About page).  Provide a clear description of what you’d like to achieve, with a mock-up example if needed.  I’ll be selecting the most interesting proposals to fill some minutes with. Looking forward to some useful suggestions! Smile

More details about Community Day:

  • Utopolis Mechelen, Spuibeekstraat 5, 2800 Mechelen
  • June 20th 2013, 0830 – 1900
  • Twitter: @ComDayBe
  • Five tracks!

What are you waiting for? Register now before all seats are taken!

See you there and in the meantime: have fun!



Tags: , , , ,

As promised yesterday during my SQLUG presentation on Automating SSRS Deployments Using Built-in SQL Server Tools, you can download the slides and demos through this link.

Small disclaimer: you’re free to use the methods presented for your own projects, but I can’t allow that you use the material to deliver the presentation yourself.  Hope you understand.

Keep your eyes on this blog.  I’ll soon be describing a method which you can use to generate the batch files in order to fully automate the deploy process without using a custom .NET application!

Have fun!



Tags: , ,

SQLUG EventTo start the year nicely, we (my colleague Koen Verbeeck and myself, Valentino Vranken) have decided to join forces and deliver an evening presentation for the SQL Server User Group on the topic of automating SSRS deployments.

If you’re a report developer or if you’re a DBA who’s also responsible for the administration of report servers, I promise you that you’ll get something out of this session!

And I also promise that I won’t bore you too much with slides.  Prepare for a session packed with demos!

The Sessions

Here are some details on what we’ll be covering:

Automating SSRS deployment using built-in SQL Server tools

Have you always wanted to find out what the RS Utility is all about but never dared to ask? Then this session is what you’ve been waiting for!

Join Valentino to discover how rs.exe can be used to automate SSRS report deployment!

Speaker: Valentino Vranken (t)

Level: 300

Leveraging MSBUILD to automate SSRS deployments

Unlike SSIS and SSAS, Reporting Services doesn’t have an easy way to automate deployments. You can work your way around with VBScripts, but isn’t there an alternative?

Yes there is! Koen Verbeeck will show you in this session how the MSBUILD platform can be used to deploy your SSRS projects to the server.

Speaker: Koen Verbeeck (t)

Level: 300

When? Where? What?

When? Tuesday, 29th of January 2013

Where? Ordina Mechelen, Blarenberglaan 3B, 2800 Mechelen


18:00 Welcome and food

18:45 Automating SSRS deployment using built-in SQL Server tools

19:30 Break

19:45 Leveraging MSBUILD to automate SSRS deployments

20:45 Drink

What are you waiting for?  There are still some seats left, so register now!

In the meantime: have fun!



Tags: , , , ,

« Older entries

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