February 2009 Blog Posts
PASS Europe 2009

PASS2009_021_120x240This year I’ll also speak at PASS Europe 2009. Here I’ll deliver a session dedicated to help developers to maximize performance with their SQL Queries, using a set-based approach, insteand of the simpler but usually less  scalable and efficient row-by-row solution:

Set Based solution: an approach for developers

Set based solution are what any developer needs to have performance and scalability on his database solution. Unfortunately thinking in set is something that may seems to be difficult at the beginning and as so many developers go for a seems-to-be-easier procedural approach. But this "easier" way leads to lower performance and poor scalability, and, at the end, to a way more complex code, difficult to maintain and bug-prone. In this session we'll see how to use a set-based approach to solve problems, even those problems that for most developers seems solvable only using a procedural approach and than we will compare the two different approach to show the difference in terms of scalability, performance and complexity. You'll be amazed of the performance and maintability boost you can give to your applications!

In general I must say that I’m impressed by the quality of this edition, the PASS European Conference is really growing better every year! Just look at the speakers list and you’ll have a good idea of what to expect. Then go and check the agenda: I’m pretty sure that you’ll be amazed as I did! All sessions are so interesting that I’d like to see all of them!

Last – but not leat – remember that if you register before March 6 you can take advantage of the Early Bird discount.

posted @ Wednesday, February 25, 2009 12:32 PM | Feedback (0)
SQLBits, Manchester 28th 2009

On the next 28th of March will take place one of the biggest SQL Server conference in Europe, the SQLBits conference, now arrived at the fourth edition! It’s completely free and it’s held on saturday so that you don’t have any working execuses for not participating :-)

SQLBits will be hosted by the Manchester Metropolitan University and with 28 Session will cover the whole SQL Server platform. You can take a look at the agenda here

while registration is done through this link

and if you plan to attend you’d better be fast since already 330 people already registered (!!!), and there aren’t many free seats left.

This time I’ll also be there and I’ll deliver a session related to Integration Services, focusing on how one can deeply monitor SSIS Packages perfomances over time:

Here I’ll show, among other things, how to use DTLoggedExec to have a really rocking monitoing solution of ETL processes, without gettin’ mad doing it, loosing yourself between RowCount transformations, Log Providers, Event Handling and so on.

See you there!

posted @ Wednesday, February 18, 2009 11:10 AM | Feedback (0)
Smart Business Intelligence Solutions with SQL Server 2008 now available

Finally the “Smart Business Intelligence Solutions with SQL Server 2008” is now available to worldwide stores!

  • ISBN: 0735625808
  • ISBN-13: 9780735625808
  • Format: Paperback, 624pp
  • Publisher: Microsoft Press
  • Pub. Date: February 2009

This books is dedicated to everyone who wants or needs to start to enter the big, complex, exciting world of Business Intelligence on the Microsoft platform. A BI solution is made of different tecnologies and specific architecture and design decision, and this book shows to the reader how to properly start a BI solution, avoiding all typical startup problems and doubt, giving advices taken from real-world scenarios. For this reason I’m sure you’ll appreciate the book even if you already have some experience in creating BI solutions.

It covers DWH Design, Analysis Services, Integration Services, Reporting Services and Data Mining: all the things you need to be able to handle in your BI project.

I’ve contributed to write two chapters on Integration Services of this book, and since this is my first book contribution, I’m also particulary proud of it :).

Happy reading!

posted @ Friday, February 13, 2009 3:46 PM | Feedback (0)