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 » 2008 » 2012   (RSS)
  • 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 that we a solution to monitor and trap errors as soon as they happen can be easily created, in ...
    Posted to Davide Mauri (Weblog) by manowar on March 17, 2013
  • 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: Of the two Custom Properties only some (one in this case) are available also outside ...
    Posted to Davide Mauri (Weblog) by manowar on January 30, 2013
  • 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
  • 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 on SSAS Objects Data DMVs: SSAS: Using DMV Queries to get Cube Metadata ...
    Posted to Davide Mauri (Weblog) by manowar on May 18, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement