SQL Server Thoughts from the Field

Rob's SQL Server & BI Blog

SQL Server Thoughts from the Field

  • Performance Dashboard Reports for SQL Server 2008

    During a recent visit to Seattle for a Microsoft conference, I learned from my colleague Michael Thomassy that it's possible to run the SQL Server 2005 Performance Dashboard reports on SQL Server 2008, with a slight modification. There is a great new...
  • 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...
  • Hosting the Performance Dashboard Reports in SSRS

    I blogged a while back about modifying the SQL Server 2005 Performance Dashboard reports to run on SQL Server 2008 . I’ve since been working with several customers who use these reports for performance troubleshooting, but who would like to host...
  • Enabling Kerberos Authentication for Reporting Services

    Recently, I’ve helped several customers with Kerberos authentication problems with Reporting Services and Analysis Services, so I’ve decided to write this blog post and pull together some useful resources in one place (there are 2 whitepapers...
  • Caching SSRS Reports for Performance

    I’ve been fairly quiet on the blogging-front recently, but I have been busy working with SQL Server Reporting Services (SSRS) ! I've also been fortunate enough to present a session to customers on SSRS scalability at a recent Business Intelligence Operations...
  • Detecting SQL Server 2005 Blocking

    Database queries should be able to execute concurrently without errors and within acceptable wait times. When they don't, and when the queries behave correctly when executed in isolation, you will need to investigate the causes of the blocking. Generally...
  • SQL Server Statistics

    SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. Good statistics allow...
  • 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...
  • SQL Server 2005 Multi-Site Clustering with Windows Server 2008

    I was working recently with a customer who was looking to deploy a SQL Server 2005 cluster across 2 geographically dispersed sites using Windows Server 2008. They were looking to utilise the new clustering improvements in Windows Server 2008 to build...
  • Troubleshooting SQL Server 2008 Performance Problems

    A new whitepaper covering the topic of performance troubleshooting in SQL Server 2008 has now been released. You can download the paper from the following link: http://msdn.microsoft.com/en-us/library/dd672789.aspx
  • SQL Server 2008 RC0 Available

    The release of SQL Server 2008 has hit another milestone with the news that Release Candidate 0 (RC0) has been made available for public download this morning. This was initially released to Technet Plus and MSDN subscribers last Friday. It is expected...
  • Scottish SQL Server User Group Meeting - 29th January

    I have uploaded my slides from my Upgrading to SQL Server 2008 session at the recent Scottish SQL Server User Group meeting held in Edinburgh on the 29th January. It was good to see a number of new faces at the meeting, and if you fancy coming along in...
  • SQL Server Wow64 Perfmon Issues

    I recently came across some issues running perfmon on Windows Server 2003 where the OS is 64-bit and SQL Server is 32-bit (Wow64). The SQL Performance counters were not appearing as the default Perfmon is 64-bit, which is unable to read the 32-bit SQL...
  • Windows Failover Clustering Overview

    The host node in the failover cluster performs a "looks alive" check every 5 seconds. An IsAlive check is performed every 60 seconds using SELECT @@SERVERNAME. If this fails the IsAlive retries 5 times and then attempts to reconnect to the instance of...
  • DBCC CHECKDB

    DBCC CHECKDB checks the logical and physical integrity of all objects in the specified database by performing the following: Runs DBCC CHECKALLOC on the database Runs DBCC CHECKTABLE on every table and view in the database Runs DBCC CHECKCATALOG...
  • Windows Memory (PAE/AWE/3GB)

    PAE (Physical Address Extension) PAE is the added ability of the IA32 processor to address more than 4GB of physical memory. The following OS's can use PAE to take advantage of physical memory beyond 4GB: Microsoft Windows 2000 Advanced Server...
  • SQL Server and Windows Memory

    SQL Server 2000 Enterprise Edition introduced support for the use of Windows 2000 Address Windowing Extensions (AWE) to address 8GB of memory on Windows 2000 Advanced Server and 32GB of memory on Windows 2000 Datacentre. With AWE, SQL Server can reserve...
  • SQL Server Locking

    Locking is a mechanism used by the Microsoft SQL Server Database Engine to synchronize access by multiple users to the same piece of data at the same time. Before a transaction acquires a dependency on the current state of a piece of data, such as...
  • Hyper-V RC1 Released

    Hyper-V Release Candidate 1 for Windows Server 2008 was released on the 20th May. This is a full functionality release and provides improvements to security, stability, performance, user experience, forward compatibility of configurations, and the programming...
  • Open Source Error Opens Big Security Hole

    A programming error in an open source security project introduces profound vulnerabilities in millions of computer systems. http://www.technologyreview.com/Infotech/20801/?a=f
  • SQL Q&A Column in TechNet Magazine

    Paul Randall has started a new SQL Q&A column in TechNet magazine, which is definitely worth a read. As expected, there is some great advice regarding Database Mirroring, corruption and database fragmentation. http://www.sqlskills.com/blogs/paul...
  • Forthcoming UK SQL User Group Meetings - Leeds, Edinburgh, London

    Regional Meetings of the UK SQL Server User Group coming up in the next couple of weeks: LEEDS AREA SQL SERVER USER GROUP: THURSDAY 29TH MAY 18:30 - 21:00 : LEEDS http://sqlserverfaq.com/?eid=116 Martin Bell - Whats New in SQL Server 2008...
  • 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...
  • June SQL Technical Rollup Mail

    The June SQL Server Technical Rollup Mail has now been released. Check it out for some great SQL Server information and resources... http://blogs.technet.com/trm/archive/2008/06/01/june-2008-technical-rollup-mail-sql.aspx
  • OpsDB SQL Server Automation Tools Released

    A great set of SQL Server automation tools has just been released by Microsoft onto the SQL Server Community Worldwide site... http://sqlcommunity.com/ScriptsTools/OpsDBOperationsDatabaseforSQLServer/tabid/275/language/en-US/Default.aspx These are...