I was asked to host T-SQL Tuesday this month, T-SQL Tuesday #52. This marks my second time hosting and I’m happy to do it again.
Your writing assignment for March 2014 is to
pick a popular opinion and argue against it.
… or at least qualify it. Given any issue, people drift to two kinds of crowds. There’s the “it depends” crowd and there’s the “never ever” crowd. We tend to fall in with one crowd or the other. This month, I want you to find an “never ever” issue and argue for it (or conversely, find a “always” issue and argue against it).
I wonder how this month will go. It takes guts to go against common wisdom.
You don’t necessarily have to argue against a universal opinion, but it should at least be popular. I think that your choice of opinions is practically limitless:
- Bob Duffy had a list of 10 interview questions that annoy SQL professionals. With some great topics there including GUIDs, Cursors, and heaps.
- Google results for “SQL.Server should.never”
- Fair’s fair. Here are the results for “SQL.Server should.always”
- Does anyone want to have a shot at redeeming Microsoft Access?
- Foreign Keys, SchmoreignKeys.
- Check it out. SQL Server supports varbinary(max)! Ideal for json documents and xml documents (or both!)
- Shrinking databases and/or log files (because of the fragmentation! God save us all from fragmentation!)
Here’s a little secret. This month’s topic is not for you. It’s for the readers. It’s a chance for you to give them a more nuanced understanding of a topic that they may not have given a lot of thought up until now. I’m a little curious myself.
The rules are the same as always:
Follow These Rules
- The post must go live on your blog between 00:00 GMT Tuesday, March 11, 2014 and 00:00 GMT Wednesday, March 12, 2014.
In other words, set your sql server date, time and timezone properly and run this script:
IF GETUTCDATE() BETWEEN '20140311' AND '20140312' SELECT 'You Can Post' ELSE SELECT 'Not Time To Post'
- Your post has to link back to this post, and the link must be anchored from the logo (found above) which must also appear at the top of the post
- Leave a comment here (below) or I won’t be able to find your post.
That’s it! Good luck! Can’t wait to see what you have in store.
Your humble host,
Michael J. Swart