T-SQL Tuesday #067 – Extended Events

Invitation and wrap-up from Jes Borland.

The June 2015 topic is Extended Events. I want to know (and others do, too) how you’ve solved problems with Extended Events. What sessions have you created? What unique way have you used predicates or targets? What challenges have you overcome?

If you’re thinking, “I haven’t used Extended Events!” or “I don’t know enough about Extended Events to write a blog about it!”, perfect! I want you to write a blog that lists the questions you have. That way, other contributors can leave comments with suggestions, or link to their blogs that give you answers. Don’t be shy! We all started out knowing nothing about this new feature.

T-SQL Tuesday #066 – Monitoring

Invitation and roundup from Catherine Wilhelmsen.

 

The topic of the month is monitoring. We all monitor something while working with SQL Server: Maybe you’re a DBA who monitors database performance, an SSIS developer who monitors job and package execution, an application developer who monitors queries or a BI analyst who monitors report usage? Do you use T-SQL or PowerShell scripts? Have you created your own monitoring reports or applications? Have you invested in a complete monitoring solution from a vendor? What is monitored manually and what is automated with alerts? If a brand new SQL Server professional in your role asks you for advice, what do you say is the number one most important thing to monitor? Have you ever stayed awake for a week solving a problem that could have been avoided with proper monitoring? Did you implement a monitoring solution that saved your company?

Be creative! There are so many topics to choose from, and you can of course write about anything you want as long as it is related to SQL Server and monitoring. It doesn’t matter if you’re new to SQL Server or have decades of experience, whether your blog post is short or long, an introduction or a deep dive, if you include scripts or screen shots… Just join the party and have fun while you share your knowledge. (And if you joined the #SQLNewBlogger challenge in April, this is a great way to keep blogging!)

T-SQL Tuesday #065 – Teach Something New

Invitation and roundup from Mike Donnelly.

The topic this month is straight forward, but very open ended. You must learn something new and then write a blog post explaining it. One of the reasons I present and blog is because it forces me to really learn a subject if I am going to explain it to someone else. I am now giving all of you that same opportunity.  You’re welcome.

I considered limiting this to just T-SQL, but that seemed….limiting. It just has to be something SQL related and also small enough that you can explain in a single blog post. Maybe a T-SQL command or DMV you have been meaning to learn more about or an SSIS component or PowerShell commandlet you’ve never used before. Try not to make it too theoretical I want some code snippets or screen shots. OK. We’ll meet back here on the internets in a week and all have some new knowledge.

 

T-SQL Tuesday #064 – Calling All Tuners and Gearheads

Invitation and roundup from Russ Thomas.

This is your official invite to the SQL Server Performance Grand National.  I want posts tackling “focused” performance tuning.

By “focused” I mean tackle something head on; the more secret sauce, tricks, code samples, operator costs, or demonstrable metrics against a defined problem the better.  This month is for the gear heads.  Don’t wimp out by avoiding hints, plans, or guides.  General practice is for wusses.  Write something that’ll either go BIG or flame out half-way down the track.  Drag racers aren’t grocery getters.  If your post begins with the phrase… should be implemented with caution – you’re doing it right.  If you’re an SSIS, SSDT, SSRS person – we’ve got a funny car division for you too.  Tell us edge cases where you’ve make your stuff scream.

Need some ideas?

  • Tackle a non set based problem you’ve improved in the wild
  • Discuss hardware settings or IO – anyone using a flash array?
  • Got a solution to a niche wait type?
  • Tackle indexing edges (good or bad)
  • Columnstore !!!
  • Hash buckets !!!
  • Parallelism !!!
  • Break down and improve a peculiar query plan operator

2014 T-SQL Tuesdays

2013 T-SQL Tuesdays

 

 

T-SQL Tuesday #049 – My Go-To Query For Waiting Tasks

Invitation and roundup from Robert Davis.

T-SQL Tuesday #046 – Rube Goldberg Machine

Invitation and wrapup from Rick Krueger.

Building a Better Mouse Trap (Rube Goldberg Machine)

My first exposure to Rube Goldberg Machines was playing the game Mouse Trap as a child. I work almost exclusively on the SQL development side of the house, where we sometimes build crazy creative solutions to solve business problems. We generally know the ‘right’ way to do things, but pesky issue like budgets, personnel, and deadlines get in the way. So, we channel our inner MacGyver, grab a handful paper clips and some duct tape, and then do things with SQL Server that we know shouldn’t be done (in an ideal world). And we hope nobody ever finds out how we bent the rules, because we know they will judge us (as we would judge them) and call our work a <gasp>HACK</gasp>.

So, if you would please, dust off one of those skeletons and tell us how you got really creative with SQL Server, instead of doing it ‘the right way’. In other words, tell us about your ugly SQL baby. If you’re worried about saving face, feel free to describe how you would have implemented the solution if you lived in that ideal world.

T-SQL Tuesday #041 – Presenting

Invitation and recap from Bob Pusteri.

This month the prompt is how did you come to love presenting? What was the first time you gave a presentation in front of a group and really enjoyed it? Was it something that was required of you in school? Something you did in the workplace? Were you inspired by other SQL community members and thought “I think I can do that too”? Whatever your story is, I’d love to hear it. Not a presenter? Not a problem! Feel free to chime in with whatever you like that’s related to either presenting or SQL Server in general.

T-SQL Tuesday #038 – Standing Firm

Invitation and recap from Jason Brimhall.

To kick off the new year (2013), we must first adhere to a little tradition.  This is not a T-SQL Tuesday tradition.  It is more of an annual tradition for all to welcome the new year.  Feel free to click the link and sing along!!

Now for the theme.  A common thing for many people to do this time of year is to do a little self reflection.  Some set meaningful goals for themselves.  Fewer actually accomplish those goals or even follow-up after initially setting the goal.

We are not going to set goals as a part of this T-SQL Tuesday – unless you want to.  I want to take a little different spin on the New Year’s “resolution” tradition.  So the theme this month is “Standing Firm.”

The idea for this theme is to start with a little self reflection.  Then to come up with a story relating to one of these words: resolve, resolution, or resolute.  Here are some examples of how these stories may be portrayed.

  • Resolve:  A system outage occurred and you “resolved” it.
  • Resolute:  You made an executive decision and did not waver from it.
  • Resolution:  You discovered a bug and documented a work-a-round resolution for it.
  • Resolution:  You have discovered certain T-SQL skills are fuzzy and want to sharpen your ability in that area.
  • Resolute:  You are determined to improve performance in your application.

All of these words are very closely related.  It is up to you to determine how you would like to apply them to your T-SQL world.  Your experiences and stories can be loosely or tightly coupled to T-SQL, it is up to you.

And since the theme requires a little bit of self-reflection first, bonus kudos to those that can tie a past experience to a future plan.