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
Our SQL Server Consulting Sells Green Checkmarks SQL Server Consulting that ticks all the boxes: Slow SQL Server performance? Reliability issues? Scalability challenges? Coverage gaps? After engaging with our team of SQL Server consultants, these problems will be gone. We get it. We’ve been in the trenches and understand how frustrating these problems can be … Read more
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 – 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
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
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
So I wrote a lot of posts around shrinking (Here, here, here). Some of my posts were turned into a wiki article on SQLServerPedia. I thought I was done posting about this but one more. I talked about why we shouldn’t do it on a regular basis. Why it should really be reserved for use … Read more