Hold The Fort

stressHave you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments that would cut off rations to fighting units. As the battle ensued the enemy had driven back their counterparts to a small area on a hill. They were being overwhelmed with many wounded and dying; that is until in the distance they noticed reinforcements were on the way.

How many times have you, as a data professional, been stuck wondering the same thing? Battered, worn down, and flat-out exhausted until you look and see reinforcements on the horizon. Sure, we’ve all been there, but to some it is a question of how do I call in re-enforcement’s or how do I even go about sending out a help signal? Below are some various ways you can tackle problems:

Forums

There are several forums out there that can provide some great insights into similar issues that you may be experiencing. To a certain extent I think forums are a great avenue to explore potential solutions. With that said however you cannot take every answer verbatim. There can be some off the wall answers out there that shouldn’t be followed. It is important to test anything you find on the web regardless of who it comes from.

You can find some of the forums I frequently attend here.

#sqlhelp

One thing that I’ve learned about the community is the willingness to help each other out. Remember above when I stated “Hold the fort, and reinforcements are on the way”; this is a good twitter hashtag to be familiar with. Professionals from all over the world take this seriously and it is not to be mistreated on how it is utilized. I have received great assistance in the past on issues I’ve been stuck with.

Phone a friend

We all have our “go to group” we bounce ideas off of. Sometimes it is helpful to bounce ideas off of another data professional. You may surprise yourself and actually start talking through your problem and come to an answer you may not have arrived to had you not initiated the conversation.

Old Fashion Testing

As a data professional you cannot be afraid to get your hands dirty. Prove your theories and test the scenarios as you run across them. One should be doing this anyway, but in doing so a wealth of knowledge gained is at your fingertips. We stop learning when we stop trying; just because you encounter one failure doesn’t mean you stop. You keep fighting and beating down that door until you make it through the other side. How bad do you want it?

Is It A Vendor Product?

I have the opportunity to work with a plethora of vendors. Maybe your issue revolves around a vendor product and you are not able to make any changes. Great, this happens all the time to data professionals. Some questions I’ll throw out there are:

  1. Have you opened a dialogue with the vendor about the issue?
  2. Have you documented the issue; not just call and say I have a problem?
  3. Have you tried to reproduce the error?
  4. It it already a known bug?
  5. Is it something that we can address internally before we talk with the vendor?

I’ve worked with a couple great vendors in Red Gate and SentryOne over the years. As a data professional I’ve seen vendors (not all) take pride in a quick response time. If there is an issue with a product they will want to take care of it in a swift manner or provide feedback as to why, when, and what to expect.

Internal Resources

I’m going to say this here, and it may shock some of you. No one knows everything; there may be some who elude or perpetuate appearances that they know everything there is to know,  but that is not the case. Whether you are in a shop or maybe a consultant (who can tap into their contact base) there are internal methods to maybe approach a different business unit or tech unit on an issue to get an outside perspective. Sometimes a fresh set of eyes goes a long way.

Technical Blogs

There are many great technical blogs out there; I have listed some in my DBA Blogs section to the right of this page. Each person is different and has their own go to Blog for review. I receive questions all the time from readers and other data professionals; being respectful is key but I have not seen one data professional out there who would not extend a helping hand if presented in a respectful manner. DO NOT TAKE this as one will provide an answer. We may show you how to connect the dots, but it is important one takes the necessary steps to get to the answer on their own. Nothing is given….work hard for it.

User Groups

Maybe your issue is not a hot ticket item and it can wait to a user group meeting. These are great places to bring up questions and issues in a local environment with some pretty stellar professionals. I guarantee that if you ask a question and no one knows the answer then someone will do their best to find out that answer and further the discussion. An example of a user group can be found here.

PASS Summit

Perhaps your issue is ongoing and you are at the PASS Summit. Great, besides being at a conference with over 6k of our closest friends I would take advantage of the SQLCat and AzureCat Team’s hours. It is a great way to tell Microsoft of your issues and get advice from some of the top-tier people in our industry.

Conclusion

I don’t know what your situation is or will be. Obstacles will come from all angles this year; it is up to us on how we deal with them. I would be amiss if I sat here and didn’t tell you that it won’t always be easy. Nothing in life is easy; some days you will have to work and grind your way through until you get to an answer for an issue. In the end though, when you do find that answer (and you will) you will be able to learn from it and move on. It is part of a data professionals journey.

Keep fighting and keep working toward your end goals. Never stop learning; never stop gaining knowledge.

Looking Back At 2016

lookingback2016When this blog started back in 2011 I had no idea that it would continue to grow to where it has gotten to today. There have been many learning curves along the way – some fun and some not so fun, but that is part of the journey.

Each year since inception this blog has steadily gained steam in terms of increased traffic each year ; so I am thankful for that. The SQL Professor was not started for that sole purpose though. Rather it was a place to keep my thoughts regarding issues, ideas I have or have ran across over a period of time, and to write about happenings in my own professional career. Getting feedback from, you the reader, is an added bonus. Receiving both good and bad comments and discussions is an integral piece in helping this blog to continue to morph and grow – a living document if you will.

I’m reminded often that while producing good content is key; it is also key to write about what you love and enjoy doing. SQL has been a big part of my professional career and I look forward to creating additional blog posts in that area. Another area that I’ve come to have a strong passion for is leadership. In 2017 I plan on perhaps producing a series on leadership and how it pertains to one’s career.

Looking Back

Nope; not doing that. While 2016 was a great ride professionally I want to set sights on 2017 and continue to hopefully make an impact.

Looking Ahead

In looking ahead there are several things on tap for 2017. Some of them are:

  • Continue to grow the User Group base here locally.
  • Continue to help and grow the SQL Saturday event here locally.
  • Expand speaking opportunities where it makes sense.
  • Continue to help as much as I can with the HA/DR virtual chapter.
  • Dive further into PASS and continue to help the organization that I’ve come to be strongly passionate about.
  • Continue to lead and build a strong DBA team here in the current shop (very talented individuals. Extremely blessed to have an outstanding team).
  • Build on leadership qualities.
  • Continue to do the best work I can for the SQL community.
  • Continue to build on new and existing relationships within the SQL community.

Expectations

Something that I’ve learned long ago is that we can’t make everyone happy regardless of how hard we try. Mistakes will happen, and events will occur – that is part of the journey. I said the other day that 2016 slapped me in the face on various fronts, but I’m still standing. While it is important to reflect on what lessons were learned in 2016; I also want to encourage you to look forward to 2017. Change, if you want it, starts from within. Will you take the first steps? Break out of your comfort zone and explore new heights.

Here is to a solid end of 2016, and to new beginnings/adventures in 2017 ~ Cheers.

The New PASS Logo and More

pass-core-logos-for-delivery-02Change is not always easy. In fact, change is hard.

“Change” is a word from which some people shy away, and it can hinder the daily life of quite a few of us. However, change doesn’t always have to be negative.

It was only a few months ago, as I sat at the blogger’s table at PASS Summit 2016, that Denise McInerney (b|t) made the announcement of a new logo being rolled out this coming year. I will admit that I was caught off guard. Not because of the change that is coming. But simply because the existing brand is the only one I have ever known.

The “analytical” person inside me begins to wonder what the new logo represents. I am starting to get what the organization is trying to accomplish by encompassing what PASS represents and the members therein.

Change also means that not everyone will be happy. I know this firsthand. When making decisions on a daily basis that may affect various types of business, it is near impossible to please everyone. However, it is more important to look at the end game and the various umbrellas that will now fall under PASS. One example is the new event for PASS BA. The hybrid or mixture of both brands, while the old is phased out, will take some time. That much is apparent. And I agree that any new type of events that fall under the oversight of PASS should have the new branding and logo. This just makes sense from an executive standpoint.

This change in branding will represent many adjustments in the upcoming year of 2017 – websites, logos, and much more. Embracing change…it is something not always easily attained. Nevertheless, it is something that must be given much thought as we move forward.

One thing I think, and I’m looking at myself in the mirror when I say this, is that what often gets overlooked is what goes on behind the scenes to even remotely pull something like this off. It is something that should be worth mentioning that the many hours that go on behind the scenes to traverse the waters such as this should be commended.

For more information on what the Old to New branding will represent you can visit here

For a short video on how PASS has progressed you can visit here

Together We Are PASS

A Data Professional’s Story – PASS Summit 2016

This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return from PASS Summit 2016. As I look at the long laundry list of “to do’s” to get completed in the office; this past PASS Summit reminded me to slow down and take a minute to breathe – to take it in so to speak.

The recap post you are about to read will be a bit different from my past ones; gone is the synchronous order of how each day went. Instead, this post will be more relaxed and share view points through my eyes on how I went through the conference in which I’ve come to have a strong passion for.

The Story

As you first come into Seattle it is very difficult not to see a lot of its natural beauty. It never ceases to amaze me when the plane flies past Mt. Rainier and the breath-taking views that it holds. I often wonder to myself what it must be like to be near something on such a grand scale. I remember back to my first PASS Summit when I would be in such a hurry to get to where I was going; I took things like this for grantednot anymore.

file

One thing I’ve come to thoroughly enjoy is noticing all the “first timer” ribbons. The look of excitement and overwhelming elation of knowledge that has been received all over their faces speaks volumes. If you are ever walking around and notice someone with this ribbon on please take a moment and see how their day is going; offer them some encouragement if needed. I was once in their shoes and I remember how I felt at my first conference.

img_20161026_103752

This year I had the pleasure of speaking at  SentryOne’s Boot Camp.  One thing is for certain; this shop knows their stuff and have a stellar crew in place to bring excellent products to the community. Some colleagues of mine (Monica Rathbun (b|t), John Morehouse (b|t), and Chris Wood (t) in the community shared how SentryOne has helped in our respective shops and businesses. I spend a lot of time in slide decks for my current work and this was no different; I had some slides made up and was planning on talking from the slide deck, but as I got up on stage I had a “change of heart moment”. I wanted to divert attention away from the slides and just have a heartfelt conversation with the attendees on what I felt was important. After initiating the “wave” in the crowd (yes folks Kevin Kline (b|t) was involved) we had a good talk and I was happy to be a part of it. Some better terms in being a part of the boot camp are thankful and blessed.

img_20161025_092017_01

The keynotes were nothing short of amazing. For the second year in a row I had the privilege of live blogging. It’s always fun to provide data professionals who are not able to attend an avenue to get the information from the conference. I did get a kick out of sitting next to Rob Farley (b|t). We’ve become friends over the years and always look forward to seeing him; not sure how he gets hand delivered coffee while live blogging, but then again – – it is Rob Farley.

img_20161026_093230

Speaking of friendships; a good friend reached out to me earlier in the week letting me know he’d be near by. After some going back and forth on timing I felt it was important to leave the conference and share some time with him. Tom Roush (b|t) has been an inspiration to many and he allowed me into his life a little bit that day. It was the first time I got to meet his wife Cindy in person; together all 3 of us were able to share a cup of coffee and just talk for about 30 minutes. This, to me, is what PASS is all about. I would have never had the opportunity to meet Tom several years ago had it not been for PASS and the mentality of Share, Connect, Learn. The PASS Summit is much more than just a technical conference; it is a people conference. It is a place where friendships are made, ideas our bounced off of each other, and a place to grow. Tom, here is to you buddy ~ cheers!

img_20161031_124917

Sponsors are huge at events like these; wouldn’t be able to put on a good show without them. As I walked through the vendor area my mind began to wonder just how many people each of these vendors have reached. If you look past all the swag and fluff you’ll find that these vendors are doing some phenomenal things for the community. I’ve already mentioned SentryOne above, but another one that has had a huge impact on me personally is RedGate. Yes, I am a Friend of RedGate and yes I utilize their products at the shop – one thing that stands out to me is their strong passion for the community in which they serve and have built a business for. I cannot go through and name every vendor, but from me to every one of you ~ I thank you.

img_20161026_145201

The conversations had this year were amazing. You’ll find these happening in one off’s all over the convention center, restaurants, hotel lobbies, etc. I’ve never been to a PASS Summit where I haven’t had a conversation that has either helped or inspired me. Mike Fal (b|t), Mike Walsh (b|t), Warwick Rudd (b|t), Wendy Pastrick (b|t), Tom Larock (b|t), TJ Belt (b|t), Tim Ford (b|t), and Steve Jones (b|t) had a huge impact on me this year. It’s humbling when individuals take time out of their day and just pull up a chair and talk. Investing in others is key; I’ve had a lot of people invest time in me; what am I going to do now? It’s time to invest in others the same way and build up another generation of data professionals.

img_20161026_074256

One aspect of the conference I was extremely pleased to help with was Steve Jones and Andy Warren’s idea for a networking dinner. I had spoken briefly to Steve prior the meetup as he was needing some hands to help. It was after the sessions had ended and we were to congregate in the lobby at the convention center. I didn’t know what all to expect; just knew that help was needed. What unfolded next was pretty amazing…..seeing people from all around coming up to talk about their interests and have the ability to meet new people. Saw a lot of “first timers” again and getting them paired up with 4-6 people in a group was something to behold. The event itself was very successful and hopefully if one person was reached or changed then it was all worth it. Nothing but respect for Steve and Andy, would gladly go into battle with either of them any day of the week and twice on Sunday.

img_20161028_205927_01

This year had a twist for me in that I was invited to eat lunch with Rimma Nehme, Mark Souza, and Mitra Azizirad from Microsoft. This opportunity, along with five other data professionals, was nothing short of amazing. A casual conversation over a myriad of topics on how we as data professionals relate to Microsoft at our respective shops. I could see quickly that we were in the midst of some great minds, and trying to be a sponge is an understatement.

img_20161026_165749

Another highlight was getting to see, as I was live blogging, Malathi Mahadevan (b|t) receive the PASSion Award for 2016. I’m a product of the hard work she has put in over the years. Her tenure has spanned a decade now here in the Louisville, or as we call the ‘ville. It has only been a few years since we have crossed paths; little did she know when she started down this path for SQL Community how big of an impact she would have. It’s an honor to serve along side her and a testament to what hard work can do; sticking with something through both good and hard times. Job well done and well deserved. You can read her blog on the award here.

mala

 

We were able to meet and send Karla Landrum (t) off with appreciation in the community zone. For those of you who don’t know Karla she has been a steadfast presence in PASS as a Community Evangelist. She has gone above and beyond in her tenure and from the many people who stopped by to wish her well it is obvious she has hugely impacted a lot of data professionals. No, this won’t be the last we hear from her, but here it to a job well done ~ cheers

img_20161027_133646

As the halls are emptied and we close up another successful PASS Summit I can only hope that the future remains bright. It is my understanding that we had a record crowd on hand this year; may we continue to build on what has been started. If I may leave one thought with you I will leave this (again my viewpoint and opinion). At the very core of what we do day in and day out as data professionals we find data and people. People make up the PASS Community, people make up the shops you are in, and yes it is people that make an impact on one another. I personally, am blessed to have been one of the ones impacted. May we continue to give back in avenues that we can whether it’s volunteering, speaking, organizing, mentoring – – whatever the case may be. This community; this is our community

Thank you to all the PASS volunteers, staff, sponsors, speakers, convention help, caterers, attendees, etc. It takes all of us to make the wheel go round…..until next year.

Be an impact player ~ let’s roll

img_20161025_074208

 

PASS Summit Keynote 2 – Release 2

pass_2016_website

Dr. David DeWitt is getting ready to take the stage to a huge ovation and is thrilled to be back at PASS Summit.

Haha, bring back #BringBackRimma is a twitter tag that he has put in place….looking forward to hearing Dr. David DeWitt speak today…..

  1. Why data warehousing in the cloud
  2. Scalable DW fundamentals
  3. A look at 3 leading competitors

Why Data Warehousing in the Cloud

Reduce time to insights

Dynamic adjust capacity

Appliances will always be the gold standard and cloud is somewhere in between, but there is no “free lunch”

No CapEx and low OpEx

Go from conception to nsight in hours

Rock bottom storage prices

Simple upgrade process

Flexibility to scale up/down compute capacity

Scalable DW Fundamentals

Interesting to see partitioned parallelism as a point that discusses software building blocks.

Hardware failures carrying over into the cloud…..yes this does happen.

What are some alternatives to scalable DW designs? Shared-Nothing and Shared-Storage.

Shared-Nothing is the gold standard; can be designed and scaled indefinitely.

*Storage and compute are co-located*

Shared-Storage is stored on remote storage (SAN, Azure, S3)

Demos occurring………………….

PASS Summit Keynote 2 – Release 1

pass_2016_website

Grant Fritchey taking the stage to talk about the financial health of PASS.

250k members , 170 countries, and 87% global representation – outstanding.

73% return into the community; focused on being a one global community

119 SQL Saturday Events held in 2016; have had pretty solid growth over the course of 2012-2016

Six 24 hours of pass in 5 different languages

A new PASS BA Event in Chicago coming up; be on the lookout for details.


Denise talks about what does PASS mean to you? Interesting question so ask yourself; what does PASS mean to you?

Professionals discover, create, and network those are some of the topics that have been addressed.

Connect….ShareLearn > but as technology progresses and grows so do we.

PASS with a new BRAND……yep that’s right. New shirts are flying out for the new brand.

A new website is on it’s way (work in progress) with a launch date of early next year.


11:45 WIT luncheon today sponsored by SentryOne (ticket required – check with the registration desk)

Speaker idol at 4:45 round 2


 

 

 

PASS Keynote Part 2 – Live Coverage

pass_2016_website

 

Good morning from PASS Summit in Seattle, Washington. Like yesterday I will be live blogging the event. The same format of the blog will apply with up to 5 releases every 15 minutes.

Yesterday was a great first keynote, and from what it appears attendees are pretty excited to see what the second keynote will hold.

If you get a chance check out the blog and look forward to keeping you informed.