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

SQL Konferenz 2015 Slide & Demo 09 Feb 2015
Last week I spoke at the SQL Konferenz in Darmstad near Frankfurt. The conference was great and I meet a lot of good SQL friends over there. For anyone interested here you can find slide & demos of the session I delivered: (Near) Real-Time Data Integration with SQL Server, On-Premises & ...

Iris Multi-Class Classifier with Azure ML 02 Feb 2015
As many of us I’m passionate about informatics *and* mathematics which, of course, lead me to be passionate about the outcome of their marriage: Databases and Machine Learning. Now that Machine Learning is becoming a kind of a “commodity” thanks to AzureML I can finally start to use it in any ...

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 ...