I’ve been waiting for a few of my articles to be published before referencing to them. This particular topic has been the content of my previous presentations – SQLConnections 2012 and 24 Hours of PASS: Spring 2012 – and I’ve received requests for resources. Here they are. This article walks you through configuring Windows Server […]
PostVideo: TechDays TV Episode on SQL Server 2012 Always On Availability Groups
This is a recording of the Microsoft Canada TechDays TV episode I back in 20-Mar-2012. The video walks you thru converting your database mirroring and log shipping configurations to SQL Server 2012 Always On Availability groups, providing database availability and maximizing your investments by allowing read-only access to database replicas. You can download the resources […]
PostSQL Server 2012 High Availability Webcast Resources Now Available
There have been requests from attendees of last week’s webcast to make the resources available for download. If you’ve attended or viewed (thru MSSQLTips.com’s recording) my webcast on SQL Server 2012 High Availability with AlwaysOn, you can download the resources – Windows-based client application together with the Visual Studio 2010 project files, batch files to […]
PostFrom *-SqlHadrService to *-SqlAlwaysOn
If you’ve been playing with SQL Server “Denali” AlwaysOn, you probably have seen the new PowerShell cmdlets for managing the new AlwaysOn feature. However, as SQL Server 2012 RC0 has been made available for download, you need to watch out for these “breaking changes” for AlwaysOn (I call them breaking changes because if you are […]
PostBuilding a Scale-Out SQL Server 2008 R2 Reporting Services Farm Whitepaper Now Available
Back in 2009, I wrote a 4-part series article on installing SQL Server 2008 Failover Cluster on Windows Server 2008 and, for the past two years, has been on the Top Ten Tips. I think one of the reason is because of the fact that we humans learn easily with the use of visuals (the […]
PostWatch Out for SQL Server 2012 AlwaysOn Webcast
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
