T-SQL Tuesday is a monthly blog party for the SQL Server community. It is the brainchild of Adam Machanic (b|t) and I am thankful for the opportunity to host this month’s edition. The concept is straightforward – each month a blog hosts the party and everybody who wants to contribute can write a post about the topic that is selected.
I’ll get into a few more specific rules at the bottom of this post, but first let’s dive into this month’s topic!
This Month’s Topic: Fixing Old Problems with Shiny New Toys
While the SQL Server ecosystem is constantly evolving, it seems like that evolution has sped up considerably in the last year or two. From the constant improvements in Azure, to the rapid changes in Power BI, to the powerhouse release of SQL Server 2016 last year, those of us whose professional life resides within the SQL Server world have a multitude of new tools in our toolbox.
What I’d like to see from the blog responses for this T-SQL Tuesday is how you’ve used a “new” Microsoft data platform toy to fix an old problem. We’ll define new toys as something from SQL Server 2014’s release date until now. We’ll even accept a SQL Server vNext response if you’ve got one!
Did you work around a database design/performance issue by using memory-optimized tables and natively compiled stored procedures (brought to us in SQL 2014)? Did you use Power BI to present data visualizations to a client in a way you couldn’t have previously? Did you use SQL 2016’s mobile reporting ability to extend SSRS reports to a mobile client and solve an issue that way? Did you solve an archival issue by stretching your database into Azure? Basically, did you solve a data problem with a cool new Microsoft data platform toy?
I think many of us settle into old habits when it comes to solving problems with our data, so I can’t wait for the responses to this topic to see what cool new things people are doing to solve some old problems.
The Fine Print (aka The Rules)
- Your post must be published between 00:00:00 UTC and 23:59:59 UTC on Tuesday, February 14th (yes, feel free to throw a Valentine’s joke or two into your blog)
- Include the T-SQL Tuesday logo in the top of your post and link your post back to this one (preferably via a comment on this post, but a trackback is OK as well)
- If you’re on Twitter, tweet your post using the #tsql2sday (if you’re not on Twitter, get on it!)
I’ve posted up at https://informationwithinsight.com/2017/02/14/fixing-old-security-problems-with-shiny-new-toys/ Happy Tuesday!
https://blog.bertwagner.com/how-sql-2016s-json-functionality-will-make-you-want-to-use-json-2cf513c752ec#.elglm05e6 Thanks for hosting this month! Great topic.
https://blog.bertwagner.com/how-sql-2016s-json-functionality-will-make-you-want-to-use-json-2cf513c752ec#.elglm05e6 Thanks for hosting this month! Great topic.
Thanks for hosting T-SQL Tuesday Matt. You gave me a great reason to write about one of the SQL Server 2016 new features of Analysis Services Tabular, Calculated Tables. Here’s my post http://wp.me/p4beUo-rj
Regards,
Ginger
@desertislesql
http://www.desertislesql.com
Thanks for the topic! I’ve blogged about using SQL Server 2014’s native Backup Encryption to fix a security problem: https://www.marksouthall.com/blog/mark/t-sql-tuesday-87-data-theft-is-red-backup-encryption-is-blue/
Here’s mine. Thanks for hosting.
http://sqlblog.com/blogs/adam_machanic/archive/2017/02/14/solving-the-net-changes-problem-with-temporal-tables-t-sql-tuesday-087.aspx
Thanks Matt! Here’s my post:
https://blogs.sentryone.com/aaronbertrand/t-sql-tuesday-87-shiny-new-toys/
Thanks for the hosting Matt, here’s my contribution.
https://nocolumnname.wordpress.com/2017/02/14/granting-read-permissions-on-everything-t-sql-tuesday-87-fixing-old-problems-with-shiny-new-toy/
Thanks for hosting Matt! Great subject.
Here’s mine: https://sqlstudies.com/2017/02/14/server-level-database-permissions/
T-SQL Tuesday #87 – New Way to See Wait Stats for a Single Query http://sqlsoldier.net/wp/sqlserver/tsqltuesday87newwaytoseewaitstatsforasinglequery
Thanks Matt. My post is at http://blog.waynesheffield.com/wayne/archive/2017/02/t-sql-tuesday-87-beware-shiny-new-toys/
http://dallasdbas.com/t-sql-tuesday-shiny-new-toys/
Here is my post.
http://blog.garrybargsley.com/where-did-my-backup-compression-go-oh-i-found-it/
Thanks for hosting. Here’s my contribution:
http://scribnasium.com/2017/02/angle-brackets-vs-curly-braces/
Thanks for hosting, Matt. https://sqlperformance.com/2017/02/t-sql-queries/using-at-time-zone-to-fix-an-old-report
Hi Matt, thanks for hosting. Here’s my post: http://t-sql.dk/?p=2005
I’m talking about Power BI in SSRS. Thanks Matt. http://thedatabaseavenger.com/2017/02/power-bi-in-ssrs-t-sql-tuseday/
Thanks Matt, although it is a token effort on my part, you did get me out of a blogging rut!
http://sqlonice.com/musings-on-session_context/
Thanks, Matt! My page shows a date of 2/14. UTC might see if differently! Here’s a late submission.
https://bobrubocki.wordpress.com/2017/02/14/t-sql-tuesday-fixing-old-problems-with-shiny-new-toys
My Pingback doesn’t seemed to work so I have put it in here manually. Thx for hosting this party
http://www.sql-aus-hamburg.de/tempdb-performance-tuning-out-of-the-box-t-sql-tuesday-87/
Danke!
Here is/was my contribution. Great topic.
https://www.simple-talk.com/blogs/quick-look-two-new-dmv-columns-tuesday/
Excellent posts from everyone. Here is my quick contribution for my first T-SQL Tuesday. Great topic. Thanks to the host.
https://www.simple-talk.com/blogs/quick-look-two-new-dmv-columns-tuesday/