Tag Archives: SQLServerPedia

Is ROI for Vendors Worth the SQL Saturday Investment?

Posted on by
2

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.

Are SQL Saturday’s Worth It?

Posted on by
7

VenueThis past weekend I was fortunate enough to be a part of Louisville’s (for those local the ‘ville) SQL Saturday event held at Indiana Wesleyan. Most of you who end up on this site are probably familiar with it, but for those that aren’t familiar with SQL Saturday events you can check out their site here.

Now to put on an event like this is nothing short of an incredible effort from volunteers, sponsors, speakers, and attendees. Being able to help co-organize the one here in Louisville has been a humbling yet gratifying experience. Let me see if I can break it down a different way for you, the reader, who may not have had the opportunity yet to volunteer or attend such an event.

Volunteers

You can see these people usually with matching shirts on and a lanyard with their name and a ribbon that only says “volunteer.” In the past when I’ve attended such events I knew people helped out to put something like this on, but never in my wildest dreams did I envision all that it took until I volunteered.

Volunteering is not for glitz, glamor, or glory. Instead volunteering is what helps the cogs in the wheel move to get the steam engine running down the track. It is the staple of helping afford the opportunity for free learning to attendees and colleagues in our field.

Many, many, and many hours go into planning and organizing an event; if you attend one of these events make sure you seek a volunteer or organizer out and say thank you for their time; they are doing this for free and on their own time away from their families.

Mala Mahadevan (B|T) as a founding organizer of our event I thank you for allowing me to be a part of it these past few years.

Sponsors

Over the years, SQL Saturday Louisville has been blessed with some great sponsors. For the previous two years, John Morehouse (B|T) and I have taken great pride in working with some stellar companies. Without them, we would not be able to do what we do which is concentrate on the attendees and helping people learn.

Our Gold sponsors this year were:

Gold

  1. EMC
  2. Farm Credit Mid-America
  3. Imperva
  4. Microsoft
  5. Republic Bank
  6. Pyramid Analytics

 

Our Silver and Bronze sponsors this year were:

SilverBronze

  1. Idera
  2. PASS
  3. PureStorage
  4. Tek Systems
  5. Click-IT Staffing
  6. Homecare Homebase
  7. Datavail
  8. SQLSentry

A major thank you for all of their contributions and it is always a pleasure to work with all of you.

Speakers

It always amazes me at the number of speakers we have who send in sessions to our event. These speakers are people from all over the U.S. who are willing to travel and give their time so attendees can learn. Getting to spend time with each of them is not always an easy task, but always thankful to catch up with many friends at the speaker dinner.

It was awesome to see the attendees interacting with the speakers asking their questions and getting insight into the variously presented topics. And, because of so many good sessions to choose from, there was a buzz in the air.

As is the case with the volunteers mentioned above, speakers also travel on their own dime, away from their families – a simple thank you goes a long way. Also, for these sessions, I do want to point out that feedback cards are provided; please please please take a moment and make sure you provide good insightful feedback to the speakers. Each speaker uses this feedback to improve their sessions or have take-a-ways on what may or may not have worked. Yes, folks, these are important!

I won’t list every speaker we had; that is not the intent of this topic. But I will take a moment and say to each and every speaker who attended SQL Saturday Louisville 531 we thank you.

Attendees

Two words – – THE PEOPLE. As I have stated, these last two years has been nothing short of amazing. Seeing light bulbs go off with attendees who are learning from some of the best, and having discussions with attendees is why we do what we do.

When individuals come to us stating it was their first time at the event, and they had no idea that there is a local Louisville SQL User Group opens the doors to help reach people in our tech community.

Steve Jones (B|T), who is part of my Fab Five, talks about Dreaming of SQL Saturday. If you have not had a chance to read his post, check it out. Attendees travel from quite a distance. Which tells me the people are eager to learn.

Conclusion

So, the question I opened with “Is SQL Saturday Worth It?” Considering what I know now versus what I knew then the answer is yes. Personally, being a product of these types of events, I am living proof of what can grow from the SQL Community.

Whether you volunteer, speak, sponsor, or attend, all of these make the wheel turn. It’s a team effort with a lot of hard work. So, next time you attend one of these events, please don’t take them for granted.

Here is to continued learning, as we move forward to grow this community!

Community Involvement–Why Wait?

Posted on by
1

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 Recap and Experience

Posted on by
Reply

IMG_20151027_142416The day finally came and I was fortunate, no I was blessed to be a part of the PASS Summit held out in Seattle, WA. This year would be my fourth year attending in five years. I did miss when it was held in Charlotte, go figure it was closer there to me. In any sense this year did not disappoint.

It’s almost hard to put into words the experience you get when attending, by that I mean the learning, sessions, people, community, and much more. I am always pleased to see all the first timer ribbons on badges as I remember when it was my first time attending the conference and the overwhelming factor you may feel. I try to make a point to seek out a few first timers and introduce myself, oddly enough I had a few actually say hey, your Chris this time around – very weird to me.

I doubt I can do it justice with a blog post, but nevertheless I will do my best to let you have a look into what kind of an experience can be had by attending such an event.

FreeCon

IMG_20151102_135407I started my journey a bit earlier due to being invited to Brent Ozar Unlimited (blog | twitter) FreeCon put on by Brent Ozar (twitter), Kendra Little (twitter), and The Doug Lane (twitter). A full day of learning on a wide range of topics got the week off started on the right foot. I’ve had the opportunity to speak to Brent in the past; this year I had the pleasure of getting to know Kendra and Doug a little. All three are some phenomenal and stellar individuals who truly care about the community.

One thing that stuck out to me was the authenticity shown by both Brent, Kendra, and Doug along with the 50 or so of us who were asking questions. It was very nice to hear real world issues from other colleagues and walking through thought processes. Very captivating.

Some of my cohorts in crime from the community from Mike Fal (blog | twitter), Mala Mahadevan (blog | twitter), Gareth Swanepoel (blog | twitter), Mike Hillwig (blog | twitter), and Vicky Harp (blog | twitter). The event was truly an awesome experience and one that I am not taking for granted. I walked away from it with a ton of notes and things to implement in my own career!

Live Blogging

IMG_20151029_075507Interesting enough I found myself at the Live Blogging table for some events this year. I was able to cover the two Key Note addresses on consecutive days right after breakfast, and let me tell you this was one of the highlights to my week. I’ve attended the Key Notes in previous years; however picking up key pieces was essential along with having a good plug-in to the blog for doing live blogging. I did some homework prior to and talked to a few individuals who had done live blogging before at the event just so I could prepare a little. Being able to capture events such as Dr. Dewitt and Rimma Nehme (twitter) talking about their last Key Note at PASS Summit was something that sent chills through me.

It was truly and honor and privilege to be a part of the event with so many people I have looked up to in my brief time in the community – Tim Mitchell (blog | twitter), Allen White (blog | twitter), Jes Borland (blog | twitter), Erin Stellato (blog | twitter), and many more.

The People

IMG_20151028_080141This is definitely one that I could spend a whole topic on from community zone, to side bar meetings, to talks with vendors, and the list could go on. I will say that I spent a majority of time having face to face meaningful conversations with peers, vendors, and colleagues. I cannot list them all here nor would I attempt to; many of you took the time to come up to me – even individuals who I did not know or met before and I appreciate that. I wish I could have spoken to more individuals, but if you ever see me around feel free to reach out.

Community Zone and Community Wall

IMG_20151027_122501This was some time well spent where you could meet friends, peers, other data professionals from all walks of life. I was first enamored by this last year in 2014; it’s a cool place to hang out or just detox from what you have learned. Many insightful conversations happen here; not just from work load or issue perspective, but ideas on what others are experiencing and doing as well. If you have not taken advantage of the opportunity to speak to some of the community members I strongly urge you to if you make it back. Community is a big aspect of the PASS Summit and you will not be sorry for taking advantage of such

The Sponsors

IMG_20151028_180828One of the big reasons we can do what we do are the sponsors, volunteers, and tireless countless numbers of workers who put in hours, money, and sweat into pulling an event off for 5k-6k individuals. A huge thank you goes out to them for their hard work and effort.

I did like the fact, not sure how many others feel this way, that PASS Summit recognized the sponsors where people could see as they walked back and forth to the community zone, breakfast and lunch area, and vendor area. It allowed me to take a quick snapshot of the pic to the left.

If you haven’t had time yet, some of you may even be customers. Shoot them a thank you note; they do appreciate it.

For me specifically a big thanks to Red-Gate, SQL Sentry, PureStorage, and Linchpin People.

Argenis Without Borders

IMG_20151029_125707This year alone this initiative brought in over 22k dollars. Argenis Fernandez (blog | twitter) and Kirsten Benzel (twitter) started this a few years back; now some of you maybe have wondered why people were all dressed up for in the middle of the community zone; well certain targets needed to be hit for certain, shall we say, fun to take place. Not to many places you can see people dressing up and Mike Fal playing a trombone. Heck they even through in some individuals getting tattoos since record numbers were broken.

In all seriousness this is for a great cause put on by some great people. If you haven’t had the opportunity to be a part of it take a look here; every little bit helps.

Highlights

There were a ton of highlights for me. Conversations that were had along with meeting some new people along the way such as Warwick Rudd (blog | twitter), Ben McNamara (twitter), Karla Landrum (twitter), Alex Yates (blog | twitter) to name a few made my day and getting time to spend with a lot of my friends made for a good week.

I am pleased to say that I will begin helping with the HADR Virtual Chapter in the very near future. More to come on that in future posts, but am thankful that John Sterrett (blog | twitter) and David Klee (blog |twitter) are taking a chance and investing some time in me.

Sessions were strong this year. I got to see a few from my good friend John Morehouse (blog | twitter), Mike Fal’s awesome session on PowerShell, to the outstanding session Erin Stellato gave on XE. If you missed any make sure to visit the PASS Summit website and purchase the sessions; you won’t be disappointed and it is an investment for your company.

Closing

Being part of the PASS Community is something that has changed my career. I’m living proof that what we do on a daily basis works and is working. If each one reaches one then our mission is complete ~ I’m thankful yet humbled to be on this journey.

It’s always a pleasure to see everyone at PASS Summit and look forward to many more conversations, collaborations, speaking engagements, and demos. Let’s keep moving this community forward one day at a time and keep investing time in others. What you do today influences someone else tomorrow – Let’s Roll!

IMG_20151027_151532

Perspective

Posted on by
5

thNP3V0VT4It’s one small word, but that one word can pack an awful powerful punch. I got a severe dose of it Friday night. No, I won’t go into the great detail that provoked this word to come to light. What I will do is recognize that it has taught me some valuable lessons especially in my every day work life.

We live in a fast paced society. Work will never cease that’s a given; when is the last time you truly stopped, looked around, and appreciated where you are at in this point in time?

I used to struggle a lot with not blogging enough, not giving back to the community enough, not submitting to speak enough, arguments with other data professionals on what is the right way to do things versus the wrong way to do things, and the list could go on and on.

I look at SQL Family and what does it truly mean to me? I take great pride in my work, the people I am involved with daily, the many issues that come up that provide new solutions waiting to be found, but SQL Family is much more than that. It is shown daily by the likes of you and me. You see it in the generosity when one of our own passes away, you see it in others who rally around a good cause, you see it when a seasoned community member takes a newbie under his/her wing to guide them, and yes you see it shown when you receive heart breaking news that we all endure through the journey we call life.

There are intervals in life when you stop and asses priorities; nothing wrong with that. You start to look at if the he said she said argument was even worth it, you blast a newbie because he made a dumb mistake due to the fact that they just didn’t know, or you get on some ego trip because you believe you are entitled to something.

There will be things you can control and there will be things you can’t control; as a data professional and proud DBA I will continue to do the best I can day in and day out. I come from the school that you work hard regardless of the situation. You won’t find perfection, you won’t find a guy who knows it all; what you will find is a guy who has a passion for the SQL Community and a passion for learning and honing is craft.

To the new community member the days will not always be perfect; heck the days you will sometimes wonder what the heck you got yourself into; enjoy the ride. Don’t beat yourself up for things you think you could have done better; learn from them and move on. Realize that SQL Family IS the people, the interaction – it is what makes it thrive.

For the ones who have been around for a long time, with as much respect as I can muster, I just implore you to realize that when life does happen outside of our SQL walls; don’t let that time go by wasted. You need to cherish every minute of it; we (me included) rush around getting to the next event, next speaking engagement, next post and if we aren’t careful we will let those outside moments pass us by.

Some will take this post as me saying not to worry about the security breach that was caused by a pointless mistake, and some will read too much into it and be wondering if I’m speaking at anyone in particular. I get how it all works, these are just intended thoughts of mine that if I can take to heart myself, then it might help me in the future to become a better data professional and DBA.

Work hard, cherish the moments, and realize that taking one day at a time is okay.

Q and A With SQL MVP Chris Shaw

Posted on by
1

cameraThis has been a long time in the making, back in 2011 I attended a session at PASS Summit by SQL MVP Chris Shaw (B|T). Little did I know that he would become one of my mentors, good friend, and someone I’m truly thankful for. I approached Chris awhile back if he would be interested in doing a question answer session here and without hesitation he said let’s roll. So, without further ado let’s see what the mighty Chris Shaw has to say.

1. SQL Server has many facets to explore; what is one important aspect of SQL that you feel most Data Professionals tend to overlook?

I am not sure if you could call this an aspect in the traditional style.  But I think a lot of data professionals overlook the basics.  Even some of the basics of design like 3rd Normal Form,  what it is, and what are some of the ways it is different from other aspects of database design. Microsoft has done such a great job at making it easier for us to query the data, and faster for us to retrieve the data.  But my first reaction when I look into an OLTP at a 16 table join is to question the design of the database (I recall a day when it was best practice for performance that you didn’t have more than 8 joins).  I am sure there are many example where this is the best way to approach the design, I just can’t help but wonder how much thought went into a design like that.

2. SQL Saturday’s are everywhere and they are an awesome experience to attend them. Can you explain why these SQL Saturday events are so important to the community and what your favorite venue is?

Multiple aspects to this question.  First I think the SQL Saturdays are critical for a couple reasons.  The big one of course is the education that is offered at the event free of charge,  how can you beat that.  But when you look at the community as a whole I think a SQL Saturday gets people ready for A larger event such as the PASS Summit, and knowing what to expect if you have never been.  PASS Summit can be a bit overwhelming as a first timer, all the sessions, all the people and then you have the parties and the events that surround the conference.  How do you take that all in?  How do you network with 200 people on a Saturday event, what can you learn from networking with 200 people that you can apply to 4,000 people over 3 days at the PASS Summit.  Anyone can go the Pass Summit, but if go without understanding how to network, how to get involved with the event, you are missing a lot.  I pose the question to you Chris…  Did you network more during your second Summit or your first?  And was the difference because the second time around you knew what to expect?

“Second time was by far the most networking done compared to the first. Not just attending the dinners but also running into people in the hall, people coming up and talking to me off the cuff, the community zone, and the SQL Runs. I think you are correct when you say the first time you go you really don’t know what to expect. It truly is one of the best SQL conferences I’ve attended.”

I am surprised that PASS doesn’t do some sort of award for the SQL Saturdays.  I have been to 16 of them as a speaker so far and I have got to admit each one has its own flavor to it.  When I organize a SQL Saturday I try to put some sort of flare on the event, something different that you don’t get at the other events.  So SQL Saturdays that do thinks just a little bit different are my favorites.  So if you are going to hold my feet to the fire and really get me to commit to one event.  My favorite event is Kansas City.  They go well out of their way to show appreciation for the speakers.  If you are a speaker this is a can’t miss event,  the Speaker dinner is always special, and the Friday before the BBQ crawl is amazing.  Another one I would mention is the Albuquerque event, they have a very good home town feeling, and I love the home made speaker gift I received.

3. PASS Summit is a big yearly event; can you describe what the “community zone” means and why it is so important?

The community zone is a dedicated area where we as speakers and attendees can gather to just network. I believe they have always had bean bags there and it is a great time to just get off your tired feet and visit with other attendees.  What do you talk about?  Well I had a complex issue that I was working on that became the topic of discussion in the zone for a little while, I was able to come away from the event with an answer to my question.  I also learned that a couple of friends were going through a rough patch in their life, some pretty serious stuff and they still came to the conference.  I hope that I was able to lend an ear for just a while and to be a friend.

4. What’s on Chris Shaw’s book shelf?

Well due to my lifestyle I don’t have enough room for a book shelf (I am a full time camper and live in my rig).  I do however have enough digital media to make many people jealous.  Right now most of my attention when I am not working is spent on photography.  I have a lecture series from a guy name Manny, out of Florida who does this series called “Go Get that Shot”.  I spend a lot of time watching that and re-watching it.   One thing I do have on a very small book shelf is my MVP Award,  something that is very symbolic to me.

5. Most DBA’s don’t start out being a DBA, but they take various routes to get where they are at. Curious how you became involved with SQL?

Ok so this is a really long story, so I am going to shorten it as much as I can.  In 1996 I was the operational director at an antifreeze recycling company.  Our Access database went down and I had to hire a consultant that charged us an arm and a leg.  Well you know when you look at what you pay for things and you say “I am in the wrong business”, well that happened.  I started to learn Access and was talking to a guy who work in the office building next to ours.  After some discussion he told me I was asking questions that were above his skill level and he thought I could help him on this new thing they were doing.  Ended up being SQL Server version 6.0. They made me an offer that was 10k more than what I was making and bought me a personal computer for my home.  That database I designed was for Yellow Pages Inc. and the last time I looked it is still online today. Next time we are in the community zone, ask me and I will give you the full run down.

6. Like you, I was privileged to be a part of the DBA Jumpstart that John Sansom (B|T) put together last year. I’ve learned that the SQL life is a journey not a race; what do you feel a new data professional should consider most in starting out their career?

The chapter I wrote for that was telling people they need to choose between wanting a job and a career.  I am a firm believer that if you are just looking for a job, then being a DBA is not the way you want to go.  This career field requires a lot of dedication, and a lot of work hours.

7. Outside SQL we also have other hobbies; what are some of the things you like to get involved with to relax?

My favorite thing to do is take photos.  Recently I took an extra day with a friend on our way to a SQL Saturday, everyone we were traveling with wanted to go ski, but rather than do that we took a back road to Santa Fe, New Mexico.  We had a great time visiting and stopping every 20 min to go take pictures of stuff we had not seen before.  It was a great time.

8. It’s got to be asked……tacos or barbecue?

Oh that is a hard one.  Today I would have to say…  Tacos for sure.  But when the summer comes, I may be back to Barbecue.

Conclusion

A big thanks to SQL MVP Chris Shaw for taking time out of his busy schedule to drop by and answer a few questions for the SQL Community.

Impact Player Series – Part 1

Posted on by
Reply

ImpactI wanted to start this series in regards to impact players that go above and beyond in the SQL Community. Coming from a sports background this resonates well with me and by the end of the year will have a 12 person roster.

I get asked a lot when I go to events, conferences, talks, groups who inspires me. Or I get asked where do I start. There are many fine folks in the SQL Community and I cannot encompass them all; believe me this 12 person team could easily become much more.

So, who the heck is the first impact player? Being that I am from Kentucky it pains me just a little to write this knowing that this person is an SEC rival (college sports) and is a true orange fan in Florida ~ Ed Watson (B|T).

Ed is a Microsoft SQL Server MVP who I have gotten to know over the past year. His tenacity alone has spoke volumes in how he approaches speaking engagements, obstacles, issues, SQL life, basically the things that make up a data professionals life. I would classify Ed as one of those exceptional data professionals that you hear about. If you not ever had the chance to hear him speak at an event I suggest that you keep your ears open and if he comes to a town near you attend ~ you would not be disappointed.

I’ve never one time have come to Ed and him tell me not today; he is always eager to assist and help and has been a strong voice in the community.

He is a frequent blogger over at the SQL Swampland and can be found on twitter; although don’t interrupt him while a University Florida football or basketball game is on. If you choose to do so then you have been warned up front.

Check out Ed’s blog or give him a shout on the twitter feed. Truly a standup guy and one worth following in the community.

While having a Fab Five intact I’m excited to build this out and see where it leads.  Check back next month for Part 2 in the series.

Reports In SSISDB

Posted on by
3

I was approached with an in shop issue where a group could not view the execution reports in the SSISDB. The reason for this was due to the security standards in place at the shop; the user could not be allowed to have the SSIS_Admin role.

In order to allow the user group access to the review Integration Services reports on package executions the SSIS_Admin role had to be given. This role would allow the following capabilities:

· Import Packages

· Delete own packages

· Delete all packages

· Change own package roles

· Change all package roles

This role also elevates privileges to sysadmin. This elevation of privilege can occur because these roles can modify Integration Services packages and Integration Services packages can be executed by SQL Server using the sysadmin security context of SQL Server Agent.

What this document will provide is a solution around not granting the SSIS_Admin role, but still allow the necessary entities access to the SSIS execution reports without granting any write, execute, create, update, or insert access.

The Catalog Views

Microsoft has two catalog views that make up the report access for SSIS packages (2012 and later) that I have found. We will look at both of these views and alter them to comment out the where clause. In doing so this will negate only SSIS_admin and sysadmins from having access to the reports, but will allow other users access to these reports.

Catalog.Event_Messages

The first catalog view we will look at is catalog.event_messages. This view is simply utilized for displaying information about messages that were logged during operations. The way Microsoft has configured this view is to only allow the SSIS_Admin or sysadmin privilege to view. In our case we would like to have other groups the ability to review the messages only. In order to do this we need to alter the catalog view.

To access the catalog view navigate to the SSISDB on the SQL Instance. Right click the catalog view and say alter:

clip_image002

Next comment out the where clause and execute the alter statement updating the catalog view appropriately

clip_image004

Catalog.executions

The second catalog view can be accessed in the same manner as the first catalog by repeating the same methodology of altering the view. Catalog.executions displays the instances of the package execution in the Integration Services catalog. Packages that are executed with the Execute Package task run the same instance of execution as the parent package.

After right clicking and altering the view, the where clause will need to be commented out as shown below:

clip_image006

After the where clause is commented out execute the alter command to update the catalog view.

Granting Catalog Access

After altering the catalog views we are left with a manual but needed process. Within the Integration Services Catalogs the following steps will need to be completed:

1. Right click on the package and go to properties

2. Once the Folder Properties dialog box is initiated go to Browse in the upper right hand corner

image

3. Once the Browse All Principals dialog box is initiated select the public database role and click ok

image

4. Ensure the grant read access is then given to the database role and click ok

image

Conclusion

By taking the above steps the users can now see the reports and that is it. In testing I’ve found that users cannot do the following:

· Create new environmental variables

· Create new packages

· Create new folders

· Cannot add, insert, update, or delete anything in the SSISDB or the Catalog Folders

· Cannot initiate any SSIS SQL Agent jobs

· Cannot execute any queries against the SSISDB

What I’ve found users can do the following:

· See package names

· Right click and select all executions

· View the reports

**As with anything do not take code from the web and blindly implement into your production environment.

SQL Sentry Plan Explorer – Don’t Leave Home Without It

Posted on by
1

CollaborateImageIf you’ve been around me long enough then you realize that I am a Red Gate fanatic. With that said I’ve grown accustomed to another utility called SQL Sentry Plan Explorer by SQL Sentry.

I’m a big Aaron Bertrand (B|T) fan and he is the one that first introduced me to this utility via his blog; if you aren’t following this man then you are missing out. He has some stellar commentary on his blog and twitter and has a deep passion for the SQL Community.

What is SQL Sentry Plan Explorer

One thing that I think of when the words SQL Sentry Plan Explorer are said is query optimization. Do you have that one go to script or utility when you are troubleshooting stored procedures and queries? If so, and this utility isn’t part of it then add it to your tool DBA tool belt.

There are two different versions that you can download; a free version and a Pro version. Both utilize SQL Server to help streamline and make optimization of queries become more efficient for the every day data professional.

What does the Free Plan offer

The free plan offers quite a bit. You can check out the overview here

  1. Enhanced plan diagrams
  2. Statements tree
  3. Plan trees
  4. Top operations
  5. Query columns
  6. Join diagrams
  7. Parameters
  8. Expressions
  9. I/O

These are just a few of the things you can expect to see with the free version

What does the Pro plan offer

In addition to what the free plan offers you will find some of the following:

  1. Wait Stats
  2. Full Query Call Stack
  3. Open Deadlock files
  4. Plan Filtering
  5. Rotate plans

…and much more

Personal Approaches

In the past I have found that the free plan has allowed me to:

  1. Quickly identify bottlenecks
  2. Review and compare statements
  3. Review costly operations
  4. Review index seeks and scans

I think one of the most beneficial items that SQL Sentry has done for this utility is adding it as an SSMS add in.

Utility Downloaded, Now What?

Like any other tool, the goal is to help streamline and make the data professional more efficient. With that said, the data professional has to know the “why’s” and how things function within SQL; don’t utilize the tool as a crutch nor should you utilize the tool as a means to solidify commands like a robot.

A SQL community member and MVP has taught me (thanks Tim Chapman (B|T) that just because you have all these tools at your disposal you, yourself have to be able to connect all the dots which means what guys – learn and know what you are reading.

You see an index seek; great….now why?

You see that Plan Explorer is showing you a critical alert in red on index cost…great; why?

Don’t just simply follow a tool; know what you are looking at.

Conclusion

I highly recommend SQL Sentry’s Plan Explorer; from personal experience it is helped me on more than one occasion. You can view all they have to offer here.

Well done SQL Sentry; well done indeed.

I tell you what; check out what my other colleagues have to say on the matter and how they have benefited from this utility:

If you want to read more about the newly released SQL Search, don’t forget to check out these blog posts:

On a SQL Collaboration Quest

Four SQL professionals gathered from the four corners of the world to share their SQL knowledge with each other and with their readers: Mickey Stuewe from California, USA, Chris Yates from Kentucky, USA, Julie Koesmarno from Canberra, Australia, and Jeffrey Verheul from Rotterdam, The Netherlands. They invite you to join them on their quest as they ask each other questions and seek out the answers in this collaborative blog series. Along the way, they will also include other SQL professionals to join in the collaboration.

 

RedGate SQL Search Has What????

Posted on by
3

CollaborateImageThis week I am back at it with my SQLCoOp friends in sharing the goodness of a utility that has helped us all ~ RedGate’s SQL Search plug in for SSMS.  This utility has always been helpful in perusing through the schema of any SQL architecture in the search for the gems that we as data professional look for.

The Quest

The outlook was grim and bleak recently one day at the shop. I could recall a portion of a job name and step name for that matter but couldn’t find it for the life of me. The server I was on at the time had a vast amount of jobs on it which I will save for another day.

I will admit frustration started to set in and I started to just open up a query analyzer and start writing some code then it dawned on me…..I had just downloaded a new version of RedGate’s SQL Search Utility. I recalled from the version that they extended the search into SQL jobs; at that moment it was like a light bulb went off in the old noggin.

Now, if we are honest, we all like to work smarter not harder and save time along the way; with that said I decided just to crack this utility open and give it a shot.

Let’s Go

First thing I needed to do was fire up SQL Search inside SSMS. To do this and for the sake of explaining I will be showing this use case on my local, because well, we shouldn’t be showing the world our prod servers now should we! As you can see below firing up SQL Search is simple an easy. While on my local instance if I click on the SQL Search highlighted icon it will bring me to my SQL Search screen where I can then expound on my search criteria.

FiringUp

I had to define my search; I knew a phrase in my job but didn’t know the whole name….so with that said typing in what I knew and not selecting the exact match I knew would pull back the full job name; or so I thought.

 

Phrase

Now this is where it gets really good and makes the SQL Professor very happy. RedGate decided to go on and throw job search functionality into their updated utility. If you click on the All Object Type drop down you will see a Server Object called jobs. Simply go ahead and check that. Now for my use case I went on ahead and checked them all.

Jobs

So, what have we done up to this point is type in our phrase, ensure the jobs server object is check then it’s giddy up and go time. After letting the search occur in all databases I find the results I’m looking for:

JobResults

My job name pulled back along with the actual step detail. Whoa wait, I had no clue I’d get the detail with it as well. Hats off RedGate this is something that every Data Professional can utilize and is a tool that saves time. It took me less than a minute to do a quick search and pull the information that I required.

Like What You See?

Listen, this just is one avenue in which RedGate has enhanced this product. I’m an everyday Data Professional that goes into work everyday and wants to work efficiently. Check this product out for yourself here

Some of the other enhancements made are:

  • Search in jobs
  • Select multiple object types and databases to search in
  • Improved indexing
  • Search with % wildcards
  • Search with Boolean operators

I tell you what; check out what my other colleagues have to say on the matter and how they have benefited from this utility:

If you want to read more about the newly released SQL Search, don’t forget to check out these blog posts:

 

On a SQL Collaboration Quest

Four SQL professionals gathered from the four corners of the world to share their SQL knowledge with each other and with their readers: Mickey Stuewe from California, USA, Chris Yates from Kentucky, USA, Julie Koesmarno from Canberra, Australia, and Jeffrey Verheul from Rotterdam, The Netherlands. They invite you to join them on their quest as they ask each other questions and seek out the answers in this collaborative blog series. Along the way, they will also include other SQL professionals to join in the collaboration.