(scottish) sql bob blog

rss

Some thoughts of your typical data shepard / data groomer / data dance teacher sort of person.


Strengths and weaknesses

Someone was reading one of my previous blog posts and noted a mistake.  I was very thankful that the person had taken time to let me know.  Whilst pondering this it got me thinking about managing my strengths and weaknesses.  There is a saying develop your strengths and manage your weaknesses.  The first step is to identify your strengths and weakness. Let me list a few of them below;


Weakness

Written English - yes, it's ironic that I choose to spend time writing a blog, given that my spelking and grammar is one of my weakness.  Disciplining myself to write a blog forces me to use the tools that I have to help me manage that weakness.  Tools such as a spell checker is a heaven-sent tool.  There is another tool called Grammarly, which is a combination of a spelling and grammar checker.  This tool makes an excellent crutch :-)

Social skills - despite starting and helping to run the Glasgow SQL server user group.  My soft skills are not my strength.  It would be fair to say, social interactions are those which I find the most challenging.  One T-shirt slogan 'I like to party (and by party I mean read books)' I can identify with.  One approach I take to manage this weakness is to read books quite literally, and so I have read quite a few books on soft/social skills.  These have taught me a few strategies and techniques I use in everyday life.


Strengths

Finding solutions - it's what I do, give me a challenge and I will find a solution.  During an interview for a role, and an issue was raised regarding getting reports emailed automatically to managers.  The company had tried various solutions none of which worked, over a period of a couple of years.  The solution took me over 6 months, involved some VBA, a spreadsheet, and an SSIS package.   I was able to deliver a solution which worked.  The solution was not pretty or elegant, that said it met the specification and most important delivered with the constraints that required to work within.  Many months after leaving the company it was a delightful pleasure to hear my solution was still in place being used.


Having taken time to recognize my weaknesses and strengths that was the first step for me to improve.  This blog post will have been read and then re-read.  Passed by someone with better grammar and spelling than myself before publishing.  This is my way of managing that weakness.  On the other hand, my strengths will have been used in other ways.  These strengths and weakness are a part of who I am.  They can help me make a positive and unique contribution.  Learning to work with them is what makes me just that little bit better each day.


Speaking at Data in Devon 2019
 
unsplash-logo Priscilla Du Preez

The email telling me that I had been selected to speak was to say the least a surprise.  My session “Soft Skills for Success” had been accepted for Data in Devon 2019.  Yes I am very excited about the opportunity to speak in Exeter.   My last time in Exeter was a school holiday many years ago, so the opportunity to return that beautiful part of the country is wonderful surprise.

It might seem a little strange that I was surprised that my session was accepted.   However, I have been submitting sessions for a while now, most of which have been unsuccessful.  This pattern is much like the one I experienced when I decided to moved careers into IT a couple of years ago and I was applying for IT roles.  One of the lessons I learned during that time is that you are going to fail more than you succeed.  So it pays to keep trying and mostly importantly learn from each failure and success.  The current lesson I am learning is all about abstracts, how can I improve them? make them better?  As I know if one strategy does not work, then I need review it, make a small change, then try the changed strategy, till I find the one that works, so that’s what I am doing with my submission abstracts. 

To be invited to speak is to my mind an honour and a privilege.  Why?  People who I see as peers and who I respect have reviewed and considered the abstract that I have submitted, then invited me to speak.  They are also putting their faith in me that on the day I will be there and will deliver a session which people will want to see / listen to / learn something from.  When I get there on the day, yes, no doubt I will be nervous, worried, and have checked everything at least twice.  Before the getting to the room on the day, I will have rehearsed the session, reviewed it been through it more than once.  Just now I am working on tweaks to the session just for Data In Devon, if you want to know more you will have to attend the session.

The topic “Soft Skills for Success” is something that I am passionate about.  So, I will be giving it my all.  Like many projects that I work on, what people see is the final, smallest part of the project.  Beforehand there will be a lot of unseen hard work to make it look good.  The prize is worth the price, which is to be invited to speak to my peers about a topic that I am passionate about.


#SQLGLA 2018
#SQLGLA 2018

Forgive me whilst I indulge in some nostalgia first.  Whilst at SQL Bits 2016, I finally made the decision to start a SQL user group in Glasgow.  If I remember correctly Craig Porteous attend the infamous SQL Bits party and met a gentleman dressed as a Wookie  (William Durkin).  Now Glasgow has a growing SQL server user group (thanks to a dedicated hard working team).  Not only that we just had our second SQL conference!  (Yes SQL Bits has lot to answer for ;->)

 

Funny image


SQLGLA was a fantastic event it has left me with some wonderful feelings.  This blog post is part thank you to those involved, also just to express some of my feelings / experiences of the event.



unsplash-logo rawpixel


Organizing Team
 

Craig Porteous, Louise Paterson and I are the people who organised this year's event.  I felt we were a team (this is a theme, by the way).  Each of us contributed to the success of the event, in a different way.  The success of the event was not down a single person in my opinion. It was about us all coming together to make it a success.  Craig did put a lot of work into making the event what it was.

Photo by William White on Unsplash
unsplash-logo William White


Volunteers
 

There are few words to express my gratitude about our team of volunteers.  As an organizing team, we have all volunteered before so we knew what is expected of volunteers.  There was a lovely mix of those who have done it before and few who have never done any volunteering.  What a team though, they all worked really hard.  Speaking personally, I am so proud of them, they made this event for me. Not once did I have to worry about if something was done or not being done.  They just made it happen.  Whilst I have said this before I cannot thank them enough for being such an amazing team, they exceeded all my expectations.



unsplash-logo DESIGNECOLOGIST


Speakers 

Last year thanks to William Durkin we had such an amazing lineup, and yet this year lineup was even better!  A few days before the event I was looking through the list.  It would be a fair comment to say I was blown away by the quality of those who choose to speak at our event.  The feedback that I have heard so far the attendees also agree 🙂  Looking the depth of experience and knowledge that was shared, was to me awe inspiring.  Whats even better is they all came to Scotland to share their knowledge and expertise with us.

 

unsplash-logo Sandy Millar

 

SQL Family 

It’s a phrase that I've seen often on social media, these are not just words it's something that can be seen and experienced in real life.  To experience it is very humbling and gratifying.  A few weeks before the event I was contacted by Chris Taylor (@SQLGeordieone of the speakers.  The speakers had decided they wanted to get something for Craig & Karen Porteous who are expecting their second child.  It was my privilege and honor to present the gift on their behalf.  Hopefully, Craig will forgive me one day for gate-crashing the closing presentation to present the gift?  As Craig knew nothing about this gift. 



T-shirts 

To make the event something that little different we wanted to find a design for the t-shirts that was rather special.  Having worked with Emily Chappell over the years on various projects, her quirky designs and sense of style really works for me.  So I suggested we should ask Emily for a design for the t-shirts.  The first design was not what we wanted.  So next we all got together in a coffee shop at lunchtime.  We had a chat did some brainstorming,  Emily then sent back a design which we all loved (see picture below).  Personally, I’ve never been to a technical conference where they sold the t-shirts :-)

 

unsplash-logo rawpixel


Next?

First there are few housekeeping duties to take care, which we are just finishing off just now.  Followed by some discussions to see what will be the next step 🙂  All I can safely say is keep looking there will be some exciting news soon....