2015 T-SQL Tuesdays

  • December – T-SQL Tuesday #73 – Naughty or Nice? – As you work with SQL Server look around you. Is your environment Naughty or Nice?
  • November – T-SQL Tuesday #72 – Data Modeling Gone Wrong (summary)- I would like to invite you to share some data modeling practices that should be avoided, and how to fix them when they do occur.
  • October – T-SQL Tuesday #71 – SQL Server Audit () – For this month, I would like to invite you to write about Auditing. Auditing is certainly a security related topic, and with that fits right in with the August topic (Encryption).
  • September – T-SQL Tuesday #70 – The Enterprise (roundup) – How do you manage an enterprise? What tricks do you use? What are the challenges?
  • August – T-SQL Tuesday #69 – Encryption (roundup) – Write about how you use encryption, why not, what’s blocking you, or what you just learned.
  • July – T-SQL Tuesday #68 – Just Say No to Defaults (roundup) – running with defaults is far from ideal. We all change things after we install an instance, sometimes not until we encounter a problem. Write about something you’ve dealt with as far as defaults go.
  • June – T-SQL Tuesday #67 – Extended Events (Wrap-up) – How have you used extended events? If you haven’t, try to learn something, set up a session, and write about it.
  • May – T-SQL Tuesday #66 – Monitoring (roundup) – you must monitor your systems, your SSIS packages, your reports, something. Talk about monitoring in SQL Server.
  • Apr – T-SQL Tuesday #65 – Teach Something New (roundup) – Completely open ended. Teach yourself something new, anything, about SQL Server and write about it. Bonus for talking about how you learned something new.
  • Mar – T-SQL Tuesday #64 – Calling All Tuners and Gearheads (roundup) – Russ wants posts tackling “focused” performance tuning. By “focused,” he means tackle something head on; the more secret sauce, tricks, code samples, operator costs, or demonstrable metrics against a defined problem the better.
  • Feb -T-SQL Tuesday #63 – How Do You Manage Security? (roundup) – What tips, tricks, techniques, or philosophies do you have around security?
  • Jan – T-SQL Tuesday #62 – HealthySQL (roundup) – How do you ensure your instances are healthy? Monitoring? Maintenance? Something else?

T-SQL Tuesday #073 – Naughty or Nice?

Invitation from Bradley Balls.

Since it is the holiday season, I wanted to keep this holiday themed.  I couldn’t help but think of the approaching Christmas holiday.  Every year I get my children to make a list of presents that they would like to get from Santa Clause.  If we are out and about and they start to misbehave I remind them about their list and that only Nice children get presents.

“So Balls,” you say, “What in the ever loving wide wide world of sports does this have to do with SQL Server?!?”

As you work with SQL Server look around you.  Is your environment Naughty or Nice?  If it is Naughty what’s wrong with it?  What would you do to fix it?  Do you have a scrooge that is giving you the Christmas chills?  Perhaps you have servers of past, present, and future haunting you.  Maybe you are looking at SQL Server 2016 like some bright shining star in the east.

First and foremost the rules.

Rule 1: Don’t get yourself fired.  If your boss is a scrooge don’t name names, don’t hint to hard.  It’s okay to protect yourself.  You want to write about events we can look back on and reflect over, not events HR would *love* to know about.  Perhaps a reminder of SQL Server’s past would be better than that of SQL present.

Rule 2: Some Time next Tuesday using GMT, here’s a link to a GMT time convertor, publish your blog post.  For example in the US that would cover 8 pm Monday to 8 pm Tuesday.

Rule 3: Make sure that you include the Image at the top of the page helping to identify your post as a T-SQL Tuesday blog.  Then come back here and post a link in the comments so I can find them.  Before the end of the week I’ll do a round up of all the blogs.

Extra Credit!

Tweet your blog with the hash tag #tsql2sday, use SQL Server 2016, & go read someone else’s blog on the subject!