Category Archives: SQL Server MVP

Interview with Warwick Rudd



Part of traveling to various events and being a part of the SQL Community means one can meet some pretty awesome professionals. I was fortunate enough to run into Warwick Rudd (B|T) at one of the PASS Summit events held in Seattle, and he definitely lives up to all the hype.

Warwick is a SQL Server MVP, Microsoft Certified Master – SQL 2008, MCT, Founder and Principal Consultant at SQL Masters Consulting. He’s definitely an avid blogger, talented speaker, and a leader in our SQL Community.

After PASS Summit 2015 we kicked an idea around about getting something like this going where we could share a few questions and answers; the timing finally aligned right and well, without further ado:

  • How did  you get your start in working with SQL Server?

I was working as a UNIX scripting developer on an in house created scripting language. The company had a couple of web developers who had installed SQL Server 6.5 and the company needed someone to look after the SQL server environment. I moved in with the oracle DBA’s as there were no SQL server DBA’s and my first training course was delivered by Greg Low. Look where things have led me to now?

  • If there was another occupation you could see yourself doing what would it be and why?

Physiotherapy – I have played  a lot of sports and some to a very high level. Sports and sports remediation I find interesting and just naturally enjoy learning about it.

  • Being in technology we do play some pranks on our fellow colleagues. What is one that you are willing to share, that you have done in your past?

I was working in a bank and at the time we actually did not have pc’s but dumb terminals. We disconnected the keyboard and put sticky tape over the connection before seating the connection back just enough to make it look as though it was plugged in to pass initial inspection of why the keyboard was not working.

  • Where is one place that you would love to speak at someday (conference, SQL Saturday, event, etc.)?

Ha-ha this is a tough one as there are so many different things to take into consideration. But I guess I would love to speak at SQL Saturday in Colorado if it was ever available in winter as I love being in the snow and snowboarding – I would then get to do 2 things I enjoy. There are some bigger events, if I ever got the opportunity to speak at, that would be so humbling to be selected for, but I will keep those close to my chest so as to not jinx myself 🙂

  • For those out there that have not heard of SQL Community, what would you say in 3 words describes SQL Community?

Friendly, Supportive, Intelligent

Big thanks to Warwick for allowing us to take a glimpse into some of his thoughts. If you are ever at an event make sure you stop by and say hi to him; just a stellar individual.

Dashboard Time

AutomationI was fortunate enough to attend the PASS 2011 Summit in Seattle. If you do not know what I am speaking of when I say PASS I encourage you to check it out. PASS stands for Professional Association for SQL Server. The event that is put on yearly speaks for itself and I can dedicate a whole blog to just that but no; I’m going to speak of something I picked up while at the conference.

SQL Server MVP – Deep Dives Vol 2

This book has a plethora of valuable information and golden nuggets so much so I figured I’d implement something on my own that I can use everyday from it. There are countless number of good authors in this book

The Dashboard

I’m on a team that runs a full range of SQL servers from 2000 to 2012 on physical and VM’s, but chapter 12 stood out to me the other day which I decided to tried out. I’ve built reports and metrics in the Utility Database (idea spawned in my head after attending a session by Chris Shaw (B|T) but I started thinking of building a dashboard off the information.

Pawel Potasinski (B|T) wrote a chapter in this book called “Build your own SQL Server 2008 performance dashboard” – as I read through the chapter ideas started to spin in my head and before I knew it I was giving it a try.

I combined some of his ideas with the metrics I pull back using Glenn Berry’s (B|T) Diagnostic Queries and built a standard dashboard for myself that gets generated every morning when I walk in the door. In it I include some of the basics such as CPU, PLE, %Log Used. Pawel uses DMV’s and SQLCLR to get the performance counters; I’ve started to incorporate some extended events results in there as well.

Some additional items I’ll be incorporating in the near future is further drill downs into the details of the counters themselves and sharing the report out to the team I am on as a custom report. Once I have everything completed my plan is to make another post entry with the screen shots, code, etc.

In the end I would say I was not fully taking advantage of what SQL Server has to offer for me….are you? I’ve enjoyed digging further into Reporting Services and what I can leverage from it in administering databases I’m responsible for. Take a look at what your processes are and if it isn’t automated how can you better leverage your time and can it be automated?

The Microsoft SQL Server MVP

What is an MVP?

For myself growing up in the realm of sports through high school and college an MVP is a most valuable player. In general an MVP is recognized in his area or field, an honor bestowed on him or her that distinguishes them as being recognized by their peers.

What is a SQL MVP

This carries over for me from my statement above on what an MVP is. I have friends that are SQL MVP’s and some friends that aren’t. Microsoft’s SQL MVP program recognizes individuals who make exceptional contributions to technical communities, sharing their passion, knowledge, etc.


No, I am not currently a SQL MVP and this is where my thought and blog really comes to life and the purpose for the post. As I stated before I have several friends who are SQL MVP’s and a lot who aren’t. One who is not approached me the other day via phone and I could tell something was bothering them. After some inquiring I discovered that the person was clearly upset that they did not have an MVP title next to their name so much so that they disclosed they were going to stop writing, being involved in the SQL Community etc.

The Outlook

I have mad respect for all of the current SQL MVP’s that are available to the community and the efforts that they put forth day in and day out; they are examples to me of what hard work and diligence can achieve in the profession and I hope one day I can become one; but I also want to share a different point of view to other fellow SQL Server Professionals. The SQL Community is just that a community of individual professionals that provide a knowledge base like no other. I implore the individuals who like my friend, basically was going to throw the towel in to keep working hard.

I once was told by my coach “Attitude – what you or I feel or think about something or somebody”. What’s your attitude today? Are you making a difference? Are you helping your co-workers? Are you continually learning to make yourself better? Do you want to me a game changer?

Somewhere somebody will always be practicing, learning, fine-tuning their skills – what will you be doing? Let’s get in the game, stay in the game, and while we are at it we might as well have some fun with it. All the other stuff will fall into place in due time, give 110% every time out.