SQL Server Index Internals and How Filtered Indexes Look Like (Part 1)

“During one of my SQL Server Index Internals presentation, an attendee asked me how filtered indexes look like and if they are stored exactly the way the traditional indexes are. I was tempted to show the internals of how filtered indexes looked like using DBCC PAGE during the presentation but held back because it deserves […]

Continuous GROWTH is Required

“Intellectual growth should commence at birth and cease only at death” – Albert Einstein – This is the third 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 […]

Why Going Back To The Basics Matters

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

Leadership Lessons from Driving in the UK

Right-hand drive by EdwinMSarmiento I was privileged to be invited as a speaker in the last SQLBits conference held in Nottingham, UK earlier this month. I have to admit that I was pretty excited since this will be my first time to be in the UK. I prepared all the necessary travel documents for the trip […]