Category Archives: Uncategorized

Pass Summit 2017

It’s about that time of year again when there is a buzz in Seattle in regards to PASS Summit. Many data professionals will be heading out to one of the biggest SQL related events of the year. There is excitement for many along with a sense of being overwhelmed for some. The minute you step off that plane, bus, car, etc. you are immediately geared up for the unknown. Guess what – enjoy the ride!

This year due to previous business engagements scheduled I will not be attending; however, I will be there at times virtually along with social media. I will miss seeing many of my friends from around the globe; however, this post isn’t about that. Why? Because I know I will see everyone again real soon somewhere down the line and even back at the event in 2018. Instead, here are some tidbits for you, dear reader, that may help you along your journey in the upcoming week.

Network

That’s right, you will find yourself among the best speakers in the world, thousands of your closest friends, and a plethora of vendors. I encourage you to step out of your comfort zone and mingle around; talk to someone you don’t know. Spend some time at the vendor booths learning about the various products that may help you in the future.

Sessions

img_20161026_103752In reviewing all the sessions, yes I still review them even if I am not there, there are so many good ones to choose from. You will hear many people say they can’t see all the ones they want to – that’s okay as well. Attend the ones that you feel will help you the most; you can always check into purchasing the recordings while you are there or even after the event. Just soak it all in, ask a question yet be respectful.

Speakers

IMG_20161025_092017_01.jpgYou will find yourself immersed with speakers from all over the globe; some of the most talented individuals and data professionals we have in the community. Please provide feedback for the speakers for the sessions you are in. Believe it or not, it helps speakers hone their craft. How do I know, because I am one and it has helped me. Also, please be respectful of time.

After Events

fileThere will be events after the sessions are done for the day. Enjoy yourself, but do remember it is okay to network with others at these things. One of the highlights I’ve read so far is the mentor program this year. Truly stoked to see that happening. I remember last year when I was able to help Steve Jones and Andy Warren pair up people for their event to help plug people in. Seeing the smiling faces and knowing that they were excited to meet others said a lot.

First Time Ribbons

If you see a first-time ribbon don’t just run by. In the past events, I’ve made a point to go up to people and introduce myself and ask how they are doing. If you remember your first time attending the PASS Summit then you can relate to how overwhelming it can be. I remember Andy Leonard and Mike Walsh invested time in me early on when I attended and it made a world of difference in my life. You be that impact player for someone else.

Volunteers

img_20161025_074203You may not notice the volunteers as you are rushing up the escalators at the convention center. Take a second and a breath and if you see one of the many volunteers working the event stop and say THANK YOU. You will be surprised at how others may be having a bad day and a simple thank you for what they are doing will change their outlook for the day. No seriously, try it.

Community Zone

img_20161026_074256As you go toward the food one (it’s what I call it; where you go eat at the convention center) you will come upon the community zone. It is there you will find all kinds of community members hanging out. Go up and get to know some of the members. You’ll find a wide range of people there from organizers, speakers, etc. Hang out a bit and get to know some of your fellow data professionals

Key Notes

img_20161026_093230There will be morning keynote sessions before the day gets started. I encourage you to attend these; there is a lot of valuable information that comes out of these. Yes, I know there will be some late nights, but I do encourage you to do your best to get to these. Fantastic speakers with a fantastic message. I’ve been blessed to live blog the keynotes for the past 2-3 years. Each time presents new and exciting messages to be heard.

Summary

Again, I will miss everything about PASS Summit this year. Personally what has started off as an eager data professional has turned into much more. I deeply care about the event and everything it entails. Walking through the vendor areas talking with old friends, to spending time at the after events catching up. Or the one-off conversations in the halls – some of those have impacted me more than anything.

If you don’t catch anything I’ve said thus far, then please, listen to this. Enjoy yourself, learn as much as you can, and maybe…just maybe the PASS Summit will mean a bit more to you than when you first got there this year. Until we meet again down the road my friends ~ Take care and Let’s Roll.

img_20161031_124917

Advertisements

Thank You–#PASSElections

This week has been a whirlwind; as the results came in earlier this week on the election I wanted to take a moment and say Thank You. It is with great honor and privilege to be elected to a seat on the PASS Board.

This position is one that I don’t take lightly and with it, I will strive to do the best I can for you (us, community). I do want to take a moment and thank all those that ran for board positions. I applaud and am in awe of their tireless efforts in the community.

Thanks again for all the support and messages the community has shown me. Will only make one promise and that is to give my best effort every day to make our community the best it can be. I look forward to meeting and speaking to many of you in the near future.

Running for the PASS Board of Directors #PASSelections

Someday_20564This year I decided to take “someday” to heart and do something that has been on my mind for awhile – submit my application to run for the PASS Board. Going through the process so far has been a humbling experience; one that I’ve learned a lot from. I’m excited to say that my application was accepted and with that this is my formal announcement and the beginning of my campaign for election.

You may ask who is Chris Yates and why is he running? By the end of this post, my goal is to answer that question for you. I am a by product of what PASS can do for you as a data professional. There are so many stories that people have shared who have had similar experiences such as mine. My first time I heard of PASS was in 2011; it is then I was afforded the opportunity to attend my first PASS Summit – information overload ensued! Unknown to me at the time it was the foundation being laid for the journey to arrive at this day.

The Question – Who Is Chris Yates?

Well, that’s easy enough. I’m a 17-year vet of SQL server who views his job as, well not a job. I work for a stellar company in Republic Bank located in Louisville, KY. It is there where my first break with PASS was given to me. I help John Morehouse run the local Louisville SQL and Power BI user group along with helping co-organize the local SQL Saturday event here with Malathi Mahadevan, John Morehouse, and many volunteers. I enjoy helping others succeed and leadership is a strong passion of mine to which I’ve dedicated time to leading a Center of Excellence initiative around leadership for our IT folk at the shop.

You can read plenty more over on my bio page on PASS’s web site located here.

You can view candidates rankings here

The Why?

So this is the meat of this post – the why? Chris, why now. Listen, earlier I mentioned that I’m a by product of what PASS can do for someone and their career. I’ve been blessed and fortunate in my career and more so over the past six years since PASS and I got to know each other. I want others to experience that same success and want to continue to help lead PASS to many more successful years.

PASS is the people, it is the networking at events from big to small, it is staying ahead of the curve that will provide and give our members the edge in their data professional careers. If you’ve been around me long enough then you’ve heard me say over and over again that if we just reach one it’s worth it; I truly believe that. For me it was a guy by the name of Chris Shaw who decided to take a chance on me and become my very first mentor after that 2011 PASS Summit – that is PASS. It is the one off conversations you have at events, email, phone calls in helping each other to learn – that is PASS.

There are plenty of Chris Yates’ out there who are still looking for something and don’t know about PASS. It’s time to step up to the plate and pay it forward like so many before me.

So What Do You Bring to the Table?

I’m not perfect; never will claim to be. If you come here looking for that then it is time to move on. Heck, I’m not even going to make promises that I won’t be able to keep. What I can tell you is this; each candidate running for this board is more than qualified. I’d even go as far as to say I would support all of them if I could. I can tell you that I have a passion for seeing this community succeed, and seeing PASS succeed. I will attack it like I do everything else and give it 110%; at the end of the day, there will be nothing left on the table and nothing left in the tank. Along with the passion and effort; I will tap into my previous board experiences along with being cognizant of my grass roots mentality. I truly believe that we can make an impact anywhere at anytime. Doesn’t have to be at an event; nor does it have to be on a call. Each one of us can impact someone’s life both as a data professional and on a personal level. This will be one epic ride and I ask that you take that journey with me.

Summary

There will be no “what if’s” nor will there be no looking for that someday. That someday came knocking on the door and I’m ready to answer that call and step through it hoping to make a difference for all you and our community. Whatever the outcome may be when this is all said and done; know one thing. The people make up PASS and without you (us) we couldn’t do what we set out to do on a daily basis – help each other to connect, share, and learn. If elected; I’ll give you all I got.

Now whether you vote for me or one of the other candidates I implore you to go vote; what you are doing is helping shape the future of the PASS organization.

To all the other candidates running; it’s truly an honor to share this stage with you. Thank you for laying it out on the line and accepting the call.

My name is Chris Yates and I’m running for the PASS BoD – for more information please go and visit here

Personal Ownership–The Vision Within

vision-imageIt has been said that the very essence of leadership is that you have a vision. It has to be a vision you can articulate clearly and precisely on any occasion. There is a vast difference between a person that has a vision and what is called a visionary person. Think of it in this manner:

  • A person with a vision talks little but does much.
  • A visionary person does little but talks much.
  • A person with a vision finds strength from inner convictions.
  • A visionary person finds strength from outward conditions.
  • A person with vision continues when problems arise.
  • A visionary person quits when the road becomes difficult.

Some of my personal experiences have taught me the following:

  • The credibility of a vision is determined by the leader.
  • The acceptance of a vision is determined by the timing of its presentation.
  • The value of the vision is determined by the energy and direction it gives.
  • The evaluation of a vision is determined by the commitment we the people have.
  • The success of a vision is determined by its ownership by both the leader and the people.

Take a look around you; what is happening to others

A good idea can become great when the people are ready. The data professional who is impatient with people can become defective in their leadership. The evidence of strength lies not all the time in blazing a trail ahead but instead adopting our stride at a slower pace while not forfeiting the end goal. If you run too far ahead then you run the risk of losing your power to influence.

The ability to decipher the big picture

The ability to decipher the big picture is oftentimes what separates leaders. They are concerned with the shop’s basic purpose of why it exists and what it should achieve. Some things to think about that may hinder a vision:

  • Limited Leaders – everything rises and falls on leadership.
  • Concrete Thinkers – see things as they are and say why?
  • Dogmatic Talkers – to be absolutely sure about something one must either know everything or nothing about the problem. At times knows nothing but conventionally says something.
  • Continual Failure– many people look at past failures and fear the risk of pursuing future visions.
  • Satisfied Sitters – people who strive for comfort which sits on the heels of complacency, predictability, and boredom.
  • Census Takers – some people are never comfortable stepping out of the crowd.
  • Problem Receivers – some people can see a problem in every solution.
  • Self-Seekers – people who live for themselves.
  • Failure Forecasters – extract only discord; outlook is always gloomy and times are always bad.

Summary:

Spend some time and think about the dreams and vision you have as a data professional. Whether you are in an organization or a consultant I challenge you to consider the following:

Refuse to accept failure with self-worth.

Don’t restrict thinking to established, rigid patterns.

See the big picture.

Welcome challenge with optimism

Don’t waste time in unproductive thinking.

Can a Data Professional Be Organized?

Organization“One of the advantages of being disorderly is that one is constantly making exciting discoveries.”  While this quote is true it is often times too late to act on an opportunity therefore it is missed. If you are a leader at your respective shop it can then be conceived that you are somewhat out of control.

Becoming a bit more organized in your day will allow you to have priorities that are clear in your mind and can help you orchestrate complex events with a masterful touch. You can transition smoothly from one project to the next without wasting motions. People will begin to believe the promises you make because you are following through on them. When you enter a meeting you are prepared for it and when you show that hand of knowing the topic ~ well it pays off.

It might sound funny, but I run into a lot of data professionals who are and are not organized. I get it; it happens to everyone – but if you are interested in taking steps to become organized below are some thoughts that may help you on your journey.

Set Your Priorities

Sounds easy enough? Two things that are difficult to get people to do. The first is to do things in order of importance, and the second being continuing to do the things in order of importance. Try listing out all your major responsibilities according to importance and time needed to accomplish those tasks. This will become the gauge to help keep you on track and keep moving forward. Perhaps start with a monthly checklist.

Place Priorities In Your Calendar

Place this list in a prominent area such as your calendar. You could also share this list with a trusted resource for accountability sake pending on the nature of the item.

Allow Time For The Unexpected

We all know that things will come up; that is inevitable. Based on your role as a data professional you can build in additional time to the priorities that need to be accomplished.

Do Projects One At A Time

A feeling of being overwhelmed is the result of too many projects that are clamoring for your attention. If this is something that happens to you then maybe try some of the following:

  • Itemize all that needs to be completed.
  • Prioritize things in order of importance.
  • Organize each project that suits you such as a folder.
  • Emphasize only one project at a time.

Work According To Your Temperament

If you are a morning person, then schedule time in the morning to be most effective; if you are a late starter then do the opposite. Whichever holds true, be sure to not allow the weaknesses of your temperament excuse you from what you know you need to do to work most effectively.

Use Your Driving Or Travel Time for Light Work And Growth

I was given some great advice a long time ago. Whether you ride the subway or drive the car use this time to reflect on your thoughts. I have several friends for instance who, while on the subway, knock out tasks or read a book that continues their growth process as a data professional. No, I’m not saying never turn on the radio for a jam session, but I am saying you may find some useful time on the drive in to the office.

Develop Systems That Work For You

Whether you utilize your phone, computer, calendar, or writing tasks down – all of these are there to help you do things better and quicker. By improving them, you can decrease your expenses and increase your results. Don’t fight the systems; instead improve upon them. Remember, you are the CEO of your journey.

Always Plan For Those Minutes Between Meetings

I find myself in meetings constantly. That can be both good and bad. Hours can be saved by making the best use of minutes in between meetings. I try to keep a list of things to do that can be done anywhere in a very short amount of time. Keep handy a list of things you can do in a short time such as:

  • Email reply.
  • Call to make.
  • Thank you note to jot down.

Focus On Results, Not The Activity

Doing things right versus doing the right things? Focus on doing the right things and what is truly important. Welcome responsibility and be responsible for who you are. It is often rare to find a person who will be responsible, who will follow through correctly and finish the job. An old boss of mine once told me the following:

“I am only one, but still I am one. I cannot do everything, but I can do something; and because I cannot do everything I will not refuse to do the something that I can do”

Summary

Whatever the case may be take steps to improving yourself along your journey and look for ways to help improve efficiency on your day-to-day processes. These items mentioned are just to provoke your thought process; not something that is or should be a standard for you. If you’re struggling; maybe try some of them out and see how it works for you. Don’t expect more from others than you expect from yourself. Get after it and let’s get it done.

SQL Doc by RedGate

SQL DocI recently was on a call where a technical unit indicated they did not receive any form of documentation around the vendor database that was created. Now, seeing that I fall into the database profession it sparked my fancy. I began to ask a few questions to the individual who was asking for this documentation; these are important questions in that you have to determine if there is a need for what was running through my mind. Sure enough, the technical team, was just needing some guidance on overall structure and what they were dealing with in terms of tables, procedures, and so on. This group was trying to review and write a process around information they were not privy to.

My mind went straight for the SQL Doc utility that RedGate has available. It’s a simple utility really to utilize and often times can save the day for such cases like the one above. Check out the steps below on how easy the utility allows you to document a database on the fly:

Step 1: As you open the application you will be prompted to enter a server location followed by how you’d like to connect to it (Windows or SQL authentication). In this case we’ll just hook up to a local instance I have on hand.

image

Step 2: Once connected you’ll have some default settings. There will be a cover page option along with the databases that you want to document.

image

Step 3: Looking at the project you’ll begin to review some of the following information:

  • Database Selection
  • Server Properties
  • Server Settings
  • Advanced Server Settings
  • Sections that are included in the report

For this specific test I’m just going to take a look at the TempDB

image

The screen capture will note that under Object Types you are able to drill into and get as granular as you can. The below example will show you a snippet from a table in the TempDB and will also show that you can enter a description of what the field is utilized for in the far right hand column under Description.

image

Step 4: If you have to save this documentation out for any meetings or other purposes you can create a cover letter along with any logo information and description. Simply click on the cover page option on the left menu and complete the following:

image

Step 5: After all the choices are made you can click on the General Documentation Go button on the menu and be prompted for the following:

image

image

Give the location and file a name and BOOM; you’re done.

Summary

You may find yourself in a situation where you are needing a quick hit for documentation purposes. If you are an avid RedGate user and enjoy using their SQL Doc product; or maybe you had this product and didn’t even know what it was then you can benefit greatly from documenting multiple databases in a matter of minutes. This post is to show you what type of utility SQL Doc is and what it can actually be used for in a real life circumstance. In the end it was the right product and right time to use it for a technical team in need. Well done RedGate, well done.

Integrity–A Key Ingredient to Leadership

IntegrityWhen I have the opportunities to speak, whether local or elsewhere, on leadership I am often asked what are some things that make up a good leader? Over the years one very common word keeps coming up ~ integrity. It is a small word with a big meaning; if you were to pull up a dictionary integrity is defined as, “the state of being complete, unified.” When one has this ingredient their words and deeds match up; meaning they are who they say they are no matter where they are or who they are with.

This ingredient seems to be vanishing where personal standards are crumbling with data professionals in hot pursuit of finding shortcuts to success. Integrity is not what we do so much as who we are, and who we are often determines what we do. Our system of values is so much a part of us that we cannot separate it from ourselves. It is a navigational system so to speak that guides us. We often struggle in our respective shops with situations that demand our decisions between what we want to do and what we ought to do. Integrity establishes those ground rules for resolving such occasions.

Below are some traits that I believe derive from Integrity:

  • Integrity builds trust.
  • Integrity has high influence value.
  • Integrity facilitates high standards.
  • Integrity results in a solid reputation, not just image.
  • Integrity means living it myself.
  • Integrity helps a leader be credible, not just deemed clever.
  • Integrity is a hard-won achievement.

All the above are not given factors in everyone’s life. It is as result of self-discipline, inner trust, hard work, and a decision to be relentlessly honest in all situations.

Summary

Think about the situations as a data professional that you find yourself in. Begin asking the question am I taking a shortcut in order to get to success? Will that security permission not mean anything if I give it now and let another data professional handle the fall out at a later time? Or maybe you are a leader at your shop, is it something that you would sell a team or colleague out to get ahead. Whatever the case may be I urge you to take a long look at what your leadership looks like in your current role. Everyone influences someone in some form or fashion, will you have this key ingredient that is called integrity?