Search Results for: performance

Benchmark SQL Server Disk Latency

Typically, I am a big advocate of performance monitor but one place I commonly see performance monitor being misused is with benchmarking disk counters for SQL Server.  Typically, you will see people applying best practices like having dedicated spindles for transactional log … Continue reading

12 Steps to Workload Tuning

We might know how to tune a query for optimal performance or create additional indexes to ensure faster execution, but how do we ensure that our changes don’t hurt our total workload?  Do we know if the new 3rd Party … Continue reading

Dallas, TX to Pittsburgh, PA A #sqlsat171 Story!

  It was an honor to speak at the first SQL Saturday in Pittsburgh. The company I currently work for is based out of Pittsburgh so I flew in a week early and traded my work from home lifestyle this … Continue reading

Presenting at OKC SQL Server User Group Tonight!

Tonight, October 8th at 6:30pm I am virtually speaking at the OKC SQL Server User Group.  I had a blast there earlier this year when I presented at their SQL Saturday event.  Tonight I will be talking about Performance Tuning … Continue reading

Upcoming speaking engagements

Ayyyy, matey being that today is the International Speak Like a Pirate Day I thought it was appropriate to post some future dates for my Performance Tuning for Pirates presentation. You can download the slides, check out the reference material and videos … Continue reading

#TSQL2Day – A Day in the Life of A Service DBA

Today I am excited to join in with my #sqlfamily and participate in this months #tsql2day throw down. This month Erin Stellato is the king pin and her topic is “A day in the Life.” This gives me a great opportunity to explain … Continue reading

Stress Testing Stored Procedures with Free Tools

I currently have a presentation named Performance Tuning for Pirates. This presentation goes over using several free tools to help you with your performance tuning process. Today, I am happy to share my first video going over these tools. Using … Continue reading

First SQL Server UG Meeting in Harrisburg, PA

If you work with SQL Server and live in the Harrisburg area I have some great news for you. The newest SQLPASS User Group has been born in your neck of the woods. The Central PA SQL Server User Group … Continue reading

Powershell for SQL Server DBA’s

Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an … Continue reading

Let’s Meetup [Updated]!

I have a confession to make. I like to meet people who also work with SQL Server. There are so many different ways to use SQL Server. I love to hear how people are using it differently than me.  One … Continue reading