Archive for the ‘SQL SERVER’ Category

Plotting Numbers of Bugs Raised Each Day From a BugTracker in Excel

Wednesday, December 7th, 2011

I had a requirement to plot the number of bugs raised on each day on a graph to show how many are raised.   The bugs were stored in the very wonderful BugTracker.NET .  The problem was I had a list of bugs with a date time. ID MIN(dateUpdated) 2 11/04/2011 09:10 4 12/04/2011 16:48 14 18/04/2011 21:03 15 20/04/2011 07:14 16 20/04/2011 ...

SQL SERVER 2005 – Profiler – Only show queries from a specific database

Wednesday, November 26th, 2008

This was easier in 2000.  This annoyed me for ages but not enough to actually look into why I could no longer filter by Database (well not obviously!). The trick is to click the "Events Selection" on the "Trace Properties" when you create a new trace, and check the "Show all ...