Michael J. Swart

June 6, 2016

T-SQL Tuesday #079: It’s 2016!

Filed under: SQLServerPedia Syndication — Michael J. Swart @ 9:41 pm

Update: the roundup post
Time to exercise those blogging fingers. It’s T-SQL Tuesday again! And this month’s T-SQL Tuesday is going to rock!

SQL Server 2016 is Out!

SQL Server 2016 went RTM this week and so naturally, we’re going to write about it. Here are a few writing prompts for you:

  • Check out what’s new. Microsoft has written a lot about their new features. Thomas Larock has written a really nice landing page for those posts, SQL Server 2016: It Just Runs Faster – Thomas Larock. Look through those links. Do you feel optimistic about 2016? Or maybe a bit disappointed? Let us know either way
  • Haven’t had time to download the bits, install them, explore and form thoughts on 2016 yet? Have no fear, check out Microsoft’s Virtual Labs. It lets you explore features without worrying about all the setup. In minutes you’ll be typing SELECT 'hello world';

Still Not Inspired Eh?

  • Write a post starting with “It’s 2016, why is this still (not) a thing?” <cough>regular expressions</cough>
  • Think outside the box and maybe write about something besides SQL Server. Write about something you did in 2016 that would have been impossible at the same time last year.

Follow These Rules

The post must go live on your blog between 00:00 GMT Tuesday, June 14, 2016 and 00:00 GMT Wednesday, June 15, 2016.
In other words, set your sql server date, time and timezone properly and run this script:

IF GETUTCDATE() BETWEEN '20160614' AND '20160615'
    SELECT 'You Can Post'
    SELECT 'Not Time To Post'

Your post has to link back to this post, and the link must be anchored from the logo which must also appear at the top of the post. (A thing about logos. We’re sticking with the status quo. Find cleaned up versions here)

Leave a comment here (below) or I won’t be able to find your post. I really encourage you to participate and then come back in a week for the round up. I think you’ll like it.

Your humble host,
Michael J. Swart


  1. Thanks Michael – you can read mine at http://sqlperformance.com/2016/06/sql-server-2016/temporal-table-query-plan-behaviour

    Comment by Rob Farley — June 13, 2016 @ 8:43 pm

  2. Michael —
    This is the first time I have ever done a T-SQL Tuesday. Following the directions, on Tuesday, my post on SQL Server 2016 and R can be found here http://wp.me/p4beUo-lu

    Comment by Ginger Grant — June 13, 2016 @ 9:29 pm

  3. […] 2016 was recently released, many people have not yet had used R with SQL Server. I thought that T-SQL Tuesday would be a great way to introduce this topic.  This post contains everything you need to run your […]

    Pingback by T-SQL Tuesday #79 – Creating R Code to run on SQL Server 2016 | — June 13, 2016 @ 9:50 pm

  4. And here’s my very geeky contribution,a look into the 2016 update to the SOS_RWlock.


    Comment by Ewald Cress — June 14, 2016 @ 2:14 am

  5. […] just life.  But!, there is nothing like a good TSQL2SDay topic to get me back on the wagon.  Michael J Swart sets the tone this month in a well timed topic coinciding with the release of SQL Server […]

    Pingback by TSQL Tue #79: When the Memory is all Gone | Russ Thomas - SQL Judo — June 14, 2016 @ 3:55 am

  6. Hey, I blogged. Almost forgot how to do that. When the memory is all gone! https://sqljudo.wordpress.com/2016/06/14/tsql-tue-79-when-the-memory-is-all-gone/

    Comment by Russ — June 14, 2016 @ 3:58 am

  7. […] post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server […]

    Pingback by We Must Wait for SP1 before Upgrading to SQL Server 2016 - madeiradata — June 14, 2016 @ 5:16 am

  8. My contribution to the community – http://www.patrickkeisler.com/2016/06/tsql-tuesday-79-sql-server-2016-launch.html

    Thanks for hosting Michael.

    Comment by Patrick Keisler — June 14, 2016 @ 7:52 am

  9. […] T-SQL Tuesday #79 is being hosted by Michael J. Swart this month. His prompt was to check out what’s new with SQL Server 2016. I figured I would play around with the Query Store and our old friend HammerDB. […]

    Pingback by Use the Query Store In SQL Server 2016 To Improve HammerDB Performance (T-SQL Tuesday #79) | SQL JGood — June 14, 2016 @ 8:21 am

  10. Thanks Michael. Here is my entry: https://sqljgood.wordpress.com/2016/06/13/use-the-query-store-in-sql-server-2016-to-improve-hammerdb-performance/

    Comment by Justin Goodwin — June 14, 2016 @ 8:29 am

  11. Great topic Michael. Here is my contribution https://sqlstudies.com/2016/06/14/comparing-two-query-plans/

    Comment by Kenneth Fisher — June 14, 2016 @ 9:09 am

  12. […] It’s T-SQL Tuesday,  the blog party that SQL Server expert Adam Machanic (blog|twitter) started. This month’s episode is hosted by Michael J Swart (blog| twitter). The topic: Learn something new and blog about it […]

    Pingback by T-SQL Tuesday #79 - COMPRESS()ing LOB data - Impatient DBA — June 14, 2016 @ 9:10 am

  13. Hi Michael, my entry is here:


    Comment by Aaron Bertrand — June 14, 2016 @ 9:32 am

  14. […] This month, the assignment is to write about SQL Server 2016. (A big thanks to Michael Swart (b|t) for hosting!) I have decided that I really do want to use SQL Server 2016 over SQL Server 2014 […]

    Pingback by T-SQL Tuesday – June 2016: Temporal Tables – Deb, the DBA — June 14, 2016 @ 9:35 am

  15. Here’s my post: https://debthedba.wordpress.com/2016/06/14/t-sql-tuesday-june-2016-temporal-tables/ . It’s my first time doing this so let me know if I didn’t set it up properly and need to fix something.

    Comment by Deborah Melkin — June 14, 2016 @ 9:37 am

  16. Thanks Michael! Here is my entry, “It’s 2016, so why is sp_help_revlogin still a thing?”


    Comment by Chrissy LeMaire — June 14, 2016 @ 9:42 am

  17. Thanks for hosting this month! My entry on temporal tables is here – http://blogs.sqlsentry.com/loriedwards/t-sql-tuesday-temporal-tables/

    Comment by Lori Edwards — June 14, 2016 @ 11:14 am

  18. […] this case, Michael J Swart is hosting this month’s blog party and he asks us to write about something to do with SQL Server 2016. Read the rules at his […]

    Pingback by It’s 2016 RLS for T-SQL Tuesday #79 – Voice of the DBA — June 14, 2016 @ 11:23 am

  19. Many thanks for a timely and terrific topic, Mike! You should see an enormous amount of participation. Thanks for hosting! Here’s my entry:


    Comment by Robert Pearl — June 14, 2016 @ 11:33 am

  20. […] Swart(@MJSwart) for hosting this month’s edition. The request is simple enough: blog about some aspect of SQL Server 2016. This is actually a good opportunity for me to write about a feature I’ve been meaning to get to […]

    Pingback by #TSQL2SDAY: SQL 2016 Direct Seeding | Art of the DBA — June 14, 2016 @ 12:58 pm

  21. […] thank Michael J Swart (b|t) for hosting TSQL Tuesday #79. Topic for this month is to write about SQL Server 2016. This is my first time joining in TSQL […]

    Pingback by TSQL Tuesday #79 -JSON Support in SQL 2016 | SqlWorldWide — June 14, 2016 @ 3:09 pm

  22. Thank you Michael for hosting. First time contributor to TSQL Tuesday. My entry about JSON support in SQL Server 2016: http://sqlworldwide.com/tsql-tuesday-79-json-support-in-sql-2016/

    Comment by Taiob — June 14, 2016 @ 3:11 pm

  23. Thanks for hosting the challenge this month. Here is my entry:


    Best wishes,

    Comment by kennie Nybo Pontoppidan — June 14, 2016 @ 3:41 pm

  24. Sorry, my first T-SQL Tuesday submission is late. I blog so infrequently I had trouble logging into my WordPress site. 🙂

    Here’s my contribution:


    Thanks for hosting.

    Comment by Riley Major — June 15, 2016 @ 1:20 am

  25. […] in both 2014 and 2016 versions, and today is a perfect excuse to align it with the 2016-themed T-SQL Tuesday hosted by Michael J […]

    Pingback by Unsung SQLOS: the 2016 SOS_RWLock | SQL on ice — June 22, 2016 @ 12:16 am

  26. […] The invite post […]

    Pingback by T-SQL Tuesday #079 Roundup: It’s 2016! | Michael J. Swart — June 22, 2016 @ 9:25 am

  27. […] #79 – It’s 2016 […]

    Pingback by 2016 T-SQL Tuesdays – T-SQL Tuesday — February 24, 2017 @ 11:09 am

  28. […] Invitation and roundup from Michael J. Swart. […]

    Pingback by T-SQL Tuesday #079 – It’s 2016 – T-SQL Tuesday — February 25, 2017 @ 4:52 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

Powered by WordPress