Nov 11, 2010
Did you see the editorial post from SQLServerCentral this morning? It’s very cool and I wanted to bring it to your attention. Those clever chaps have gone and deployed the latest edition of SQLMonitor from RedGate on the SQLServerCentral website and made the dashboards available for you to interact with online, in real time. Take [...]
Jun 5, 2009
Paul Randal pointed me in the direction of an awesome resource list of FREE SQL Server tools. There is an absolute mountain of quality stuff here and I wanted to share it with you all. Free SQL Server Tools that might make your life easier Be sure to me know which resources you use and [...]
Mar 20, 2009
This week I came across what could quite possibly be, the best SQL Server index defrag script I have seen. This little beauty is fully customisable and is freely available courtesy of Michelle Ufford (aka SQL Fool) on her blog SQLFool.com As you know, it is just not practical to use a SQL Server Maintenance [...]
Feb 26, 2009
I recently came across a post on Stackoverflow regarding the performance of using a SELECT TOP 1 query in comparison to using the MAX() function. My initial thoughts on this were that the MAX() function would provide the best performance however, in order to be absolutely certain and prove my initial hypothesis I decided to [...]
Feb 12, 2009
One of the joys of working with SQL Server technologies is that there are some truly great knowledge resources available for use. You just have to know where to look. With the volume of information available it can be difficult to sift out the really good stuff. I know throughout my time as [...]
Jan 13, 2009
An essential skill trait for a good DBA in my view is being organised. With the responsibility of administering and managing vast numbers of servers/jobs/processes simultaneously across the globe, it goes without saying that being organised can come in handy. What with so much going on at any given time, it can be tricky to [...]
Most Commented Posts