Author Archives: Erik Disparti

About Erik Disparti

I started my IT career in 1999 and in January 2011 I became a SQL DBA. So far I'm loving every minute of it and learning more and more everyday.

This Ain’t your Mamma’s Tuning

I have tried to stay with one concurrent theme with my blogs. I have been writing about the best way to use SQL Server Default tools. Not to say I don’t believe or trust in third party vendor tools to help analyze your data. I think … Continue reading

Posted in Uncategorized | Leave a comment

Indifferent Performance

When you title your blog entry Indifferent Performance everything you write all of a sudden sticks. While the title is possibly catchy the way you explain it; is a classic battle between good vs. bad. We find this very thing in SQL Database Performance. There is … Continue reading

Posted in Uncategorized | 1 Comment

Application Overkill

Since I started in this trade one thing has always stood firm. Applications are slow, and will always be slow because we as a human society want results faster than they occurred yesterday. Which is funny because back in the … Continue reading

Posted in Uncategorized | Leave a comment

That’s So Lumberjack

In a post I made a few months back I was going to research three avenues of optimizing a database. The first was a custom script created to monitor blocking, and the second was running a SQL Profiler trace to monitor high usage … Continue reading

Posted in Uncategorized | Leave a comment

Qualities of Exceptional Employees

In the past two weeks I have seen these qualities pop up in two different sources. I believe these are all very valuable. While I do possess the qualities in number two (Please keep you jokes to a minimum) I think number two stinks, in reference to this … Continue reading

Posted in Uncategorized | Leave a comment

Carving Your Career

I’ve decided to take a week off my research and write about something we all think about, our career. I believe that your our current job is a vehicle for our career. Your vehicle will take you on an awesome road tip … Continue reading

Posted in Uncategorized | Leave a comment

SQL Server Monitoring Pt. 2 – Run a SQL Profiler trace during high usage hours

As my research continues I should point out that these tools are pretty sharp. SQL Profiler while not the sharpest ax in the tool box, it’s still a very powerful tool. There are numerous traces you can run to iron out the most simple problems. There are some … Continue reading

Posted in Uncategorized | 1 Comment