THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » 2008 R2 » 2005   (RSS)
  • 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 the Management Studio. Date and Time are not stored as date/time data type, there is no easy way ...
    Posted to Davide Mauri (Weblog) by manowar on January 7, 2013
  • 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 dmv to get better information on which database was used by the cached plans ...
    Posted to Davide Mauri (Weblog) by manowar on December 12, 2011
  • 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 of all their documents (orders, insurances, contracts, bills...whatever the word ...
    Posted to Davide Mauri (Weblog) by manowar on May 29, 2011
  • 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 are the following sys2.database_backup_info.sql sys2.query_memory_grants.sql ...
    Posted to Davide Mauri (Weblog) by manowar on February 13, 2011
  • 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 correctly so that you'll be able to handle new features required by the customers ...
    Posted to Davide Mauri (Weblog) by manowar on September 9, 2010
  • 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 Here’s the release notes: FIRST ...
    Posted to Davide Mauri (Weblog) by manowar on May 9, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement