Browse by Tags

• 2005
• 2012
• Agent
• Agile
• Analysis Services
• Best Practices
• Business Intelligence
• CodePlex
• Data Warehouse
• DMV
• DTLoggedExec
• Engineering
• Extended Events
• Integration Services
• Job
• Logging
• MDX
• Monitoring
• OLAP
• PASS
• PowerPivot
• Reporting Services
• Scripts
• SQL Server
• SSAS
• SSIS
• sys2
• T-SQL

• Trapping SQL Server Errors with Extended Events

  One very useful usage of Extended Events is the ability to trap SQL Server error without the need to have a server trace running (which, btw, is deprecated), with the additional feature of being able to query the data as soon as it comes in. This means Read More... Posted Sunday, March 17, 2013 7:45 PM by Davide Mauri | 1 Comments Filed under: 2008, SQL Server, 2008 R2, 2012, Extended Events, Monitoring

• Forcing “Custom Properties” of a Data Flow Transformation to support DTS Expression

  Today I was using a 3rd Party Data Flow component that has several Custom Properties for which I need to change some of their values at runtime using a DTS Expression. To mimic the situation let’s use the “Percentage Sampling” that has two Custom Properties: Read More... Posted Wednesday, January 30, 2013 6:48 PM by Davide Mauri | 0 Comments Filed under: SSIS, Integration Services, 2008, 2008 R2, 2012

• Power Pivot SQL Agent Job Monitor

  In the last days I needed a quick and efficient way to monitor the performance of a job and of each step over time. There’s a lot of interesting data in MSDB database and the various sysjob tables, but the stored data is not really easy to use outside Read More... Posted Monday, January 07, 2013 11:23 PM by Davide Mauri | 2 Comments Filed under: 2008, 2005, 2008 R2, PowerPivot, 2012, Job, CodePlex, Agent

• SSAS DMVs: useful links

  From time to time happens that I need to extract metadata informations from Analysis Services DMVS in order to quickly get an overview of the entire situation and/or drill down to detail level. As a memo I post the link I use most when need to get documentation Read More... Posted Friday, May 18, 2012 5:47 PM by Davide Mauri | 0 Comments Filed under: 2008, DMV, 2008 R2, Analysis Services, 2012

• DTLoggedExec 1.1.2008.4 SP2 released!

  I’ve released couple of hours ago the SP2 of my DTLoggedExec tool. For those who don’t know it, it’s a DTEXEC replacement, useful to execute SSIS and having logging provided right from the engine and not from the package itself. More info can be found Read More... Posted Wednesday, February 01, 2012 7:15 PM by Davide Mauri | 0 Comments Filed under: DTLoggedExec, SSIS, 2008, 2008 R2

• SYS2 scripts updated (December 2012)

  I’ve updated my SYS2 scripts: Added a new script to see how much buffer cache memory is used by each database Updated the sys2.stats script in order to have only one row per statistics Updated the sys2.query_stats script to use the sys.dm_exec_plan_attributes Read More... Posted Tuesday, December 13, 2011 12:26 AM by Davide Mauri | 0 Comments Filed under: 2008, DMV, 2005, sys2, 2008 R2

• Spotlight session at PASS 2011 - Temporal Snapshot Fact Table

  I’m very happy to announce that my proposal for the Spotlight session I’ve been invited to deliver at PASS 2011 has been accepted! Temporal Snapshot Fact Table You are designing a BI Solution and your customer ask you to keep a snapshot of the status Read More... Posted Sunday, May 29, 2011 4:44 PM by Davide Mauri | 7 Comments Filed under: SSIS, Integration Services, Business Intelligence, 2008, 2005, 2008 R2, SSAS, Analysis Services, Data Warehouse

• SYS2 Scripts Updated – Scripts to monitor database backup, database space usage and memory grants now available

  I’ve just released three new scripts of my “sys2” script collection that can be found on CodePlex: Project Page: http://sys2dmvs.codeplex.com/ Source Code Download: http://sys2dmvs.codeplex.com/SourceControl/changeset/view/57732 The three new scripts Read More... Posted Sunday, February 13, 2011 7:30 PM by Davide Mauri | 2 Comments Filed under: T-SQL, 2008, DMV, Scripts, 2005, sys2, 2008 R2

• BI Virtual Chapter: “Adaptive BI: Engineering a BI Solution”

  On the next 20th Semptember I’ll deliver a session on a topic that is IMHO really important but is not yet covered enough: Adaptive BI: Engineering a BI Solution Are you starting to create a BI solution....but where do you begin with? How to setup everything Read More... Posted Thursday, September 09, 2010 12:54 PM by Davide Mauri | 0 Comments Filed under: Agile, Business Intelligence, 2008, 2005, 2008 R2, Best Practices, Engineering

• PASS Summit 2010 – BI Workshop

  PASS Summit 2010 Pre & Post conference are out ! This year I’ll deliver the “ Creating BI Solution from A to Z ” seminar in which, as the title implies, attendees will see how to create a BI solution starting from scratch. Going through the dimensional Read More... Posted Wednesday, June 30, 2010 3:01 PM by Davide Mauri | 1 Comments Filed under: SSIS, Integration Services, Reporting Services, Business Intelligence, 2008, PASS, MDX, OLAP, 2008 R2, Best Practices

• DTLoggedExec 1.0 Stable Released!

  After serveral years of development I’ve finally released the first non-beta version of DTLoggedExec ! I’m now very confident that the product is stable and solid and has all the feature that are important to have (at least for me). DTLoggedExec 1.0 http://dtloggedexec.codeplex.com/releases/view/44689 Read More... Posted Sunday, May 09, 2010 11:51 AM by Davide Mauri | 0 Comments Filed under: Logging, DTLoggedExec, SSIS, Integration Services, 2008, 2005, 2008 R2