My friends at MSSQLTips.com asked me to do a webcast on SQL Server 2012 AlwaysOn Availability Groups. You’ve probably noticed that I have not been writing anything about SQL Server 2012 (formerly “Denali”) from both the articles that I’ve been writing and the previous blog posts as compared to when SQL Server 2008 was being […]
PostWhy Standards Are Important
I’m a big fan of standards specially when you know that they work. It’s like knowing that when when you’re measuring some length in the US, you know the unit would likely be in inches or feet because it is a standard unit of measurement. I was installing SQL Server “Denali” on my test environment […]
PostWhacked Out Windows Server 2008 Failover Cluster Validation Wizard
I’ve setup a number of Windows Server 2008 (and higher) Failover Clusters in the past and this is the first time I’m seeing this. I’m running the Failover Cluster Validation wizard on two servers that will be used as nodes for a Windows Failover Cluster. When I run the wizard from ServerB, everything works fine. […]
PostOn Disaster Recovery and my SQL Rally 2011 Presentation
Yesterday, I saw a Twitter post regarding the speaker evaluation results from SQL Rally 2011 in Orlando, FL last May. I was surprised to see that my session was in the top 3 best sessions of the conference. I dug up the Excel spreadsheet containing my session evaluation results and began to read. I found […]
PostBuilding a Scale-Out SQL Server 2008 R2 Reporting Services Farm using Windows Network Load Balancing Part 2
Part 2 of the series is out. The rest will probably take quite some time as I’m still wrapping up a few items on the ASP.NET aspect of SQL Server 2008 R2 Reporting Services. Stay tuned
PostBuilding a Scale-Out SQL Server 2008 R2 Reporting Services Farm using Windows Network Load Balancing Part 1
For the past couple of weeks, I’ve been working on a series of articles on building a scale-out SQL Server 2008 R2 Reporting Services Farm. Part 1 of this series is already available on MSSQLTips.com. This was inspired by the SQL Server 2008 Failover Cluster installation series as I’ve been searching for available guides online […]
PostDisaster Recovery Is More Than Just Technology Part 3: The Lion, The Switch and The Wardrobe
You were in your favourite bar one Saturday night when, suddenly, you hear your mobile phone ring. You pick up the phone and heard the sound of a screaming voice on the other end (no, it’s not your wife telling you to go home and take out the trash). The background noise is preventing you […]
PostDisaster Recovery Is More Than Just Technology Part 2: The Alphabet Soup
In my previous blog post, I talked about high availablity and disaster recovery (HADR) and how it is more than just the underlying technology that keeps the entire strategy intact. In this blog post, I’ll describe a few acronyms – sometimes called buzzwords – that are commonly referred to in HADR projects and implementations (I […]
PostDisaster Recovery is More Than Just Technology Part 1
While I was at the PASS Summit 2010, I’ve spent a fair amount of time at the Ask-the-Experts table on high availability, disaster recovery and virtualization. Conference attendees with different requirements on high availability and disaster recovery come to these tables and ask questions. I’ve spent a fair amount of time doing high availability and […]
PostYour poor man’s SQL Server log shipping-PowerShell version
In 2008, I was privileged to be a part of a project to write a chapter for a book that was for a good cause. SQL Server MVP Deep Dives became an avenue for a lot of the SQL Server MVPs to share their expertise for the benefit of not just the technical community but […]
