Last year, I started writing an article that was supposed to be a series for Installing, Configuring and Managing Windows Server Failover Cluster using Windows PowerShell. The first of the series came out on July 2013 (which ended up being the last article I wrote for the year 2013 on MSSQLTips.com.) Since then, I’ve been involved […]
PostWhy Regular Shrinking is NOT the Right Way to Reclaim Database Space in SharePoint – nor in any SQL Server database
I recently got a question about how to reclaim database space in SharePoint. The specific database mentioned was WSS_Logging although this could have been any of the SharePoint databases or any other SQL Server database for that matter. The database was growing really fast so the farm was configured to only keep a week’s worth […]
PostGiving Away FREE Access to My SQL Server High Availability and Disaster Recovery Deep Dive Course
Yesterday, I tweeted about giving away FREE access to my online course on Udemy (and, yes, it’s a birthday gift from me). If you’ve been following my blog post, you may already know that I’ve launched my very first learning experiment last week via the online course. I haven’t really promoted the course yet (aside from […]
PostSQL Server High Availability and Disaster Recovery Deep Dive Course Now Available
I’ve been working on this personal project since early this year. If you’ve been following my blog posts, my articles on MSSQLTips.com or even my presentations at various events, you know that my area of expertise is on SQL Server high availability and disaster recovery. I’ve compiled years of experience and exposure with SQL Server […]
PostGot A “Validating WSFC quorum vote configuration” warning when you create a SQL Server Always On Availability Group?
I bet a lot of IT professionals who are really serious about their work are like me. When they see an error or warning message like this, their first instinct is to find out what the problem is and fix it. That’s what I did when I saw this error while configuring a SQL Server […]
PostCreating a SQL Server 2012 Availability Group Article on CanITPro.net
I’ve been wanting to write for the CanITPro.net website for quite sometime now, primarily because there hasn’t been any new content on SQL Server on the site lately. The Canadian IT Pro and developer communities are very vibrant and active, thanks to the effort of Canadian Microsoft MVPs Jean-René Roy (blog) (DevTeach/SQLTeach) and D’Arcy Lussier (Twitter | […]
PostFundamentals of SQL Server 2012 Availability Groups (Webcast)
The premise of this webcast is based on my conversations with customers who wanted to implement SQL Server 2012 Availability Groups. There have been a lot of confusion about the terminologies, technologies and implementation ever since Availability Groups was introduced in SQL Server 2012. This webcast seeks to explain the underlying fundamentals behind Availability Groups. You […]
PostAlways On Readable Secondaries: That Extra 14-bytes In Your Record You Didn’t Know About
– “Progress comes at a price.” Edwin Sarmiento- I’ve responded to customers’ inquiries about the benefits of implementing SQL Server 2012 Always On Availability Groups since Microsoft released a public CTP of “Denali.” I’ve delivered presentations, written articles, prepared proof-of-concept designs and even recorded a video on this topic. While it may be a new […]
PostAre you switching to BULK_LOGGED recovery model? Know your risks.
For years I have been led to believe that using the bulk-logged recovery model for SQL Server databases was a safe place to be in (that was entirely my fault, not MSDN’s nor TechNet’s.) I took it upon myself the definition of this recovery model – MINIMAL log space is used by bulk operations. My […]
PostDeploying a SQL Server 2012 Multi-Subnet Cluster
I’ve been wanting to write a series of articles on deploying a SQL Server 2012 on a multi-subnet cluster for quite some time now. This was driven by the fact that my series of articles on SQL Server 2008 Failover Clustering had been in the Top 10 Tips for more than 2 years since being […]
