Welcome to MSDN Blogs Sign in | Join | Help

Benjamin Wright-Jones

SQL Server Lessons Learned and Notes from the Field (Microsoft Consultancy Services, UK)

News

  • This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms specified on Microsoft.com Locations of visitors to this page

September 2009 - Posts

Changing the LISTENER_IP address in a database mirroring configuration
This question came up today: how can I change the IP address between the principal and mirror in database mirroring? Not a common operation but this procedure worked in an isolated lab environment where we had full control over the application and transaction Read More...
New HP Resources on SQL Server 2008 Data Warehousing / Business Intelligence
I haven’t had a chance to look through these yet so I can’t comment on the content but I thought I would post here to share these new resources. HP Business Intelligence Sizer for Microsoft SQL Server 2005/2008 http://h71019.www7.hp.com/ActiveAnswers/us/en/sizers/microsoft-sql-bi.html Read More...
Troubleshooting SQL Server Transactional Replication
I often see questions about transactional replication performance problems, especially around latency/delays between the publisher and subscriber(s) so I’ve put a few pointers below on what to investigate.  Latency between the publisher, distributor Read More...
Fusion IO 640GB SSD PCI-Express Cards
We recently had the opportunity to test a couple of the Fusion IO PCI-Express 640GB SSD cards http://www.fusionio.com/Products.aspx in a Dell R900 server, unfortunately time was against us and we were unable to do this. The Fusion IO SSD cards would dramatically Read More...
Page view tracker