4th - 7th March 2015

ExCeL London Exhibition and Convention Centre, London

davide_mauri.jpg

Davide Mauri

Davide Mauri - MVP on SQL Server - has worked with SQL Server since version 6.5, and his interests cover the whole platform, from the Relational Engine to Analysis Services, from architecture definition to performance tuning. He also has a strong knowledge of XML, .NET and the Object Oriented Design principles, which allows him to have the correct vision and experience to handle development of complex Business Intelligence solutions. Having worked as a Microsoft Certified Teacher for many years, Davide is able to pass all his knowledge to his co-workers, allowing his team to deliver high-quality solutions. He currently works as a Mentor for SolidQ and can be found speaking in many Italian and internationals events.
http://www.davidemauri.it http://sqlblog.com/blogs/davide_mauri/rss.aspx

Come to this session to see how you can create a logging, monitoring and profiling solution for your existing or new SSIS packages overcoming all usual problems that a typical solution brings: increasing package complexity, longer development times and so on. The session will propose a standard, out-of-the-box solution for all of these challenges.
Snapshots without snapshots...is that possible? Take a "Classic" snapshot fact table, add some temporal data theory and you'll get a new fact table than can store snapshot data without doing snapshots. A life saver when you have a lot of data.

Blog posts RSS

SSISDB Monitoring Queries on GitHub 19 Jan 2015
I’ve moved my SSISDB scripts from Gist to GitHub where I can maintain them more comfortably. So far, I’ve published 6 scripts: ssis-execution-status: Latest executed packages ssis-execution-breakdown: Execution breakdown for a specific execution ssis-execution-dataflow-info: Data Flow ...

SQL Konferenz 2015 16 Jan 2015
On the first days of February I’ll be speaking at the German SQL Konferenz 2015 in Darmstad (Frankfurt) with a lot of other friends: http://www.sqlkonferenz.de/agenda.aspx I’ll be talking about two topics that my developer side love at most : Service Broker and “Dynamic Schema”: Schema-less ...

Expired Account Password on a Azure VM 02 Jan 2015
Today I faced a really nasty problem. I’m really getting in love with Azure and especially with SQL Server hosted in Azure VM. It opens up a huge amount of opportunities, for small, medium and big companies, since they can have everything they ask for but without the burden of having to maintain a ...

Using NLog With BIDS Helper to add logging to BIML Script executions 03 Dec 2014
When using BIML within BIDS Helper, if your BIML Script files get complex it may be quite hard to debug BIML Script Execution in order to understand what’s going on behind the scenes. On Windows Server 2008 it was possible to use the System.Diagnostic.Debug.WriteLine and DebugViewer from ...

PASS Summit 2014 Pre-Con Preview: Davide Mauri 08 Oct 2014
If you’re into Data Warehousing, you may be interested in attending to the workshop I’ll deliver at PASS Summit 2014 in Seattle on November 4th. http://www.sqlpass.org/summit/2014/Sessions/PreConferenceSessions.aspx The workshop is entirely dedicated to explaining why and how a *successful* Data ...