Invitation for T-SQL Tuesday #004: IO

Yes, it is already time for T-SQL Tuesday again (well one week away, time for the invite). I have been thoroughly enjoying T-SQL Tuesday (especially the posts ones from Brad Schulz) but the fact that this is #004 means time is flying too fast lately. You Don’t Know What T-SQL Tuesday Is Yet? Adam Machanic … Read more

SQL Server Consultant Testimonials

What some of our SQL Server consulting clients have to say about working with Mike: Mike is very knowledgeable with SQL. He has helped my company many times to get the most power out of our SQL installation. Mike also is very good at teaching others. Mike is my number one resource when it comes … Read more

Why You’re Here. Why We Exist

straight path sql team

We don’t believe you should be slowed by wading through all of the questions that come with SQL Server or your cloud data platform – Licensing, many permutations of High Availability options, cloud vs on-premises vs hybrid, all those versions with upgrade questions, virtualization, uncontrolled sprawl, and performance frustrations. You should be free to focus … Read more

SQL Server Implicit Conversion: You Could Be Suffering Right Now!

SQL Server Implicit Conversion – A Silent Perf Killer I recently had the opportunity to work with a developer at the day job. He was using a loop (for what he was doing, it makes sense 🙂 ), and he had a query that ran great when he stripped the question out of the process, … Read more

Benchmarking… Who Needs It?

All of our SQL Server instances need benchmarks! So the title is somewhat of a trick question… I hear and sense a lack of priority around taking periodic benchmarks in a system with a lot of folks. How often do you take benchmarks? Do you know what “normal” means for your system? Do you know … Read more

Worked fine in development…

How many times have you heard or uttered those words? You work hard and understand the business requirements, you try and get the logic to work to make the procedure return what was expected or update the data as expected. You do some unit tests in your environment, it may not scream but it comes … Read more