Data Types and How They Affect Database Performance

When I was in high school, my practical arts teacher asked us to create a miniature of a structure. This meant looking at the blueprints of an existing structure and using it to create a small replica. I thought that this would be a great opportunity to learn more about reading blueprints and understanding what they are […]

People Talking Tech with MrDenny

I’ve totally forgotten about this because we did it late last year. SQL Server MVP (VMWare vExpert Awardee, EMC Elect Awardee, etc.) Denny Cherry (blog | Twitter) was kind enough to have me on his podcast. We talked about Windows PowerShell and how it can help SQL Server DBAs maximize their productivity performing tasks that, […]

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

Database Configuration Settings To Improve SharePoint Performance

Next month, I will be doing a presentation for the very first SharePoint Saturday event here in Ottawa. Since I have been doing a lot of SharePoint architecture and implementation projects, I submitted a session on improving SharePoint performance by looking at the underlying database system. Majority of the concepts in the presentation apply to […]