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 | […]
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 […]
“Be the one to stand out in the crowd.” – Joel Osteen This is the fourth in a series of blog posts that talk about success. I had the opportunity to ask the registered attendees for SQLSaturday Philippines to vote for a particular topic that they like best. Since I usually talk about professional development for IT […]
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 […]