Regularly Treat Your Databases to a S.P.A.

“Today’s DBAs have responsibilities that go far beyond their traditional role of data custodian.” I was reading the infographic that Idera published about their accidental DBA survey results last week and wasn’t surprised at all by the results. I considered myself an accidental DBA when I was starting out in the industry and can totally […]

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

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

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