Optimize For Ad Hoc Workloads – Enable or not?
With today’s Straight Up SQL Server tip, I want to talk about a setting I have so far only ever recommended to enable: Optimize for Ad Hoc Workloads. Rather than just make a suggestion, I want to keep in the spirit of the tips for beginner approach to the series and describe a little of … Read more
Dr. Cloud-Move or: How I Learned to Stop Worrying and Love the Cloud
With apologies to Mr. Kubrick for my title, I’ll give you a little honest backstory. I’ve been working with SQL Server for 17 years now. Mostly in the box, on-premises. I’ve done all sorts of things with SQL Server. Always heading back to DBA, performance tuning, high availability, etc. My career owes a lot to … Read more
SQL Server Corruption – Read Before it Happens
SQL Server Corruption is a rather complex topic. As a consultant, I’ve been called in many times to help a client suffering from SQL Server corruption in some form or another. As a forum post answerer I’ve helped some pretty sad situations and tried to help. There have been times when I’ve reached out to … Read more
DBA Questions To Ask Software Vendors
Do you buy software from independent software vendors? Does it run on SQL Server? Are you responsible for supporting that software? Here are some questions that you can ask a software vendor about the way they use SQL Server. It’s best to ask these questions before you are a customer, too; you’ll have a bit … Read more
SQL Server Version Numbers – Do they matter?
It’s a trick question, yes. Your SQL Server version matters! In this post I’ll tell you how to check your version, talk about what makes up the version number and talk about why it matters so much and why you should get a plan in place to regularly upgrade or update SQL Server. This post is part of … Read more
Introducing Straight Up SQL Server Tips
An Introduction and a Why. . . I’ve been blogging about SQL Server since 2009. Over the years I’ve blogged about many topics and levels. For some reason, I’ve most loved writing the posts to beginner and intermediate levels though. Things that trip folks up day to day, etc. While I’ve been an independent consultant … Read more
Are Power Saving Settings Killing Your SQL Server Performance? [Quick Tip]
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
Check SQL Server Configuration – Free Script
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
Remote DBA Benefits – After Hours Support
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
SQL Server 2016 Standard – Your Cake. You Can Eat it too.
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
2 thoughts on “SQL Server Blog”