Cumulative Update 2 to the RML Utilities for Microsoft SQL Server Released

  Version 9.04.004 of the RML Utilities for Microsoft SQL Server has been released.  This release of the RML Utilities provides support for: SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 CTP2 on Windows 7 Windows 8 Windows 8.1 Windows Server 2008 Windows Server 2008 R2 Windows…

10

SQL Connection Pool Timeout Debugging

This is a follow up to two blog posts from back in 2009 which talked about leaked connections.  In Part 1 and Part 2 of that post, it was about how to determine that you actually filled your pool.  This was centered around the following error: Exception type: System.InvalidOperationException Message: Timeout expired.  The timeout period…

2

Every time I ‘ATTACH DATABASE’ SQL logs error 1314 for SetFileIoOverlappedRange

Turns out this is an issue in the SQL Server code and the error is a bit noisy during attach database. When opening the database files, SQL Server calls SetFileIoOverlappedRange (when enabled properly) in order to help improve I/O performance.  This is commonly done under the SQL Server, service account; which requires locked pages privilege. …

2

Microsoft CSS @ PASS Summit 2013

During October 15th-18th, the US PASS Summit 2013 will be held in Charlotte, NC at the Charlotte Convention Center.  The Microsoft CSS team has a long history with PASS.  We have been speaking and working at PASS since 2003.  This year we will have the added advantage of being on our home turf with one…

0

Invalid or loopback address when configuring SharePoint against a SQL Server

I was presented with a connectivity issue when trying to configure SharePoint 2013 using a CTP build of SQL 2014.  They got the following error when they were it was trying to create the Configuration Database. Exception: System.ArgumentException: myserver,50000 is an invalid or loopback address.  Specify a valid server address.    at Microsoft.SharePoint.Administration.SPServer.ValidateAddress(String address)   …

5