At Straight Path Solutions, we love performing SQL Server Health Assessments. These are our exams that dig quickly into the root of your SQL Server instance and find problems that you are currently suffering from. Then we give you an action plan to stop suffering from them today. Rather than just performing the checks and finding the … Read more
I do a lot of SQL Server Health Assessments on SQL Server environments. I’m always checking sys.configurations to look for problematic instance level configuration settings. I almost always find configurations worth changing. But the approach I’ve always used is a bit manual and I wanted to fix it. So I finally wrote a script to … Read more
2016 has proven to be a busy year for Straight Path! We launched our DBA On Demand Service. This is a Senior level Remote DBA offering – the basic premise being “what if you had access to world class Senior level talent, and paid for only what you needed from them?”. We’ve on boarded several … Read more
Today Microsoft just made a huge announcement. All of the features you can build into your databases in SQL Server (well the vast majority at least) are no longer just included in Enterprise Editions. There are some exceptions… But the main point here is – you can be on SQL Server Standard – and you can use … Read more
As my friend and fellow SQL Server MVP, Tim Mitchell pointed out in a blog post today – our companies are working together in a strategic way. Our clients should benefit from this relationship in a few ways. I wanted to chat about that here and why I’m excited about it. We’ve actually been working … Read more
Quick note: From time to time I blog about the Bible here. I try to keep those posts on my personal blog – Open Mike – but sometimes it makes sense for a quick cross post over here. I always tag those posts with the Bible category and you are free to read or ignore … Read more
In this continuing series, I’m blogging about Free tools for SQL Server DBAs. You can check the whole series out, here. This week we’re talking about and old standard – SQL Sentry Plan Explorer. SQL Sentry Plan Explorer I hope you look at SQL Server execution plans. If you do this in management studio using … Read more