I know this is going to come as a stunning shock to you, dear reader, so you may want to be sitting down.
SQL Server isn’t perfect.
It’s okay. Deep, calming breaths. We’re going to get through this together, and here’s how:
- Go to Connect.Microsoft.com, the place where we file bug reports and enhancement requests
- Use the Search to search for your favorite commands, or keywords like error or incorrect results
- Realize that the search function is incredibad, and instead switch to using Google to search for terms or bugs marked as won’t fix
- Find the most interesting bug or enhancement request (and it can be your own), and write a blog post about it (including a link to the Connect item so that folks who agree with you can upvote the item)
The Connect item doesn’t have to have anything to do with T-SQL – it could be about the engine, SSRS, R, the installer, whatever. Now, more than ever, Microsoft has started to respond to Connect requests and get ’em fixed not just in upcoming versions of SQL Server, but even in cumulative updates for existing versions.
It’s an incredible rush of a feeling when you see that Microsoft closes one of your favorite bugs as fixed. It’s happening fast these days – and I want you to enjoy that feeling too. So it’s time to get to know Connect!
The T-SQL Tuesday Rules
It wouldn’t be a database event without rules, right? Here’s a quick summary of the T-SQL Tuesday Rules:
Publish your blog post on Tuesday, January 10, 2017. The post needs to include the T-SQL Tuesday logo at right, and a link to this invitation post. If you tweet the post, include #tsql2sday.
Let me know about the post – either include a link from your post back to this one (which will automatically add a trackback ping), or come back here and leave a comment on this post. I’ll assemble a recap of everybody’s favorite Connect items along with links to your blog, and on the following Tuesday, January 17th, brace yourself for a rush of traffic as our readers become your readers.
Want to host your own T-SQL Tuesday? Email Adam Machanic at amachanic at gmail dot com and volunteer. The 2017 calendar is wide open, and it’s a great way to bring new readers to your blog.
36 Comments. Leave new
Thanks for hosting Brent – here’s my effort, talking about the Estimated Rows Read property in query plans. https://sqlperformance.com/2017/01/sql-performance/estimated-number-of-rows-to-be-read
Thanks Brent! Here’s my entry:
https://blogs.sentryone.com/aaronbertrand/t-sql-tuesday-86-favorite-connect-items/
Thanks for a most interesting subject, Brent.
Here is my slightly perverse take on the subject of unsigned integer data types: http://sqlonice.com/tsql2sday-sing-a-song-of-unsigned-ints/
Thanks for causing me to write my very first T-SQL Tuesday entry on MSBuild support for SSIS (and SSAS/SSRS):
http://www.japj.net/archive/2017/01/10/t-sql-tuesday-86-sql-server-bugs-and-enhancement-requests/
Here is my entry. I’m only asking for a DMV… 🙂
https://blobeater.blog/2017/01/10/sql-server-bugs-enhancement-requests/
My contribution (about batch mode):
http://sqlkover.com/t-sql-tuesday-86/
Thanks Brent. I would like the ability to force parallelism with a new query hint. http://thedatabaseavenger.com/2017/01/forcing-parallelism-t-sql-tuesday/
Hi Brent. My contribution for T-SQL Tuesday #86: http://sharptools.de/2017/01/10/padding-of-strings/
Thanks for the topic, Brent (and for getting me to finally start writing!)
My contribution, about being unable to target Developer Edition to a specific edition’s feature set, can be found at https://www.marksouthall.com/blog/mark/t-sql-tuesday-86-but-i-can-do-it-in-dev/
Hi Brent, I’ve made a (very minor) contribution to this on my tiny and new blog;
http://richbenner.com/2017/01/t-sql-tuesday-86/
Thanks for hosting Brent, here is my effort:
T-SQL Tuesday #86: String or binary data would be truncated
http://sqlservercode.blogspot.com/2017/01/t-sql-tuesday-86-string-or-binary-data.html
Wow, amazing response so far! Congrats, Brent, on a successful T-SQL Tuesday. Here’s mine:
http://sqlblog.com/blogs/adam_machanic/archive/2017/01/10/the-sql-genie-t-sql-tuesday-086.aspx
Great T-SQL Tuesday!!
Here’s my contribution…
When world’s collide! Quickstats, Filtered Indexes, Clustered ColumnStore Indexes, and Access Violations
http://sql-sasquatch.blogspot.com/2017/01/when-worlds-collide-quickstats-filtered.html
Thanks, Brent. An ugly post of mine, but the topic interests me…
https://downshiftdata.wordpress.com/2017/01/10/t-sql-tuesday-microsoft-connect-edition/
Thanks Brent. Here’s my post on what I think should be something easy to implement: https://medium.com/@bertwagner/the-most-lacking-feature-in-ssrs-7-years-and-no-fix-e387940528fe#.6ioa4qkmv
Hey Brent, here’s my post: https://blogs.sentryone.com/loriedwards/t-sql-tuesday-86-string-binary
Thanks for the motivation to post something news (it’s been a while). There are a lot of worthy connect items out there and some good ones are already covered, but I’ve submitted one that I’d love to see implemented:
http://www.trycatchfinally.net/2017/01/microsoft-connect-item-for-an-ssrs-pre-report-canvas/
Thanks for bring some new attention to these open requests!
Thanks, Brent! This is my post:
https://blogs.sentryone.com/melissaconnors/t-sql-tuesday-86-sorting-stacked-chart/
Fun topic Brent! Thanks for hosting. Here’s my contribution https://sqlstudies.com/2017/01/10/connect-to-add-included-columns-to-sp_helpindex/
Thanks for this opportunity, Brent. I spoke about Temporal Tables and History Retention: https://bornsql.ca/2017/01/temporal-tables-history-retention/
Thanks, Brent. Just now, I saw this month’s t-SQL Tuesday hosted by you and I added my contribution. It is 12:40 AM IST 🙂
http://www.sqlserverblogforum.com/2017/01/alwayson-recovery-pending-sql-server-bugs-enhancement-requests-t-sql-tuesday/
Here’s my post: http://blog.waynesheffield.com/wayne/archive/2017/01/t-sql-tuesday-86-enhancement-requests/
Thanks Brent! Here’s my contribution https://nocolumnname.wordpress.com/2017/01/10/t-sql-tuesday-86-sql-server-bugs-enhancement-requests/
You know what they say. Better late than…later
Thanks for hosting, Brent! Here’s my contribution:
http://itsalljustelectrons.blogspot.com/2017/01/TSQL-Tuesday-86-SQL-Server-Bugs-Enhancement-Requests.html
Thanks Brent – this was fun – here’s mine: https://geeql.com/2017/01/10/t-sql-tuesday-my-favorite-bug/
Thanks, Brent.
My post is on multi-tenant database support:
http://www.pontop.dk/single-post/2017/01/10/T-SQL-Tuesday-86—Can-haz-native-multi-tenant-support-in-SQL-Server
My first time in the T-SQL Tuesday, and it opens 10 year old wounds 🙂 Excellent topic! http://sqlblog.com/blogs/louis_davidson/archive/2017/01/10/t-sql-tuesday-86-my-all-time-favorite-personal-sql-server-enhancement-request-automatically-maintained-columns.aspx
Thanks for hosting. Great topic.
My contribution:
http://scribnasium.com/2017/01/named-parameters-in-t-sql-functions/
Thanks for hosting, Brent! Here’s my post: https://therestisjustcode.wordpress.com/2017/01/10/t-sql-tuesday-86-sql-server-bugs-enhancement-requests/
Andy – it’s, uh, Wednesday now.
Darned… Was convinced that track back was working… I guess not.
So here is my, overdue comment for my post on #tsql2sday post (which was published in time)
T-SQL Tuesday #86 : SQL Server Bugs & Enhancement Requests : [SSMS] Intellisense for MDX
http://t-sql.dk/?p=1960
Brgds
Jens
Woops, looks like I was so busy last week I totally forgot to comment with my post 🙁
http://sqlvariant.com/2017/01/t-sql-tuesday-86-adding-when-dbcc-checkdb-last-ran-to-the-sys-databases-catalog-view/
[…] January – T-SQL Tuesday #86 – SQL Server Bugs and Enhancement Requests (roundup) […]
[…] Invitation and roundup from Brent Ozar. […]
[…] This month’s T-SQL Tuesday, hosted by Brent Ozar (b/t), is about SQL Server Bugs & Enhancement requests. […]
[…] a topic. Known as T-SQL Tuesday and started by Adam Machanic (Blog | @AdamMachanic), this month’s T-SQL Tuesday topic is hosted by friend and fellow MCM Brent Ozar. The theme that Brent has chosen for this month is […]