Category Archives: Uncategorized

Is ROI for Vendors Worth the SQL Saturday Investment?

networkingPiggy backing onto the recent SQL Saturday post here in Louisville, I wanted to take a more in-depth look, from my perspective, on how vendors all fit into these events.

Having the opportunity to work alongside these vendors has been both a learning experience for myself along with forming new bonds along the way. Louisville has been fortunate enough to have some of the best vendors in our industry who see the importance of investing time in others for a few reasons.

  • Networking
  • Getting their products name out
  • Growing their local community pool
  • Bringing exposure to their company

SQL Saturday events provide a much more intimate setting with a lower number of attendees. Example our event for the past two years had over 220 users sign up. This is a much smaller scale then say what a PASS conference has signed up where over five thousand of your closest friends attend.

The SQL Saturday events allow the attendees to get up close and personal with the vendors on products that they may or may not use. That’s great Chris, but I’m a vendor and how would I get ROI out of it; because at the end of the day if I want to sponsor an event there needs to be some gains on my end?

This therein is a valid question and one that is not taken lightly. In speaking with a vendor they had this to say about our event:

Our sponsorship of SQL Saturday allowed us to connect with a wealth of developers and DBAs, in a single day. The event was organized, productive, and time well spent furthering our business in Louisville.

I am starting to see soft metrics, such as intangibles, in determining the business value sending data professionals for respective vendors to such events. What kind of intangibles? They’re the stuff that doesn’t show up in traditional cost-accounting methods but that truly makes a difference in maximizing the potential knowledge growth of the organization. These include employee learning, vendor interaction, business relationships, and networking. Some of these are clearly more quantifiable than others, but all are important to a vendors success.

Some outside thoughts on how ROI for vendors is applicable:

  • You have to evaluate your audience.
  • Make sure your input channel, in this case your interaction with attendees, has some new features for viewing.
  • List of attendees for potential future clients.
  • Make your presence known prior to event (outside the marketing done by said event).
  • Commitment from potential attendees
  • Flexibility

End of the day, vendors are a huge part from all angles in regards to SQL Saturday events. Getting a great local base at events like this continues to build and solidify companies advancement in the technology space; specifically around the Microsoft stack.

Conclusion

If you are interested in getting involved you can check out or view upcoming schedules at the SQL Saturday home page here.

From personal experience I know that talking with vendors at said events it has opened doors and opportunities for business in my current and previous shops along with building a network base for future discussions.

T-SQL Tuesday #080–Round Up

TSQL2SDAY-150x150The roundup is finally here, and cheers to all of you who participated. We had a great turnout this month with many returning participants along with some newcomers.

We had a wide range of topics with many great insights from everyone, but don’t take my word for it. Check out the links below and see what your colleagues from around the SQL Community had to say:

 

Jason Brimhall – SQL Server Desired Enhancements

Riley Major – The Gift that Keeps on Giving

Jon Morsi – SQL Server 2014 Service Pack 2

Melissa Connors – DBCC CloneDatabase

Aaron Bertrand – Create Or Replace

Lori Edwards – SQL Server R Services

Robert Davis – SQL Birthday Present

Allen Kinsel – SQL Server’s Birthdays

Matt Gordon – Change Always On Endpoint Ports

Bjorn Peters – My Open Points for SQL Knowledge

Chris Bell – The Gift of the Basics

Andy Yun – Give Yourself a SQL Gift

Kenneth Fisher – Default Database File Sizes

Dave Mason – SQL Server Shutdown Event

Shane Eillis – Can Powershell Get What T-SQL Cannot

Raul Gonzalez – Using the Query Store For Read Only Database

Rob Farley – Finally SSMS Will Talk To Azure SQL DW

Kennie Nybo Pontoppidan – I want DBCC ConeDatabase Available on all (supported) Versions of SQL Server

Ginger Grant – SSIS Projects, Packages, and Deployments

Mike Walsh – Happy Birthday Chris, Have Some Changes

Wayne Sheffield – SQL Gifts

As you can see we had a great turnout and everyone continues to share their knowledge daily, weekly, and monthly basis. Thank you again for all who participated, and a big thank you to Adam Machanic (B|T) for allowing me to host another block party. Hope you all have a good one and look forward to next month.

images

Is Today Your Last Day Working With SQL?

Please entertain this thought for a moment – If today was your last day working with SQL how would you spend it?

Now, this post is assuming you, as the reader, are working with SQL in some form or fashion; however take the question and apply it to some other form of technology if that fancies you.

I started thinking about this question not long ago. It got me to ponder (as my friend Tom Roush (B|T) would say ) a bit . If I woke up one morning knowing it was my last day as a data professional to work with the SQL platform how would I spend it?

Would those arguments with developers that have been encountered through the years be at the forefront, or maybe it is the conversation with my storage administrator on how much is being consumed.

Perhaps it is taking that extra moment to answer someone’s question instead of ignoring them due to “priorities” that need to have some form of completion.

As I type this I have my PASS Summit 2015 credentials in front of me and I am reading words such as “community zone” and “community appreciation party”. Have I done enough to help better this SQL community?

Answer to all those questions is – I don’t know.

I tackle each day as a new opportunity to impact something or someone. Whether it is in the shop, with some form of technology, a family member, or a friend – I think what has put some things in perspective for me here lately are life events.

My dedication to SQL and the community that I so richly am blessed to be a part of has not and will not waver – I’m just a data professional looking at a question that I really am not sure I can answer at this point in time.

Have you ever poured your heart and soul into something – yes many of you have and will continue to do so as will I.

I see posts on topics such as “What will I tell my future self” and “Someday”; those types of posts are starting to hit home to me. For me, everyone is different, but I do feel it is important to tackle each day as a new beginning.

Things can change in a heart beat; we work with some pretty awesome technology but even more so some pretty talented data professionals – don’t take that for granted. There will be a day and a time to hang it up and when that time comes, I hope I can look back and say with 100% certainty that I gave all I had, left it all out on the field, and that I have nothing left in me.

  • Continue to learn
  • Continue to make an impact
  • Continue to fight when you feel like fighting no more
  • Continue to be the best you can be; that means be the best you that you can be.

So, I ask you – If today was your last day working with SQL how would you spend it?

T-SQL Tuesday #75 Invitation: Jump into Power BI!

SqlTuesday_thumb.pngThis month the talented Jorge Segarra (B|T) hosts the T-SQL Tuesday block party, and he has chosen the topic of Power BI.

So, what exactly is this thing called Power BI? I admit, I have several friends and colleagues who have dove into this type of technology, but I have not done so in great depth yet.

I think Jorge pretty much summed me up in his first paragraph when he says, “If you’re reading this and thinking ‘crap, I’m not a BI person!’, don’t you fret. My intention is to make folks who normally don’t use BI on a day to day basis try their hand at creating cool new visualizations and reports with Power BI and seeing how the other side lives.”

So what did I do? I think the below tweet sums it all up:

image

I downloaded the Power BI Desktop from Jorge’s link and was immediately amazed by the simplicity of ease in working with the utility. I had some dummy data laying around for drive space so decided to hook up to the data source and start messing around with it.

The data set populated through some clicks and a query provided by me led to the data set being available. Great; next what caught my eye was the visualization section; which it would, right? Everyone likes a good picture with analytical data attached.

image

Now, in my data set I am capturing dummy data, because we would never use prod data for a post, right? I have 5 drive letters (C,E,F,G, and H); I immediately went for the filters for the visual effects:

image

Once my filters were in place for the given time period I could quickly tell what I was dealing with from a visualization form of view:

image

In my short amount of time using this product I can definitely see a lot of usefulness that I could get from it. I am beginning to look at ways to incorporate this into some current presentations both in the shop and out of the shop that will better define my data sets to different groups (know your audience).

So Jorge, thank you for motivating me to dive into this a little bit. While I have only just scratched the surface with it, I see glimmers of how powerful this could be in my data professional journey.

What is T-SQL Tuesday?

T-SQL Tuesday is a monthly blog party hosted by a different blogger each month. This blog party was founded by Adam Machanic (B|T). You can take part by posting your own participating post that fits the topic of the month and follows the requirements below. Additionally, if you are interested in hosting a future T-SQL Tuesday, contact Adam Machanic.

New SQL Blogging Challenge

SharingI recently came across Tim Ford’s (B|T) challenge to the technical blogging community. The challenge is to write one introductory level blog per month for the community.

A simple statement with a profound substance to it. How many times do you and I take for granted the knowledge we have and share both privately and socially on a daily basis?

More recently, I was approached with a question along these lines that I interpreted to be simplistic in form. The data professional however was sincere and it made me realize that there are still a lot of gaps to bridge…..and more so, who am I to judge what is simplistic or not?

It’s time to set ego’s aside and the game of “can you top this” with our knowledge and continue to bridge these types of gaps amongst members in our community and beyond.

No question is a “dumb” question for it is how we learn and grow as professionals. To the new community member or data professional keep asking those questions and being ambitious.

A huge thank you to Tim for bringing this challenge more to the forefront; it is something I, myself, have taken for granted. It was an eye-opening experience to know where I came from, where I am now, and where I want to go. May we never stop learning and sharing.

Onward….let’s roll!

Community Involvement–Why Wait?

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

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

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

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

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

Blogging

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

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

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

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

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

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

Social Media

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

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

2. LinkedIn

3. Facebook

4. Instagram

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

PASS Active Member

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

Learn more about the PASS Summit here.

SQL Saturday Events

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

Mentor

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

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

Recap

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

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

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

PASS Summit Key Note Day 2 – Recap

PASS_2015_200x200

As I sit here in an offshoot of the convention center, I started reflecting back to this morning’s keynote for various reasons. It got me thinking about 3 key words for myself when it comes to this conference:

  1. Impact
  2. SQL Family
  3. Dedication

How did I come to these three key words for myself? I’m not sure I can do them justice or at this time even provide detailed thoughts as my mind is in overdrive right now. I don’t like blogging anything without a good proof read by a second pair of eyes, but in this case I’ll type now and ask for forgiveness later.

Impact

I’ve seen this all week thus far from the SQL Saturday meeting I attended on Monday, the after parties I have the fortunate opportunity to attend, to the keynote shared today and the PASSion Award winner. Stop a minute, look around you. The hustle and bustle of the conference is everywhere around you. From first timers being overwhelmed, yes we were all in that situation at some point in time, to the speakers heading to their sessions, to the vendors spending all day at their booths. You may ask how is that related to impact? Believe it or not each person here at the PASS Summit has impacted someone or somebody in their career whether you know you have or not. The Keynote given today did just that, each speaker today spoke to someone in that room. If it wasn’t you then they reached someone else.

SQL Family

I’ve had numerous conversations with friends, SQL Family members, people I have no clue who they are,  and people who came up to me and knew me and introduced themselves. As I sat at the bloggers table this year I stood up and looked back at the audience and was amazed that we do in fact have a close-knit technical community who enjoys learning immensely. That’s evident by everyone being here. As a SQL Family there will be times when people are struggling, and yet I see from all over this convention people encouraging each other. It will not always be easy; it wasn’t meant to be easy. Hard work and dedication goes into one’s career and I iterate that it is an awesome sight for me to see people in careers bond together to forge new relationships, expand existing ones, and help encourage where they can.

Dedication

Today I had goose bumps as Dr. Nehme and Dr. Dewitt announced that this would be their last Keynote. First of all what an inspiration these two individuals have been for our community. As I looked at them I thought about some others in terms of dedication:

  1. Volunteers – have you thanked anyone today?
  2. Speakers – do you know how much work goes into preparing to speak?
  3. Attendees – you are dedicated; if you weren’t then you wouldn’t be here
  4. Vendors – vendors are interacting all day long along with setting up their booths etc. Job well done this year.
  5. Sponsors – if it wasn’t for these fine folks then we wouldn’t be able to attend what is being put on for us.

**Humbled to be here….thankful for the opportunity….and looking forward to moving this community forward.

Live Blog – Pass Summit Key Note – Day 1

Security as been invested more in SQL Server 2016 than any other.

Protecting your data at rest and in motion with no impact on database performance. Always Encrypted in 2016 will make it a more simpler task to protect your data. This is huge for the data professionals out there that struggle day in and day out with how to protect their data.

When you are using Always Encrypted you can instinctively choose which columns you would like to encrypt (keep in mind the size of the table does matter when  you build it).

Moving on to Stretch Database….

Cutting the storage costs with stretch database and yes…you can utilize Always Encrypted into Azure.

Live Blog – Pass Summit Key Note – Day 1

PASS_2015_200x200Joseph Sirosh, Corporate VP of Data Group Microsoft talks about zigabytes….what!!!!!! Predominately in the cloud is where data will be moving; yes folks let’s get used to this now.

Age of Hardware and Automation to Age of the Software and digitization we have grown profoundly over the last 50 years. Guess what, Joseph goes into depth about the thew new age…the Age of Data and Intelligence about the customer experience.

Truly amazing how data in everyday life from healthcare with Cortana is all driven in the new Age of Software that improves patient outcomes and this is just one of the avenues that data is being used.

DocuSign has 50 million users with over 50k users joining every day; guess who drives the back end to DocuSign…….SQL Server. Eric Fleischman from, DocuSign, is the Chief Architect and VP of Platform Engineering talks about how the company can start to scale and answer deeper questions and good to hear of the newer technology that they have moved to.

A mission critical OLTP system is important for companies such as DocuSign with high performance data analytics along with end to end mobile BI. SQL Server 2016 is meant to be the method to support all of these methods with the Cloud first approach.

Shawn Bice, “companies who embrace data”…really got me thinking…does your company embrace data?

SQL Server 2016….let’s roll

  • Everything is built in
    • Industry leader in Mission Critical OLTP
    • Most Secure database
    • Highest performing data warehouse
    • end to end mobile BI on any device
    • in-database Advanced Analytics
      • R + in-memory
  • Dramatically simplify HA and DR
    • Enhanced AlwaysOn
      • Easy Setup – of on -premises and hybrid cloud HA and HR
      • Load balancing – of readable secondaries
      • Fast fail over – on-premises or to cloud
  • Remove the complexity of big data – T-SQL over Hadoop
  • Real-Time operational analytics
    • R built-in to your T-SQL
    • Real-Time operational analytics without moving data
    • Open source R with in memory and massive scale – multi threading and massive parallel processing

As you can see SQL 2016 has some phenomenal features on the way.

Live Blog – Pass Summit Key Note – 1

PASS_2015_200x200PASS Summit Key note is off the ground and running…..

President Thomas LaRock talks about the 16th annual meeting that is taking place and the #sqlfamily. This event is really like a family reunion with over 58 countries and 2,000 companies that are here to get this party started.

THIS IS OUR COMMUNITY

One of the points Thomas made that I found it to be really good is that PASS needs to hear from you and wants to hear from you; that is part of being a family. Data professionals have a desire to grow and build out your professional network, because of that be that voice; be the difference maker.

Being part of PASS; things are rapidly changing; providing thoughts of where you came from and where we will be in 15 years. One reason for this, and a great point, is the community and the countless of volunteers. Consistently looking at ways to help others is what has made this community great and securing the future for additional growth and members as we move forward.

GET INVOLVED – Connect, Share, Learn – let’s keep moving the community forward

With over 200 Technical Sessions this will shape up to be one of the best yet; plenty of topics ranging from WIT, Speaker Idol, SQL Server Clinic, and please don’t forget to utilize #sqlpass and #summit15

Amazes me the sponsors that help make the community events take place; big applause should be directed to them and as you go through week talk to them; thank them, and yes as Thomas said, you can hug them IT IS OK!!!

Proud to be a member of the #sqlfamily…..let’s roll