SQL Server Thoughts from the Field

Rob's SQL Server & BI Blog

Browse by Tags

Related Posts
  • Blog Post: Sysinternals Live Beta Launched

    Microsoft has launched the Sysinternals Live beta, allowing execution of Sysinternals tools directly from the web. Enter a tool’s Sysinternals Live path into Windows Explorer or a command prompt as \\live.sysinternals.com\tools\<toolname> or view the entire Sysinternals Live tools directory in...
  • Blog Post: SQL Server 2008 Upgrade Technical Reference Guide Released

    The SQL Server 2008 Technical Reference Guide has just been released, covering the essential steps and best practices to upgrade existing 2000 and 2005 instances to 2008. There is also a list of other upgrade resources available at http://msdn.microsoft.com/en-us/library/cc936623.aspx These guides...
  • Blog Post: SQL Server 2005 Performance Dashboard

    I've had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I've created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers to monitor the general performance characteristics of a server...
  • Blog Post: Scottish SQL Server User Group Meeting - Oct 8th

    I have the great pleasure of speaking at the next Scottish SQL Server User Group meeting being held in Mocrosoft's Edinburgh ofice on Thursday the 8th of October. Full details can be found on the UK User Group site . My talk will focus on some of the great tools we have for collecting and analysing SQL...
  • Blog Post: SQL Server 2008 - Performance Studio

    I've been looking at this new feature of SQL Server 2008 in order to demo it to customers, and I have to say it's pretty cool ! Along with Resource Governor and compression, it's one of my favourite new features and a good reason to consider an upgrade. Performance Studio builds on the concept of the...
  • Blog Post: Indexing Strategies

    I attended a SQL Server User Group meeting earlier this year and heard a presentation about favourite DMV's. Mentioned in the discussion was sys.dm_db_index_usage_stats and that got me thinking about indexing strategies. I have been involved in performance troubleshooting databases that have used a variety...