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 […]
Last year I started to get involved in the SharePoint community, particularly the SharePoint Saturday events. As a SQL Server DBA, I thought that SharePoint administrators need to have a fair understanding of the underlying database because it is the backbone of a highly-performing SharePoint farm. That gave me the idea of doing a presentation […]
In the first part of this series, I talked about how SQL Server navigates thru the index structure and used a clustered index as an example to demonstrate how the process works. To continue this series, we’ll look at filtered indexes and how they look like from a storage perspective. If you look at the […]
I was thinking of posting this in my non-technical blog but realized that technical professionals will find value in the underlying principles and concepts. When I look at different questions posted on the MSDN and TechNet forums, I notice a common thread. Questions are focused on either “how to do X?” or “what is Y?” […]
A couple of weeks ago, I did a webcast for my friends at MSSQLTips about the top 5 things that every SQL Server DBA should monitor. If you’ve been to one of my presentations, you will notice that I usually focus on the WHY behind the topic. Understanding our overall goal makes it easy for […]