I keep highlighting that it is necessary for DBAs to understand the underlying infrastructure as it helps when it comes to resolving issues. I was having connectivity issues with my SQL Server 2008 instance as sqlcmd and osql are both throwing this error HResult 0xFFFFFFFF, Level 16, State 1SQL Network Interfaces: Error Locating Server/Instance Specified […]
This last weekend, I had the opportunity to speak at SharePoint Saturday Montreal – being one of the few English speakers for the event – on the topic of SQL Server high availability and disaster recovery options for SharePoint. After my presentation, one of my SharePoint MVP friends approached me about a database corruption issue that happened on […]
I previously wrote about Data Types and How They Affect Database Performance which was a way to get database developers to think about the small things that affect overall performance. As a high availability and disaster recovery (HA/DR) professional myself, I like to think of how data types affect database availability and recoverability. The fact […]
I’d be honest. I was a bit emotional as I was preparing my presentation for the PASS Professional Development Virtual Chapter. If you’ve seen some of my presentations, you’ll know that I love telling stories to get the message across. But for this presentation, the story really hits home as I’m reminded of a friend […]
Last year, I got introduced to DH2i and DxEnterprise. Since I work with different customers to provide SQL Server high availability and disaster recovery solutions, I’m always trying to find different ways to help meet business objectives while reducing total cost of ownership. I was a bit hesitant at first to try out DxEnterprise since I’ve […]