Tag: SQL Server

Using the Cluster Preparation Checklist for Deploying SQL Server Failover Clustered Instances and Always On Availability Groups

Failing to plan is planning to fail Designing and deploying high availability solutions takes a lot of preparation and planning. Whenever I do presentations that involve demos of creating SQL Server failover clustered instances (FCIs) and Availability Groups (AGs,) I emphasize that while the demo only takes less than 20 minutes to complete, it takes […]

Helpful Techniques on SQL Server Database Recovery

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 […]

Giving 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. […]

Two SQL Server Webcasts from MSSQLTips.com

I’ve done two SQL Server webcasts for my friends at MSSQLTips.com. One is regarding security best practices for deploying SQL Server databases in the cloud. As more and more customers are thinking of deploying databases in the cloud, security is one of their main concerns. In the webcast, I talked about principles and concepts on securing […]

Database Configuration for Maximum SharePoint Performance (Video, Slide and PowerShell Script)

This post is way overdue. Since I’ve been getting a lot of requests about this specific presentation regarding SharePoint databases, I decided to do two things. First, I recorded this presentation for all my attendees to use as a reference. Now, you might be thinking, “If you’ve already recorded your presentation, wouldn’t that affect attendance […]