This video is a compilation of different database recovery techniques that SQL Server DBAs should be familiar and comfortable with. We will look at recovering a database to a specific point in time, isolating critical objects or using table partitioning as an HA/DR option (more commonly called online piecemeal restore) and performing page-level restores. I […]
PostGiving away FREE Access to my SQL Server High Availability and Disaster Recovery Deep Dive Course – Round 2
Last year, as part of launching my very first online course, I gave away FREE access to my SQL Server High Availability and Disaster Recovery Deep Dive Course. I’m doing it again this year but with a totally different reason. Here’s why. I’ve been very active in the SQL Server community in one way or another. […]
PostInstalling, Configuring and Managing Windows Server Failover Cluster using PowerShell Series
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 […]
