When the Problem is Not Them. It’s You.

Hello Dear Reader!  I’ve been the Data Platform Management Lead at Pragmatic Works for almost two years now.  It’s been an interesting journey that I’m enjoying.  I’m the tier 3 support in a lot of cases, play the role of manager, mentor, and fellow fighter in the trenches when required.  Today I wanted to write about something that deals with professional development.

In IT facts are facts, data is data, things perform well or they do not.  All of this leads to trust.  I do a lot of presentations on the Internals of SQL Server.  It is a fun and topic I enjoy it. *cough* nerd alert *cough*.  I do this not just for fun, but because knowledge is powerful.  It gives me the ability to let my clients have confidence that I understand what I’m talking about.  Very rare are any instances where I have been paid when I actually needed to flip hex to decimal and look through the binary that was produced.  The ability to display that knowledge when needed is crucial to ensuring you’ve got a second shot when you need it.

Projects, jobs, and opportunities come and go.  I’ve seen cases of spectacular success.  As anyone who has experienced success well knows, the path is littered with those who have failed before you.  Some projects are easy, some are hard.  All can be successful, but you have to have the right mindset.  When projects do fail it can be for a variety of reasons, typically it comes down to poor communication. 

I could be the typical marketing magazine and now list out ways projects fail, how communication is important, but Dear Reader you deserve better.  What you really want to know is how you fix it.  

IS IT TOO LATE FOR A RETRY

Unless all trust is gone it’s not too late.  When you are walking out the door, or being asked to walk out the door it is too late.  As long as you are still on the team, you should take that as validation to be part of the process.  In business everyone wants to be successful.  Everyone wants to win.  If you can help with that, then it is never too late.

The Upgrade Part 1

I was with a billion dollar company and we were upgrading their SQL Server boxes for their main application that the entire business ran off of from SQL Server 2000 to 2008 R2.  We had a very well thought out project plan, an itemized list and timeline of what needed to occur, and over 100 people including a team of VP’s that were on hand to monitor the event.  Leading up to it we hit a pretty big snag.

We were migrating the users from SQL Server 2000 to 2008 R2 and an odd thing happened.  The logins stopped working.  We caught it in Staging.  There was another consulting company that was also working with my client.  Often you will work with consultants or contractors for many different organizations, and you have solid and good relationships.  This was not one of those cases.  

The competing company took this opportunity to state very loudly that I didn’t know what I was doing.  That we could not just go from SQL 2000 to 2008 R2.  The hash had changed for logins, and you had to stutter step to SQL Server 2005, then re-export the logins to SQL 2008 R2.  This added an increased level of complexity, and threatened to blow our timeline.  I left the office dejected and the client questioning my experience.

You don't want to do IT.
You want to go home and rethink your life.

The EDW Part 1

I was with a client in the financial industry.  The mission to help pull data from a database, not SQL Server, to a new Enterprise Data Warehouse (EDW).  The plan would have us pull from our Online Transaction Processing (OLTP) system to move the data over.  They already had an Online Analytical Processing (OLAP) DW.  The data was Extracted, Transformed, and Loaded (ETL) from the OLTP system to the OLAP system.  The columns where not the same, they didn’t match up fully.  This was using a 3^rd party product so we didn’t have full visibility into the data mappings.

The business trusted the OLAP system.  Even though the OLTP was the source, they wanted us to validate our imported data against the OLAP, not the business rules and calculations provided to us using the raw OLTP data.

I didn’t agree with this approach.  A source system of this type that had pure 100% financial data, that financial decisions were made off of daily, should be the trusted source.  We should not be replicating the OLAP data but finding that the business calculations produced, validating them off of the source data and moving that data.  After many meetings on this subject I found myself in a room with the entire project team.  I realized that I was the only one passionately arguing this point of view.  In fact I found everyone was unified in one direction.  That direction was that I was wrong.

FIXING THE ISSUE (YOU)

Once you have realized that you are the issue the next step is to find a way to reestablish trust.  Learning, adapting, and putting the goals of team forward showing you can be a productive member goes a long way.

The Upgrade Part 2

When I started thinking about the issue I knew I wasn’t wrong.  Either that or I had gotten unbelievably lucky for every upgrade from 2000 to 200x that I’ve ever done.  Either way I wanted to know which it was.  If I had been lucky, well let's just say I would have a lot of phone calls I would need to make.

In order to be sure it was time to take a close look at the Microsoft provided scripts for transferring logins for SQL 2000 and guidance for SQL 2005 and up.  What I found was that the hash output was indeed different.  To test this I stood up a SQL 2000 box, made a user and a password and exported them.  I did the same on SQL 2005.  There were differences.  The length was different.  The 2000 scripts generated a password hash that was 102 characters long.  The 2005 and up were only 42 characters long.  Then it struck me those characters matched the SQL 2000 output exactally.

I used the SQL 2000 script to transfer the user to a SQL 2008 R2 instance.  Then I logged on as the user.  It worked.  I deleted the user, and ran the 2005 scripts.  It worked.  Those 42 characters were the important part.  That didn’t solve my issue with the client.  Our passwords were not working.  On a wild hare it struck me that the passwords were all lower case.  I tried camel casing them.  They worked.  I found by default that SQL 2000 passwords were case insensitive.

Poor password management had led them to record the passwords as lower case.  The hash had saved the camel case, and on export had enforced it by default on 2005 and up.  I brought this to my client the next day.  We realized that the passwords they had stored were not always correct.  In order to fix this we had to reset and update every application and it’s password before we could proceed. 

We did, and the upgrade rolled on.

The EDW Part 2

I stood at the front of the room and realized every eye was on me.  I realized that the business firmly believed in the process they had laid out.  I also realized, I was the only one not on board.  This was a definitive moment.  I could stand my ground, but very quickly I could see that would lead me off this project.  Failure is not an option.  So I went for option 3.

The process of not trusting the source is, and this is an understatement, not good.  Even with that staring me down, I could see an opportunity.  If I was onboard with the plan, I could work from the inside to validate that the source data was what we needed.

So I did just that.  I wasn’t excited, but I smiled big.  I wasn’t 100% convinced, but I threw in my hat, hard work, and rolled up my sleeves.  That first day the grin on my face may have been strained, by the end of the next 4 weeks it wouldn’t be at all.

We didn’t have all the business rules or the ETL logic for the 3^rd party data warehouse that the business trusted.  The people in the room knew that.  They were committed to getting this right, and putting the puzzle pieces together.  The process would be painstaking, but as I made my change of heart and discussed the validation we would need to do, mapping documents we would need to create, business logic we would need to confirm, validate, and how we would validate the imports it started to come together.

PULLING IT ALL TOGETHER

“So Balls,” you say, “That’s great that you fixed it. How do we fix it?”

Great question Dear Reader.  These stories both had a positive outcome.  They happened because I didn’t give up, and I continued to work to help the team succeed.  I don’t want to paint this as if I’m never wrong.  Just ask Adam Jorgensen (@AJBigdata | Blog), he’ll tell you that I’m wrong quite often.  I’ve also blogged about learning from mistakes, mistakes are important.  Be humble in the way you interact and listen to people.  People who believe they are never wrong, suffer defeat far worse than those of us that recognize it as part of growing.  

 

If I was wrong about the passwords from 2000 to 200x I wanted to know.  I wanted to understand why, and what we could do to fix it.  Had I been wrong, I would have sung it from the mountain tops.  I would have blogged on it and gladly advised people on it.  Instead I found the answer I was looking for and the logic to back it up, I share that just as freely as I would have my failure.

When everyone is fully committed to an idea that you do not agree with instead of assuming they are wrong, consider that you are.  It changed my point of view on the project.  It allowed me to embrace a team that wanted someone to take them on the path towards success and be part of that team.  It also reinforced a very simple fact, I am not always right and I need to listen to others.

In each case you have to want to achieve the end goal, and that has to be more important than being right.

As always Dear Reader, thanks for stopping by!

Thanks,

Brad

PASS Summit 2014 Streaming Keynotes

Hello Dear Reader!   It's that time of the year again, time for the PASS Summit and the streaming Keynote.  Here we go!

11/5/2014 10:05 AM

T.K. takes the stage again.  Announces that Azure ML is available for free today, you just need a live ID.  He's got the slide from the beginning up.  They did a really good job of showing an end to end story here.

11/5/2014 9:53 AM

James Phillips takes the stage to talk about Power BI and Power Pivot, he's showing us the visualizations, and how to take the big data that Joseph showed us and consume it as a user.

We are getting a really nice overview of PowerBI on the web.  When the video posts I'll get a link in there, because this is moving to fast for good descriptions.

11/5/2014 9:38 AM

Demo of Stretch table was really awesome.  Not sure how much I can say about this at this point. 

But this could have huge potential.

Sanji comes out to do a demo in-store analytics using an x-box Kinect.  Showing heat map made in power maps.  They can see where people are hanging out, so they can understand shopping behavior in a store.  How do they consume that data quickly.  Using Azure Data factory to show orchestration, and lineage in the cloud. 

They are walking through Azure ML, showing how to use a work flow to process past data to make predictions on future buying patterns.

We now see how this will work on a mobile app. Cortana is on the mic talking, making product recommendations after Sanji check's in.  She recommends beer mugs.  Then she shows him where to find them on the in store map.  Very very cool.

11/5/2014 9:19 AM

Sneak peak of the technology with Mike Zwillig from the SQL Team takes the stage.  He starts with a demo on Pier 1 imports.  He talks about the issues of getting data reporting from a data mart.

Neat demo he asks the audience to go to a website and click on items to buy them.  He then shows real time reporting of what is being purchased using an *writeable nonclustered Columnstore on an IN-MEMORY OLTP TABLE*.  Awesome.

11/5/2014 9:10 AM

Tracey leaves the stage and we move on to Maximizing performance & availability.  T.K. talks about how running SQL DB across all of Microsoft has forced them to think not just as engineers but as DBA's. 

Not sure if I heard this right but T.K. just said they are working on In-Memory ColumnStore.  That would be HUGE.  We see a list of business that are currently using the cloud and on-prem in very clever and very performant ways ensuring millisecond response times.  He discusses that Samsung has achieved x24 performance with In-Memory OLTP.

We now play a video from Dell on how they are using In-Memory OLTP.  They say they have achieved x4, performance.

T.K. is announcing that SQL DB will have significant improvements in T-SQL Compatibility, larger indexes, Parallel queries, extended events, and In-Memory Columnstore for data marts.  Wow.  There it is.  If it is in SQL DB, does that mean we will see this in the box product?

11/5/2014 9:01 AM

Tracey continues his demo showing how they can use JSON files to change the schema of their search pattern, based on marketing promotions. Using the Shard Utilization heat map that shows how to add processing power, monitor usage, how to scale over different regions.  How you can change the SQL DB scale.  This was very cool.

One more thing.  They GA'ed a new feature last week, they are going to take their Pier 1 main database, they show the load on it.  They want to configure geo-replication.  On the map they show all of their deployments.  Tracey is replicating the main database to Asia.  There were three clicks to do that.  Very impressive.  I would like to see what the bandwidth requirements are for that, this may require a further look.

11/5/2014 8:46 AM

T.K. continues, we are adding 40% data in the world every year.  We need to have and form a Data culture.  Three key tenants:

1. Harness new data types

2. Tackle big data

3. Deliver solutions faster

His vision of the system development lifecycle is to transform & analyze, Visualize & decide, and capture & manage.  He puts up a slide showing how the different Microsoft platform stack relate to these items.  We will focus on capture & manage because that is where the data platform stack fits in.  He's stressing that this is an 'and' world not an 'or' world.  They want their platform to tie together like never before.  More talking points, capture a diverse set of data, achieve elastic scale, maximize performance & availability, and simplify things with the cloud.

Here's a couple of highlights from the past year.  Cloud first, Mobile first.  Get used to hearing that.  He is discussing advances in Azure Document DB, Azure HDInsight, Analytics Platform System, and Azure Search.

The ability to scale for 2014 is very impressive.  640 logical cores. 

A partner, Tracey, from Peir 1 imports comes out to display intelligent search using fuzzy logic.  He is demoing searching for Orange Pumpkins.  They are using Azure search and two lines of code. 

11/5/2014 8:35 AM

Tom introduces the Executive VP's of SQL Server T.K. Rengarajan, James Phillips, and Joseph Sirosh to help share the vision they have for the Data Platform stack.  A video shows of the three talking about their backgrounds and area's of expertise.  It's interesting that they are all relatively new to being the EVP's for SQL Server.  Should be interesting to see how this brings about new features, or what their view on expanding the stack is.

A video is now playing of different vendors and early adopters of the Microsoft stack, discus and how they are currently using the stacks.  T.K. Rengarajan takes the stage.  He talks about his ba

ckground and studying under Dr. Dewitt.  He speaks about his family and two daughters, he is invested in WIT because he hopes they have wonderful career in technology.

He discusses about how he loves MAPs, using maps to navigate family vacations.  He discusses using MapQuest ('remember MapQuest, he says').  Then GPS made trips even easier, and this is a natural way to see how data and technology has changed our lives.

11/5/2014 8:25 AM

PASS President Tom Larock starts off on stage.  He welcomes the first timers and points out that we are currently streaming live to over 50 countries.  Tom ask for a round of applause for Microsoft for making the best data platform on the planet.

Tom is giving us an overview of the road so far.  How PASS was started and founded.  From the first

PASS Summit with 1,200 attendees to today with 5,899 attendees.  Since it's inception PASS has produced 1.3 Million hours of training.

Tom asks us to think about where we were five years ago, and where you are now.  He asks you to look at your future in the same way.  "Growth is never by mere chance; it is the result of forces working together."- James Cash Penney.

Tom is addressing the changes PASS has made to have a larger umbrella.  He is asking people to get involved in growing PASS.  Meet new people, learn & grow, volunteer, join a chapter, or talk to the Board of directors.

Tom is discussing some of the events available at the Summit.  The SQL Cat Team, 50% off Microsoft Certifications, Birds of a feather luncheon, the Women in Technology Luncheon, and Speaker Idol.  Tom Thanks the exhibitors and vendors.  There is an Exhibitor Reception tonight form 6 pm to 8 pm.

Summary

Okay Dear Reader, this was a great way to kick off the Summit.  I’m off to finish up some prep before my first presentation today.  See you soon!

Thanks,

Brad

Tales from the Query Processor III

https://www.flickr.com/photos/socal_jim/2070088596/

Hello Dear Reader!  It’s that time of year again.  The leaves are turning, temperatures are changing, and Halloween is once again upon us.  Today is Halloween, time to take the kiddos out to Trick-or-Treat!  Today is also my daughter’s 16^th birthday!  It’s hard to believe that it has come so quickly!  Happy 16^th Birthday Chesney!

This is also the time of year when we embrace the suspension of disbelief, and have a tale of terror from the Query Processor.  If you want to see the previous tales, here is Tales from the Query Processor and Tales from the Query Processor II.  I hope you enjoy.

The Plan that Will Not End

Q.P.

If I had known this was the last time that I would ever see Sid I would have given him better advice.  Maybe I would have given him something at all.  Something better than the flashlight and the map.

Let me start over.  I don’t know that he’s dead.  We haven’t seen him in 4 days.  Most trips take seconds, long one’s minutes, very long one’s hours.  No one has ever been gone this long.  No one has stepped up to take his place, a good indication that he might not be dead.  Nobody is looking for him, at least not that I can see.  As we stood there on that dark night, it seemed simple.  So very, very simple.  When I don’t know something I have to guess. Sometimes my perspective is obstructed.  My view isn’t sufficient.  I always guess the same thing.  One.  That’s my number.

 

We’d all done it before.  We’ll I hadn’t.  Sorry, I forgot to introduce myself.  My friends call me Q.P.  I’m the map maker.  I make a map of a place, tell people where to get things.  It may sound simple, but its not.  I don’t do point A to point B.  I estimate proximities, how long something should take, the best route, what to do under specific conditions. I guessed one.  Should I not have guessed one?  There’s load, location, and the gateway that should be used. 

The Gateway.  It’s a special threshold that we have to pass through.  It ensures that we are ready for the load about to be placed on us.  Sid went through the biggest Gateway there was.  It stopped him at first.  Took us a couple hours to get everything calibrated correctly.  The map was a long one.  If my normal plans are a between 2 to 5 in difficulty, this plan was an 800.  We knew that going in.  That’s why he went through the Big Gateway.  Waiting for him to return, I can only imagine what’s going on.  Was there more than one?

SID

Hello my name is Sid.  I don’t know how long I’ve been gone, but here’s what I can tell you.  I’ve been running.  Since I passed through that last gateway and received my grant I ran.  I ran straight into this nightmare.

I turn down one corridor and it leads to five more.  Sometimes a hundred more.  Sometimes thousands more.  Behind every door there is more and more to grab, more to strike, so much more.  This plan is useless at this point.  I don’t know what Q.P. was thinking.  I’ve been hacking and slashing my way through this mess.  I’m exhausted, but I can’t stop now.  I’ve got to keep running.

http://taodao.deviantart.com/art/Running-Zombies-405296478

Last night I stopped for a moment, went serial and just focused on one thing.  Thought I could get a bit of a rest, but I turned a corner.  Where there should have been one there was one.  One million of them.  I’ve never seen a horde of so many Zombie records.  Yes I’m supposed to return with 300.  But nobody told me how many I would have to fight off to get there.  Simple run.  Heh. That wasn’t the first million that I’ve faced either.

I only got 120 with me so far. 120 out of 300.  I’m trying to put together some actual numbers.  If I make it out of this, we need to know what the difference is.  Something went horribly wrong with this plan.  No backup is coming, and if I’m lucky we won’t be swallowed here. 

The first 5 that I got came along easily.  Everything was good.  Three steps out on the plan things started going sideways.  We went to a simple structure.  One record inside, the plan said.  We walked in and looked around.  We heard them before we saw them.  There was a low moan that started traveling like an echo.  This was not an echo.  Echo’s don’t respond to one another.  Before long it was reverberating and echoing.  We could see the first movement in the darkness.  We were not prepared for this, so we ran.

We circled back.  That structure had a basement, a lower level, a parking garage, and a sub structure.  Our only choice was to run them.  They followed us down the loop, into the parking structure.  They are not smart, if there is no match to guide their way they will spill out of the darkness like a thousand scurrying insects in every direction.  We made it to the edge and climbed up.  They spilled over the edge like a dark waterfall.  There were no screams, no help me I’m falling, just that moan and the sound of impact.  We circled back down looking for survivors only to pick up more.  There are no weapons around us.  We have no choice but to keep running as our only offense.  We did the same thing, over and over again.

The only thing the map gives us is a view of the structure.  I think there is a better way to do this, but I don’t know how to edit the plan.  Not when we have to keep running.  It took us hours to find the next 3.  Hours for 3.  We were lucky not to be killed.  We’ve cleared 100 structures at this point, 200 remain.  We’ve got to find the rest and get them out.  Almost halfway done.  Don’t get killed.

I hear them now.  I have to run.

-Sid

Happy Halloween Dear Reader!  As always Thanks for stopping by.

Thanks,

Brad

I'm an MVP

Hello Dear Reader!  Two weeks ago I was very honored to be named a Microsoft SQL Server MVP.  Since then I've been reflecting on what it means to get this award and the massive amount of people that helped me along the way.

Family, co-workers, friends, community members, and other MVP's.  This could turn into an Emmy speech, but I won't put you through that.  In the past I've written about this and saying Thank You to the People That Get Us There, about Why You Should Go to SQL Saturday and the impact it had on me, and how Who You Work With helps push you in the right direction.  Before I move on from thanking people I need to say a big THANK YOU to the people who nominated me.

Mike Walsh (Blog | @Mike_Walsh), Jack Corbett (Blog | @Unclebiguns), Jorge Segarra (Blog | @SQLChicken), Adam Jorgensen (Blog | @AJBigData), and Jason Strate (Blog | @StrateSQL).  Gentlemen I thank you not only for nominating me, but giving me a seat at the table to begin with.  Through advice and conversations you immediately welcomed me.  I've always been humbled by the way in which smart men and women of the SQL Community open their arms not only to greet but assure newcomers that they deserve a voice and a seat at the table.   My friends Thank You.  Thank you for your faith in me.  Thank you for helping me get here, and for all the encouragement.

Jorge once said to me about three years ago, "You deserve a seat at this table, enjoy it and don't ever worry that you belong.".  Great and kind words my friend.

Now Dear Reader, I also want to pass along one incredibly important piece of advice that was given to me.  How to become a SQL Server MVP.


HOW TO BECOME A SQL SERVER MVP


I have no idea.   None.  Not a clue.  In conversations with all of these amazing folks, they had no idea either.  However, I did notice that I heard the same three pieces of advice repeated over and over again.

That feeling you get when you open the box

1.  Love what you do.

2.  Don't treat being an MVP as a goal, but something that happens along the way.

3.  When you get nominated fill out the website details, better start collecting them now.


LOVE WHAT YOU DO


I enjoy this.  I love presenting.  I love learning.  I love talking with people about their issues with SQL Server.  I really love when I know what's wrong with a system and can help fix it.  I've had telephone calls with clients in the past couple years where after hearing about five minutes of their problem I knew what the issue was.  I could start giving advice on the phone call, and by the time we were sharing screens or I was landing on the ground we were able to start working on a fix.  That is pure awesome.


Some people love to blog, some love volunteering, some are leaders that bring us together, some organize, some  troubleshoot on forums, some program amazing applications/scripts/videos to help the community, and some love to speak.  Whatever you are doing if you love doing it, then keep doing it.  You'll never feel like you wasted your time, and you will know you are doing things for the right reason.


IT'S NOT THE GOAL, IT'S THE JOURNEY

San Francisco Sunset with @JasonHorner

I'm paraphrasing Emerson.  It's no less true.  If I only get this one year, if I never would have gotten it, the journey of pursuing what I love to do has taken me places and allowed me to achieve things I had not even thought of.  I've criss crossed the U.S. this year and I'm looking forward to staying busy next year.

Keep in mind this didn't happen in one year.  Every journey begins with a step.  I encourage you to start your journey.  When I present at SQL Saturday's or SSUG's I tell the audience the same thing I hope you now hear Dear Reader.

In each of you there is a story to tell.  There is something you are doing right now at work that I, and other people, would love to know and hear about.  There are ideas you have that would be well received and applauded.  Get involved, volunteer, blog, present, find what it is that you want to do.  We all have a calling and I hope you find yours.  If I can do this so can you.

Remember, you deserve a seat at this table, enjoy it and don't ever worry that you belong.

Now grab your seat, let's have some fun.  As always Thanks for stopping by.


Thanks,

Brad

#PASSVOTE 2014

Hello Dear Reader!  The PASS Board of Director elections are upon us again.  We have 3 spots open and 4 great candidates.  A lot has been written about this election already.  Andy Warren has sounded off, Brent Ozar as well.  There are blogs by the candidates and many others.

While we are all waiting to get into the website to vote, here's who I'm voting for and why.


1. JRJ aka James Rowland Jones.

James is energetic, incredibly knowledgeable, and a pleasure to hang around.  James has done a lot of work expanding and evangelizing for SQL Server on the international front.  He helps head up SQLBits and I love the idea of a FREE & PAID conference combined.  I'm hoping that we can adopt some model of that in the U.S.

James is a flat out leader in this field of IT/SQL Server/Microsoft Consulting.


2. Wendy Pastrick.  

STOP SCREAMING INTERNET.  Before people go "OF COURSE, SHE WORKS FOR PRAGMATIC" stop.  If that is all you think of what I write, stop reading.

Being in IT as long as I have the way someone's mind works is incredibly important to me.   I work with Wendy, I've interviewed her.  I also encouraged her NOT to run for the board.  That's right Dear Reader not to run.

She has a wonderful enthusiasm.  She is thoughtful, and she truly believes that she can make a difference and told me so when I encouraged her not to run.  I like the work that Wendy has done for the community.  The first part of victory is wanting something. She does.  I may never run for the board but, in the conversations she and I have shared I have no doubt PASS is a better organization with her there.


3. Grant Fritchey.  

I know Grant, I like him quite a bit.  Met him at SQL Rally in 2011 when he did his first pre-con.  I've seen him at conferences, presenting, and talked about everything from SQL, presenting advice, to cleaning shot gun's vs. sharpening swords to intimidate boys coming to date a teenage daughter.

It's safe to say I like him.  But why do I think he would be good on the PASS Board?  Grant is an optimistic, enthusiastic, realist and when we talk I can't help but think he's somebody I would want to work with or work for.  He is passionate at the right times, and he clearly explains what is on his mind and the way his decisions work.  The most important thing to me is how someone's mind works.

He's a DBA, but he has taught pre-con's on Azure, he has looked at Big Data, he doesn't shy away from learning and tackling new things.  Plus the man produces a damn fine book on Performance Tuning.  I'm looking forward to seeing what he can do on the board.

WRAP IT UP

Alright Dear Reader.  I don't expect to convince you, this is just who I'm supporting and a short reason why.  The thing you do not see in this post is the hours, meals, and conversations I've had over time.  All of that adds up.  I'm lucky to know these 3 people.  PASS would be lucky to have them.

A long time ago before I got involved I thought the Speakers ran PASS.  It never occurred to me that the public face of PASS was not who ran the show.  I've been very happy the last couple of years with the additions to the board.  I'm excited to see these Speakers stepping up to help.


If you have a ballot to vote please do.  Good Luck to all of the Candidates!  As always Dear Reader, Thanks for stopping by.

Thanks,

Brad

Outstanding PASS Volunteer

Hello Dear Reader!  In June this year I was recognized by PASS as with an Outstanding Volunteer Award.  In an unusual move I found myself speechless.  This is a very quick post to give the true credit where it is due.  June was a very busy month for me and I had a blog post scheduled to post it in July, but… let’s just say a couple things happened on the way to the theater.  The timing felt a bit wrong.

“So Balls”, you say, “Why blog about it now?” 

Great question Dear Reader.  The original blog was a big Thank You, and I want to say that in earnest.  The reason I received my award was for a lot of the work and presentations I’ve done this year. 32 presentations so far in 2014 with 9 more planned out and hopefully a couple more to come. 

These presentations don’t happen in a vacuum.  I’ve been very blessed as a presenter and community member.  I’ve written recently about how SQL Saturday’s impacted my life.  This year friends in the community invited me to new and wonderful locations.  Mike Walsh (@Mike_Walsh| Blog)  and 1/2 of my future law firm of Biguns & Balls Jack Corbett (@UncleBiguns | Blog) started out my January in New Hampshire from there I've presented physically and remotely in Florida, Puerto Rico, Massachusetts, Wisconsin, Missouri, Texas, California, North Carolina, Virginia, Oregon, Colorado, Georgia, with more before the end of the year.  That doesn’t include Webinars where people from all over the world signed up to attend.

If you attended, were forced to attend, dragged, cajoled, or otherwise persuaded to attend I Thank You.  Dear Reader without you it doesn’t happen.

For the organizers, who put in their time, put on events, get sponsors, volunteers, and manage the process Thank You.  My time to present is a pittance compared to the effort it takes to lead a group and the hours that you put in.  Many Thanks for letting me be part of your group.

To PASS, the volunteers (the literally HUNDREDS of volunteers from SQL Saturday’s, program committees, Leadership Staff, down to the volunteer picking up coffee a noble and thankless job), Chapter Leaders, the employees whom I see and send emails to for the Summit or SQL Saturday’s, and all of those who I do not see Thank You. 

Your hard work helps create an environment that allows our community to thrive.  There have been lots of fantastic winners already this year.  I encourage you to check out the PASS page of Outstanding volunteers here.  Chances are if you’ve been to an event this year one has touched your life.

A Quick late-CONGRATULATIONS to my friend Shawn McGehee (@SQLShawn | OPASS) who is the August Outstanding volunteer.  Shawn is the Chapter Leader for OPASS and has done an incredible job.  He is leading the charge for our Pre-Cons for SQL Saturday Orlando amongst many, many other things!  Way to GO Shawn!!

To my friend who nominated me, the beers on me.  To anyone who wants me to present and I haven’t presented for you. If I’m in your area or you need a virtual presenter, shoot me a message on twitter or an email at bball@pragmaticworks.com  I’m always happy to help.

ONE MORE THING

“So Balls”, you say, “You’ve said Thank You, anything else?”

Why Yes Dear Reader!  Yes there is one more thing, actually 4 more things.  I got something big that I cannot share quite yet.  In celebration of the community and the influence you’ve had on my life I want to give something back.

So in October I’m going to blog a community script a week.  These will be scripts that people have asked for, as I’ve presented that I never found the time to get out there, plus a couple new ones.  One a week leading up to the PASS Summit in November.

As Always Dear Reader, Thanks for stopping by.

Thanks,

Brad

Professional Microsoft SQL Server 2014 Administration

Hello Dear Reader!  Last September I was approached with a tremendous opportunity to become the Managing Author for the Professional Microsoft SQL Server 2014 book by Wrox.  We worked throughout the CTP phase and solidified the book after RTM.  By the end of July all the pages were in, all the chapters proofed, and we all had a collective sigh of relief.

I was joined in this book by Steven Wort, Ross LoForte, Chad Churchwell (@chadchurchwell | blog), and Jorge Segarra (@SQLChicken | blog) from Microsoft and Adam Jorgensen (@ajbigdata | blog), Brian Knight (@BrianKnight), Kim Hathaway (@sqlkimh), Roger Wolter (@rwolter50 | blog), Dan Clark, and Kathy Vick (@MSKathyV | blog) from Pragmatic Works.

Tech reviewing the book we had Kathi Kellenberger (@auntKathi ), Jason Strate (@StrateSQL | blog), and my buddy Daniel Taylor (@DBABulldog | blog).

The initial goal was to just update the book.  It quickly became a project to gut and replace old ideas with newer material, a vision that continued to grow and should make the next release of the Pro Admin series drastically different even from this book.

I couldn't be prouder of this crew.  Roger Wolter is a former PM from Microsoft who helped write Service Broker, and has done some of the largest and most interesting implementations of it in the world.  You will see his handy work on Chapter 6 on Service Broker and Chapter 8 on Securing the Database Instance.

I worked with Jorge very closely before he joined Microsoft.  He is an amazing guy, with a thirst for new knowledge.  Jorge took Chapter 1 on the SQL Server Architecture and 24 on SQL Server Azure Administration and Configuration.

My friend Kim Hathaway and I teamed up Chapter 2 Installation Best Practices and Chapter 3 Upgrading SQL Server 2014 Best Practices.  Dan Clark, .NET coding wiz and all around BI knowledge base, lent his talents to Chapter 7 SQL Server CLR Integration.

Kathy Vick a former Microsoftie with two tours of duty, who has been working with SQL Server since it was still called Sybase prior to 4.2 has Chapter 13 on Performance Tuning T-SQL and Chapter 14 on Indexing your Database.

Bradley Schacht did more than can be mentioned for the BI side of the house in this book.  He wrote Chapter 23 on SQL Server and SharePoint Integration.  Chad is a smart and amazing PFE for Microsoft.  He joined at the last moment us to take over Chapter 16 on Clustering in SQL Server 2014 and provided a quick and solid contribution to help us over the finish line.

Steven Wort, Ross LoForte, Brian, and Adam all produced the work that is consistent with what we have expected over the years.  Superb.

Then there's this guy.  Mr. Balls. I was honored to be asked with working with this gifted crew.  I wrote Chapter 4 on Managing and Troubleshooting the Database Engine, Chapter 9 In-Memory OLTP (Hekaton), Chapter 10 Configuring the Server for Optimal Performance, and Chapter 11 Configuring the Server for Optimal Performance.  Hmmm....I sense a theme.

The link to the book on Amazon is here.  Just wanted to say Thanks again to the team that put this together!

Look Mom & Dad, I'm on a Book!!!

As always Dear Reader Thanks for stopping by.

Thanks,

Brad

24 Hours of PASS Preview: Zero to Hero (I'm the Zero)

Hello Dear Reader!  We are already away into the 24 Hours of PASS Summit Preview for 2014!  I don't know if you heard, but I have a pre-con at the PASS Summit!  More precisely SQL MVP Robert Cain(@arcanecode | Blog) had a great idea for a precon and invited SQL MVP/MCM Jason Strate (@stratesql | Blog) and myself to join him.

We decided early on that we have a great opportunity to showcase how we use PowerShell to complete tasks on the Business Intelligence, DBA, and Cloud engagements and pass on real world skills.  We also want to do it in a way that things are useful.  Our goal is to have things we can give you that will allow you to leave the pre-con and use right away.

We also realized with a bunch of smart guys (and me), presenting we had the opportunity to use Humor and a bit of stage acting.  I'll be playing the role of the Zero in our pre con.

"So Balls", you say, "What's a Zero, and how do you play one? (and why are you explaining this)?"


Great questions Dear Reader!  First let's talk about, what's a zero?  I will be pretending that I do not know how to use PowerShell.  That I don't understand how to use the verbiage, variables, function, modular code design, how to import modules, or do a lot of other stuff you need to know.  I will need to learn from the ground up as if I'm a beginner in the class.

Hopefully me at the Summit (without the awkward flying)

I will ask questions, get explanations, and help bring the audience along.  As the day progresses I'll become a hero using concepts and technology to deliver some end to end solutions.  I'll even take over the Azure PowerShell portion at the very end of the day.

Why am I explaining this?  PASS has an international audience and I'm not a professional actor.  I'll do my best but some may miss the humor in what we are presenting.  Robert, Jason, and myself spoke last night and we didn't want anyone to think that I didn't actually know PowerShell or give reason to doubt why I'm participating in the pre-con.

So sit back today, enjoy our session.  I hope you enjoy me being the Zero, and come to the Summit to find out how to be a Hero with me.

But wait there's more!! Today during out session Robert and I will do most of the talking.  Jason will be live answering your PowerShell questions using the #pass24HOP hash tag on twitter, and answering the questions in the room chat on Twitter as well.  This promises to be a fun session, hope to see you there!

Here is the link to our pre-con.   Here is a link to the 24 Hours of PASS website.  Good luck, happy learning, and as always Thanks for stopping by.

Thanks,

Brad

Why You Should Go to SQL Saturday

SQL Sat Puerto Rico

Hello Dear Reader!  Soon SQL Saturday #318 in Orlando FL will be here.  The SQL Community does a lot of work at SQL Saturday’s, present at them, and help put them on.  When talking about them, one of the most frequent questions I get asked is: “Why should I go to a SQL Saturday?” 

Almost 4 years ago I attended my first SQL Saturday, attending was a last minute decision and one that has changed my life.  I have a real passion for SQL Saturdays, and while results may vary, my simplest answer is “they can be life changing”.  Here’s how I got there.   

Summit 2013 - Denny's awesome Party

The only SQL Event I had ever attended was the first 24 Hours of PASS.  I loved it.  I watched with eager anticipation, this was the first SQL training I’d ever been to.  Every company I’d worked for thus far had balked at sending me to training. 

I desperately wanted training.  When I discovered the 24 Hours of PASS I became a fan, FREE SQL Training on the internet!!! What a concept!  Of course it was to plug the PASS Summit, and if training was a no go you can guess what my chances of ever going to the Summit in 2009 were. ZERO.  This was as close as I could get, but closer than I’d ever been before.

So as the PASS Summit 2010 was gearing up there was another 24 hours of PASS.  I reserved conference rooms at my company, registered for the events, had a router for network connections set up, and I pumped up the “free” training to the other DBA’s. I worked for two days from there as the sessions were streamed. 

Jorge at SQL Sat Jacksonville

While talking with the other DBA’s that when the magic moment happened.  My friend Greg and my buddy Dan Taylor (@DBABulldog | Blog) said, “If you like the 24 Hours of PASS you’ll love SQL Saturday”.  What’s a SQL Saturday I asked?

A free event where Consultants, MVP’s, and SQL Community members set up tracks and have free presentations all day long.  I was stunned.  It was like I was a child hearing about “FREE CANDY” given out at Halloween for the first time.  Where was this? When was this? This weekend!  In Orlando!  I can do that!  I had to pay $5 for my lunch, but other than that no cost.  I almost felt like I was getting away with something.  As if someone would stop me at the gate and say, “Sorry Sir, you get to sit in the lobby only paying attendees get to see the sessions.”  It didn’t happen.  I got in just fine.

Tom Larock kicking
off SQL Sat OC 

It was everything I’d wanted.  Sessions on Wait Stats, PBM, CMS, Indexing, two deep dives one on partitioning and another on CPU!  I met DBA’s that understood my pains, issues with hardware stressed beyond capacity, aging relic’s with critical LOB apps that we couldn’t get new hardware for, 3^rd party vendors with bad indexes, bad code, and little support.  People trying to find a way to survive with NEW insights and experiences sharing openly and free.  People who understood my issues without having to pretend that they actually understood.   

I met Tom Larock (@SQLRockstar | Blog), Argenis Fernandez (@DBArgenis | Blog), Jorge Segarra (@SQLChicken | Blog), Patrick LeBlanc (@PatrickDBA | Blog), and 1 half of my future law firm of Biguns and Balls Jack Corbett (@Unclebiguns | Blog).  There were more.  Lot’s more.  That could take me pages more.  The point is I made it and it was like coming home.

Jason and Steve at SQL Live 360 

That day started it off.  Without Kendal Van Dyke (@SQLDBA | Blog), Andy Warren (@SQLAndy | Blog), Karla Landrum (@KarlaKay22 | Blog), and Jack putting on this SQL Saturday 49 I’m not here today.  

I submitted to be a speaker at the next event I could, I started a blog (you may be familiar with this one), got on Linked-In, and even got a Twitter account.  That event, that one SQL Saturday lead me to presenting at 7 more the next year.  

Getting a spot in the 2^nd chance track at SQL Rally, getting voted in by the community at the PASS Summit 2011, and being invited to be on the planning committee for SQL Saturday Orlando #85 the following year after I’d first attended.

Summit 2013 with the guys

At the end of SQL Saturday Orlando every year we stand up top of a stair case and throw out t-shirts and give away raffle items.  In 2012 Andy Warren looked at me while we were tossing out t-shirts and asked “How’s the view from up here?”  I grinned imagining about 50 different replies, but in the end it was a simple “amazing” that left my mouth.

My second job after college took me to Virginia.   A friend had recommended me for the position.  He met me at the airport, as I flew in for my interview, so I would see a friendly face.  I thanked him.  He told me “I showed you the door, you have to walk through it”.  He was right.  I did.  That job taught me a lot and led me new places.

SQL Saturday was the same way.  It showed me the door.  Walking through it brought me new acquaintances, some new friends, new ideas, to SSUG’s, the PASS Summit, Dev Connection in Las Vegas, SQL Live 360 in Orlando, two books, and a pretty awesome job at Pragmatic Works.

Summit 2013 - Karaoke at the Pragmatic Works Party

This is just the journey so far.  Funny how close yet far away 2009 feels. There is always the question, Dear Reader, of where tomorrow will take you.  We all start somewhere.  Everyone has to have the first time.  That brings us back to the question. 

Why should you go to SQL Saturday?  Because they can be life changing.  Hope to see you at one soon, click here to register for Orlando.

As always, Thanks for stopping by.

Thanks,

Brad

Deck & Demo's Live & Thank You AZSSUG & OPASS!

Hello Dear Reader!  Just a quick post to say Thank You to the Arizona SQL Server User Group and to my home town nortth Orlando user group OPASS!

This week I was very lucky to present Inside the Query Optimizer to the AZ SSUG and Performance Tuning, NOW! to OPASS.  I had promised to get my decks and demo's live and I wanted to do that.

Click Here for the Deck for Inside the Query Optimizer, and here for Demo's.

Click Here for the Deck for Performance Tuning, NOW!, and here for Demo's.

AZ to FL and back again.  I believe next week I'll just rest :).

Seriously Thank you to the wonderful SSUG leaders, Matt & Amy in AZ, and Shawn, Karla, and Rodney in my home town.

Without you this isn't possible!  And Dear Attendee's Thank You, if you have any questions please feel free to shoot me an email.

As always Thanks for stopping by.

Thanks,

Brad

It's not Business, It's Personal

Hello Dear Reader.  I find myself at this late hour unable to sleep.  Yesterday the slate of speakers for the PASS Summit was announced.  What should have been a happy moment was quickly darkened by the words of people that I know well within the SQL Server Community.

I would ask the MVP's and others in the SQL Server Community; Did you plan on intimidating new speakers yesterday?  

Because you did.  I have a few first time speaker that I've been working with. Not first time PASS Speakers, first time period.  Encouraging and mentoring them to get involved in SSUG's and SQL Saturday's.  At the beginning of the year I told one in particular that we should work on a plan so she would have the experience to submit to the PASS Summit this year.

Her first words to me when we spoke yesterday?  "Thank God I didn't submit, because the MVP's would be talking smack about me right now!"

Wonderful work growing the next generation of SQL Server Speakers.  Is this what community has become?

It seems every year with the speaker selection process the people I would normally count on as pillars in our community take the opportunity to bash the process.

If the process is broken so be it.  We should discuss that.  WE SHOULD NOT LEVEL PERSONAL ATTACKS.

That is ill befitting of the responsibility that we as speakers have in the community.

I remember what it was like to be a simple DBA that looked at speakers at conferences with awe and wonder.  Instead of being a community where we encourage new speakers, what.... we encourage new speakers as long as they all are from different companies?

By attacking Pragmatic Works and suggesting that the speakers did anything less than earn their spots, you demean the volunteers, my co-workers, anyone who works for my company, and you demean me.

There were a couple issues that occurred yesterday that compounded one another.  The presentation that occurred during the 24 Hours of PASS that I moderated, see Brent's blog.

Then Kendal a former board member who had knowledge of the process.  Who praised the volunteers and the way the process works, as noted by absentee presenters who didn't receive sessions this year how a speakers name did not guarantee a spot.  He instead implied that something improper had happened.  Here's his blog.  Until he accused me of having no integrity and not deserving my sessions it was a pretty interesting read, click here.

Here's the part to pay attention to: 

• "3 Preconference sessions by Pragmatic Works employees are on the list, including one delivered by PASS Executive Vice President, Finance & Governance Adam Jorgensen who is also President and Managing Partner of Pragmatic Works. I know a lot of folks that work at Pragmatic and they're good at what they do, but having 3 precon sessions (where presenters usually make good money from the sales) selected for the same company as one of PASS's execs...smells. I'd like to give PASS the benefit of doubt on this one, but I'll it's very hard to ignore, even if Adam wasn't one of the presenters."

HOW DO YOU HANDLE IT?

First I reacted in his comment sections.  I was mad and I called what he wrote Bullshit.  I stand by that.

I've reached out to Kendal.  I hope to talk to him soon.  This shouldn't be a conversation on Twitter or over the blog-o-sphere.  I know him, I consider him a friend, and this accusation is beneath him and regardless of the intention it is deeply personal to me.

I reached out to Brent.  Brent and I DM'ed very very ridiculously late at night.  Brent I can't thank you enough for taking the time to reply.  I hope to talk to you soon!

I completely understand Brent with the 24 HOP.  The reason I reached out to him was because of his comment on Kendal's blog.

In the comment's Brent had this reply:

We discussed 2 different issues over DM.  One is the transparency of the process the other was the selection.  Giving vendors preferential treatment, and that this wasn’t the case here.  Brent didn't have an issue with the Pragmatic Works folks having sessions and understood the level of community involvement that we have.

His issue was transparency.  I was really glad we could discuss this, in-digital-person.  Concerns like that should be communicated amongst friends so false insults do not fly.  I consider Brent a friend, it meant a lot that he made himself so readily available to chat.  It is what I would hope for in a friend.

This is how we should handle these things.  If you have a concern with something I'm doing, reach out to me.  

I remember well what it was like to be a simple DBA that looked at speakers at conferences with awe and wonder.  Seeing people like Brian Kelly and Andy Warren, both of whom I know, comment on this blog and not try to reign in the personal attacks is disheartening.  Andy’s were not inflammatory, but they also did nothing to suggest I or my other co-workers were above the board.

I understand I haven't been at this as long as you guys.  I'm not an MVP.  I've only been speaking the last couple years.  

As a somewhat new member to all of this, I would ask the people that are supposed to be respected Sr. members of the community to conduct themselves with a little more Integrity.

If you know me.  Yet you would say these type of things about me, how does that make new people feel looking at our community from the outside.  Do you believe it makes them want to volunteer and participate in it?

INTEGRITY

My father taught me as a child you only have your integrity once and you should not waste it.  This means something to me.  When I invest in something, I invest wholeheartedly.  I cannot love with half my heart.  I cannot commit to something while sitting on the fence. If I did not earn something then I do not want it.

The greatest things that we get in life are the things we struggle to achieve.  It is only through the labor of the struggle that the fruits of success are realized.

This year I have presented 26 times.  From New Hampshire, to Boston, to Puerto Rico, to Orange County CA, to Denver, to Phoenix, to Atlanta, to Portland, Tampa, Orlando, and more.  I have done deep dives, pre-con's, 1 day sessions, 2 day sessions, 5 day sessions, and this doesn't even include customer presentations.  This is all community.

I have evangelized to user groups and individuals about how they should get involved, present, participate.  I discuss with them how it will help them and help their career.

I would once again point to my co-worker who has not yet delivered their first SQL Community presentation said to me "And you wonder why new people feel intimidated.  I would hate it if they were talking about me".

IT’S NOT BUSINESS IT’S PERSONAL

We've all heard the phrase before "it's not personal its business".  It is typically used as the justification for doing some pretty crappy stuff.

There are some people out there that believe participating in the SQL Community is all about marketing.  That it's business.  Being out there and participating gets them business.  If it is business to them, fine.  It's not to me.  To me the SQL Community is personal.

Right now I am away from home.  I'm away from my kids.  I presented at a user group in AZ last night.  I didn't get paid for it, I didn't get "new" business leads.  As a matter of fact I spent 15 minutes of my 1 hour presentation encouraging people to volunteer.

Why?  Because I love this community.  I have received a lot in my life from the SQL Community.  I have a job I love, I've made new friends, and I’ve traveled to new places, volunteered in ways I never imagined possible.

I truly believe that within every person there is a story waiting to be told that we all want to hear.  It could be brought to life during a presentation on Professional Development, a passionate Deep Dive, or a harrowing tale of lessons learned in the trenches.  When I present I tell people there is a story in each of them that I would love to hear.  They just need to have the faith in themselves to present and the possibilities of what they can do from there are endless.

This isn't business to me.  I would never invest this much time into something I didn't love.  It's personal.

Suggesting that I submitted to the same process as anyone else and received preferential treatment isn't business.  It's personal.  And it's wrong.

I hope from here we can clear the air.  If anyone would like to talk to me about this I’m happy to.  From here on out though please separate criticism of the processes from those that are here for all the right reasons.

As always Dear Reader, Thanks for stopping by.

Thanks,

Brad