SQL Server Consulting – Straight Path Solutions

Welcome To Straight Path Solutions As a consultant to the company, I worked directly with Mike for approximately one year. We worked as part of a team in a challenging software development environment with aggressive deadlines and many moving pieces. As a Database Administrator, Mike was a strong contributor and key to our success. As … Read more

SeacoastSQL First Meeting Recap

(Written the night of the meeting, edited and posted after) Wow. I just got home from a really great night with a fun group of people. The first meeting (hopefully of many more) was a success (more on what that means from my point of view below) and we had an amazing turnout – By … Read more

You Can Tune Your Own SQL Code

This talk is geared towards developers who maybe aren’t so familiar or comfortable with Query Plans, IO Statistics, SQL Profiler or the concepts of tuning queries. We cover some basics (Indexing, SARGable Queries, Statistics, Some “Worst Practices”, some general concepts for performance minded development) and then play with some sample queries. The purpose of the … Read more