Tag Archives: SQL Community

Interview with Warwick Rudd

The Next Chapter ~ A SQL Journey

The past five years have been nothing short of an amazing ride on this thing we call “The SQL Journey”. I never cease to be amazed by the many outstanding data professionals we have in the PASS community.

For me, this ride has been a great learning experience. In addition, I am very thankful for the sacrifice of time that Chris Shaw (B|T) made in my behalf so many years ago. He was kind enough to take a willingly motivated individual under his wing and show him the ropes. He could have very easily said that he didn’t have the time. But the willingness that he expressed epitomizes what I have come to appreciate and expect from the SQL Family.

Along this journey I’ve witnessed a “closeness” rarely experienced in other communities.

A group rallies around someone in need, searching for an answer to their problems.

Fund raisers are organized for causes that benefit the individuals.

Intimate conversations are encouraged between peers – especially at large events and major conferences.

Words of experience and wisdom are freely exchanged when real-world battles make the road difficult.

These continual acts of kindness and sacrifice often leave me in awe.

It is not a perfect journey. It is not always an easy journey. And I have yet to see a bed of roses along the way. But my, oh my, it can be a rewarding journey. The fruits of knowledge, friendship, bridging of gaps, experience, and opportunities are priceless.

Given my current position at “the shop”, leadership has been on my mind a lot lately. Along with having aspirations in the SQL community, these are some important traits that I hold close to the heart:

Authenticity
Integrity
Concern
Restraint
Humility

At the same time, I strive to gain and exhibit:

Confidence
Vision
Composure
Resonance
Practical Wisdom

With these things in mind, I am today pleased to announce that I, along with my good friend John Morehouse (B|T), will be serving as Co-Chapter Leads for the Louisville SQL User Group. John and I were introduced to each other by Chris Shaw, and his influence has been tightly intertwined with our respective journeys since their beginnings. Little did I know, after a simple handshake at a PASS Summit, John would someday move to Louisville and a new friendship be forged. I will go to battle with John on any day, at any time, and anywhere, and I look forward to what the future will hold.

I do appreciate all of the hard work that Dave Fackler (B|T) has put into this community. While he is a stellar data professional in his own right, he has also helped to provide us locally with an avenue of opportunity and growth. Ideals to which he has been dedicated. It is my primary desire to help cultivate our local user base. To bringing forth new leaders, new innovators, and new SQL family members.

For those that know me, I have a reputation for using this saying … “Let’s roll.”

So, without further ado…Let’s roll.

Time Management–Leadership

1 Reply

To many times data professionals flounder in what some call a pool of uncertainty. The countless tasks, tickets, projects, and emails that may flow in without prioritizing will leave individuals searching for what is needed to be worked on now.

Organize or Agonize

Face it, we all influence someone. Whether you are a sole DBA out in the field or a leader of many there will be times when one will have some form of influence. There will be times when a data professional needs to juggle a multitude of tasks; being a leader in this area is key – either you organize or you will agonize over what all has to be done.

Here are some tips in how to organize and become better at time management:

High Importance / High Urgency – tackle these projects first
High Importance / Low Urgency – set deadlines around completion dates and work these into your daily routine
Low Importance / High Urgency – find quick and efficient ways to get this work completed without much personal involvement
Low Importance / Low Urgency – this is busy or repetitive work (think about automation if possible)

Too Many Priorities Can Paralyze You

The papers on the task keep growing, emails keep coming in, automated jobs are failing, on call is ringing off the hook, and you suddenly get that “frozen feeling” of what in the world am I going to do? If you’ve been in this business long enough than you know what I am talking about. If you are feeling this way go ahead and get the tasks organized then approach your boss about how best to approach them and what their advice may be. True leaders want to help their employees as much as they can and this is one of the areas that all of us can work on. All good leaders have learned to say no to the good and yes to the best, and one of the keys to success is keeping that line of communication open with your boss.

Monica Rathbun (B|T) has a great post on The Shield. I suggest after you finish reading this post you go check hers out; a superb written post that provides insight into a lone DBA’s world.

Leader or Follower

A person is either an initiator or a reactor when it comes to planning. In my past dealings I’ve found that these hold true; note the difference:

Reactors

React
Listen and wait for the phone to ring
Spend time living day-to-day reacting to issues
Fill the calendar by requests
Spend time with people

Leaders

Initiate
Lead; pick up the phone and make contact with people
Spend time planning and anticipate problems
Invest time with people
Fill their calendar by priorities

Often times we see that when people lack ownership of an idea, they usually are hesitant to change. It affects routine, causes a disruption, and at times creates fear of the unknown. Uncharted territories cause insecurities to rise; four important cycles that will stand out around effective change are create, conserve, criticize, and change.

As a data professional there will be times when you are faced with bringing about change; here is a checklist that you may be able to garner some ideas from and assist you in helping you to bring forth implementing or requesting changes.

Will this change benefit others?
Is this change compatible with the purpose of the organization?
Is this change specific and clear?
Is it possible to test this change before making a total commitment to it?
Are physical, financial, and human resources available to make this change (what else is on the plate?)
Is this change reversible?
Is this change the next obvious step?
Does this change have both short and long-term benefits?
Is the leadership capable of bringing about this change?
Is the timing right?

The wrong decision at the wrong time = disaster

The wrong decision as the right time = mistake

The right decision at the wrong time = unacceptable

The right decision at the right time = success

Closing Thoughts

The above are methods that I’ve picked up over the years that have helped me not only become a better data professional, but a leader. I’ll leave you with a few insights into what a solid foundation could be built on; it will be up to you to become the leader that you want to be; along with honing in your time management skills.

The definition of leadership is influence.

The key to leadership is priorities.

The most important part of leadership is integrity.

The most ultimate test of leadership is creating positive change.

An extra plus in leadership is attitude.

What is your most appreciable asset – people.

The indispensable quality of leadership is vision.

The price tag of leadership is self-discipline.

May we never lose sight or focus of our dreams and goals. Obstacles will occur, but they are just that obstacles with solutions waiting to be had. Take the hard knocks as lessons that can be learned. There will be many, life’s journey is full of them – what kind of impact will you have?

Reflections and Looking Forward

Community Involvement–Why Wait?

1 Reply

Everyone has a story; some stories are similar while some stories are vastly different. People always make the statement that you shouldn’t “assume” because if you do….well then you know what happens!

I will go out on a limb and gather to say that many fall into the category I did when it comes to the SQL community. From the years 2000-2010 I had no clue that the SQL community existed yet alone any conferences. It was when I was hired on at my current shop did I learn of this thing they called PASS Summit.

From 2011- to present I can honestly say it has been one heck of a ride. A lot has transpired over the course of soon to be 5 years and I’m thankful for it; I wouldn’t change a thing. I look back at those first 10 years and I was floundering – man o man was I floundering. What that time means to me now though is a light into the future and to know where, as a data professional, a direction I want to go in.

I’m starting to get asked more and more the question of “What can I do to get involved within the SQL community?” or “I’m not good enough to get involved”.

My answer to that is simple, let’s roll. Below are five avenues in which you can get started with community involvement. All they require are you; yes that’s right you to take the initiative and get involved.

Blogging

I can tell you that blogging was not an easy thing for me to get started on but has been well worth it. I’m not the most talented writer; nor am I one of the most captivating individuals you will ever meet. What I do feel that I can bring to the table is real world life examples that have helped me along my way in my SQL journey, and guess what – you can be the same. Some things to keep in mind when starting out to blog are:

1. Don’t beat yourself up if you start to write, but have mental blocks.

2. Get a few blog posts in the pipeline and scheduled to help get your feet wet.

3. Find a good platform; there are several out there such as WordPress.

4. If writing examples; then prove your examples. Don’t just write to be writing. Have a point prepared.

5. If you reference someone’s work then give credit where credit is due. This is a huge pet peeve of mine.

Social Media

In this day and age it is almost impossible to not be connected through some form of social media. You can find many groups, hash tags, companies to follow, and other viable sources to become involved with. Some different types are:

1. Twitter – pay attention to hash tags such as #sqlfamily, #sqlserver, #tsql2sday, #sqlhelp

2. LinkedIn

3. Facebook

4. Instagram

One caveat I want to add here is be professional; companies do look at your involvement.

PASS Active Member

Become an active member in PASS; it doesn’t cost you anything and can provide various forms of volunteering. This type of involvement has changed my career allowing me to see on a more global scale of how impactful our SQL community can be.

Learn more about the PASS Summit here.

SQL Saturday Events

These events are free. Let me ask you this; does your company not want to provide you with any training; or better yet maybe they do and just don’t know how. These events are free except for lunches and has some very talented speakers that attend. Take advantage of these; you can get a current listing on my blog here or go visit SQL Saturday’s home page here for further information.

Mentor

Maybe you have been in the community for a while and it has become stale. One idea would be to mentor someone; doesn’t have to be someone in a different state; how about someone you work with that is needing help. Do you remember when you started out? I sure do and I would have loved to have some guidance and help earlier on in my career. Five years ago I was fortunate to learn and model some of my ways from a group I called my “fab five” – give them a read here; truly thankful for these individuals.

Mentoring someone ignites the passion to keep those knowledge juices flowing; each one reach one effect.

Recap

I’ve come to learn through my 5 years of involvement with the SQL community that it is not always a bed of roses and flying unicorns but SQL family is composed of not only some of the brightest minds in the business but also individuals who care for one another and who genuinely step in and help when needed.

So I ask you, why wait? How many years will you let go by like I did before you become involved? There has not been one day where I have regretted becoming involved within the SQL community and if you would like to talk more about how to get started let me know. I will be happy to discuss with you offline if need be.

It’s GameTime folks; Let’s roll and keep this community moving forward.

Impact Player Series – Part 1

Windows Functions; Who Knew?

1 Reply

SQL windows functions, it would seem, get lost in the shuffle most of the time when dealing with SQL. Why do you think that is? I honestly think that it is more or less developers, DBA’s, and data professionals are oblivious to some of the cool features that can be accomplished with its utilization. To put it simply windows functions could be viewed as looking in “windows” of your data. That is about as simple as an explanation as I received when I first started using these types of functions.

Example

Take the below table structure that I created on my local environment in SQL. My table name I created is called CustomerLog within that table I have two columns CustomerFirstName and CustomerLastName (represented below):

For example(s) sake lets say I have a vast amount of data in this customer table and I want to partition it out and view just how many (categories) or windows I am looking at. This is where the windows function comes in nicely. With the below query I can find the results I am looking for pretty quick and easy:

As you can garner with the above SQL windows function code you can derive how many customers share the same first letter in their name (result set below)

Bottom Line

As you go through the SQL journey note that with any aggregate function being used you can turn that into a windows function by utilizing the over clause. You can only use windows functions though within the select or order by clause. This example only showed you how to partition using windows functions and only scratched the surface. It would behoove you to do some more research on what all you can do with SQL and window functions. Also, while you are at it; check out some of my colleagues as well

Mickey Stuewe: A Date At The End of The Month

Jeffrey Verheul: Write readable and high-performance queries with Window Functions

Julie Koesmarno: ABC Classification With SQL Server Window Function

Don’t sell yourself short. I guarantee once you start utilizing windows functions you will want to use them everywhere. Just make sure you know the positives and negatives and as always just don’t blindly copy code from the net. Explore it, set something up on your Dev or VM sandbox. Failure to learn is not an option!

Success Is Journey Not A……

1 Reply

I’ve often heard the quote “Success is not a journey, but a destination”. Over the course of the last few weeks that quote has taken on a life like form in many fashions. To name a few things that have come to light to make this quote a very real thing are the MCM retiring, having a VMAX overloaded by maintenance plans across the board, upcoming DR Testing, planned Power outages (better than non planned ones eh!).

All these things as I look back on them screams to me that Success is a journey, not a destination. For SQL Data Professionals our jobs are ever changing and growing as we grow with it. Each day is an opportunity to learn something within SQL that you or I didn’t know yesterday, each day presents it’s own opportunities to reach resolutions that you or I didn’t know yesterday, and each day represents that during our failures we can discover the true desire for success.

To the beginner who is starting out who doesn’t know about the sp_configure, the proper use of ORDER BY, or what Table Scan vs. Indexing; the answer is not to just ignore or give up. Dig in and discover what that solution is; it’s how we learn.

To the seasoned SQL Data Professional vet who has been putting off getting on the speaking circuit, taking a newbie under your wing and mentoring them, or simply are just comfortable; challenge yourself. Step outside that normal box and tackle new things head on.

When you have that replication issue that goes awry and you don’t have that big enough wrench to fix it (I use this analogy all the time thanks to Robert Davis a.k.a. SQLSoldier (B|T), stay the course and work your way through it.

I get asked a lot of questions when speaking, email traffic etc., where individuals feel defeated in the problems they are facing within SQL. Every problem has a solution; every solution is waiting to be found it’s up to us as SQL Data Professionals to buckle down and find the answer.

If you are not active in the community I’ve listed some of what I call top tier SQL Data Professionals on the right of this blog site that I follow who have helped me in my DBA career. Forums are also a great place to increase ones learning…to name a few you can check out these:

One last note; when is the last time you just said a simple thanks to someone who has helped you in your career? This past week that has weighed on my mind greatly. A former boss, a mentor, a person who you get newsfeeds from…..I fall in the boat where I get wrapped up in the work I do; I often overlook the simple thank you that in reality goes a long way.

Tackle obstacles, Tackle your fears, and Tackle the solution head one.

Who Do I Follow? Where Do I Go?

4 Replies

There are many helpful sites within the SQL Community and several more blog sites that I follow. My favorites are noted on this site; however one that keeps drawing me back time and time again is by Brent Ozar’s group. For those of you who have not had the opportunity to check the site out I’ll lay out some real world specifics on what has helped me and how I have benefited from such sites as this one.

The Webcast’s

Every Tuesday I usually find my way to their 30 minute webcast for treating pain points within SQL (among other topics). At the end of each web cast, if time permits, they will host a quick question and answer session over the topic to viewers. Check out future webcast’s here

Two Important Free Tools

There are two scripts that have seemed to help me tremendously over the course of the year. One is sp_Blitz (comes with a SSMS custom report) which a new version just came out; and the other is sp_BlitzIndex. I recently just started to use the sp_BlitzIndex but I liking this little utility while the other sp_Blitz I use when hitting new or old servers, you know the ones that you stumble upon that no one knows about and no one has a clue of what it is doing. Two great free utilities that are offered that may just save your hide one day.

Popular Topics

I like the fact that on the site they keep a section for Popular Topics that are happening within the industry; keeps me up to date and provides insight on some of the issues I experience on a daily basis. Some topics you may find:

The Team

The team makeup of Brent, Kendra, Jeremiah, and Jes makes it an easy choice for me to have in my arsenal of following. I try to find people in the industry of whom I consider for myself top in the industry and learn from them and their techniques to help better myself and further gain more knowledge.

Check it out

If you haven’t already done so go check their site out and what their about. Real people providing real solutions with some fun along the way.

The Roundup – #TSQL2sday

2 Replies

Another T-SQL Tuesday has come and gone and I’ve got to admit that all the responses that were received are pretty awesome and even had a few responses from first timers that attended the PASS Summit 2012. While all the posts were great, I had one that blew me away and is exactly what the Community is about. Kendal Van Dyke allowed a post to be tied to his blog by Andy Levy who currently didn’t have a blog and is fairly new to SQL. If you get a chance check it out.

One theme that I read over and over again is that we are one huge family and we have each others backs. The Community has a whole goes out of their way to assist our fellow members. Below is the roundup from everyone who chimed in. Thanks everyone for their participation!

Remember if you are interested in hosting please contact Adam Machanic (B|T)

POSTS

Jason BrimHall – SQL Family – After Summit 2012 | SQL RNNR

Rob Farley – Rob Farley : SQL Community – stronger than ever

Aaron Bertrand – T-SQL Tuesday : Reflections on the PASS Summit and our community

Robert Davis – T-SQL Tuesday #36 – SQL Community | SQLSoldier

Chris Shaw – Esprit de Corps T-SQL Tuesday #36 « Chris Shaw’s Weblog

Valentino Vranken – BI: Beer Intelligence? · PASS Summit 2012: Impressions Of A First Timer

Steve Jones – T-SQL Tuesday #36 – What Does Community Mean? « Voice of the DBA

Oliver Asmus – T-SQL Tuesday #36 – What Does the SQL Community Mean To You? | OliverAsmus.com

Edwin Sarmiento – PASS Summit and The Value Of Building A Community

Wayne Sheffield – T-SQL Tuesday #36 – Community