Importance of a Methodology
There are tons of scripts and “how-to” videos on the internet that teach a wide range of topics. My problem is whenever I want to learn something niche. I want to go deep into a niche topic and learn it “A-Z”, but rarely find a guide for that. It’s always been in piecemeal fashion. So when I find a course that offers that “A-Z” style, it definitely grabs my attention. But, the cherry on top for me is when that course/s teaches a methodology.
Continue reading “Review – Brent Ozar’s Performance Tuning Classes”
There are few features in SQL Server that are disabled, or turned OFF, by default that, in my opinion, should be turned on/enabled. One of those features is something called “Instant File Initialization” (You can read about the other one here).
Continue reading “How to Enable Instant File Initialization SQL Server”
[NO! This is NOT an April Fools joke]
On a recent episode of Office Hours (by Brent Ozar Unlimited) I couldn’t stop laughing at a comment Brent made. The team was talking about “DBA porn” and Brent said (paraphrasing), “going to DBA cubes and seeing the perfmon counter poster.” (Subscribe to Office Hours on iTunes) Continue reading “Free SQL Server Perfmon Counter Poster”
I was recently asked what the difference was between “scaling up” and “scaling out.” I thought, “why not draw a cartoon to illustrate?” So below is my attempt at drawing a cartoon to show the difference between the two. (By the way, if you haven’t figured it out, those are servers flexing their biceps. Yes, they have stick legs. I’ve been telling them to do squats but they don’t listen!) :) Continue reading “SQL Server Scale Up vs Scale Out – Cartoon”
Recently I was asked,
If you approached a SQL Server with abnormal usage (slow applications, etc,) and have a limited amount of time, how or what tools would you use to diagnose the issue?
I replied by saying I would execute a great script like sp_whoisactive, by Adam Machanic, or sp_BlitzFirst by Brent Ozar’s team.
He quickly replied, Continue reading “How To Use SQL Server Activity Monitor”