T-SQL Tuesday #101 – My Essential SQL Server Tools

Invitation from Jens Vestergaard.

The Essential SQL Server Tools in my stack

Besides SQL Server Management Studio and Visual Studio Data Tools we all have our own set of tools that we use for everyday chores and tasks. But how do we get to know which tools are out there, if not for other professionals telling us about them? Does it have to a fully fledged with certification and all? Certainly not! If there’s some github project out there, that is helping you be double as productive, let us know about it. You can even boast about something you’ve built yourself – if you think others will benefit from using it.

Basically I think, that by establishing awareness about what kinds of tools that are out there, new professionals will not have as steep a curve getting the pace up, as they would have had. But I suspect that even some veteran guys could have an “a-ha” moment from reading the summary.

Additionally, you can (read: should) share how you came to depend on said tool – and of course you are encouraged to give credit, where credit is due in terms of making you aware of the tool.

Another approach for this topic, is to approach it as kind of A Day in the Life of kind of blog post, as has been done before by Erin Stellato (b|l|t). Writing with the specific angle to describing how your everyday is made easier by the use of your tool stack.

T-SQL Tuesday #100 – Looking Forward 100 Months

Invitation and roundup from T-SQL Tuesday founder, Adam Machanic.

Let’s look forward…

Anyone who has been in IT for more than 10 minutes knows how the industry works. IT loves its trends, but things tend to be very cyclical. Our current crop of “cloud” technologies are nothing new at the heart of things. The cloud, a wise person once said, is merely someone else’s server. And we’ve seen prior iterations of these same hardware sharing ideas going all the way back to the 1960s. Machine Learning, likewise, has been around in other guises for several years. Columnstore ideas are decades old even if they’re new-ish in the Microsoft space, and even in-memory has a rather deeper history than many realize. None of these “new” technologies about which we’re so excited are actually new, even if they’re newer (and hopefully better) implementations.

It is possible, of course, that a more rapid cycle could break the trend. It is possible that newer technologies will be truly new. Or perhaps the future will simply bring more of the same, a continuation of the everlasting IT sine wave.

Your mission for month #100 is to put on your speculative shades and forecast the bright future ahead. Tell us what the world will be like when T-SQL Tuesday #200 comes to pass. If you’d like to describe your vision and back it up with points, trends, data, or whatever, that’s fine. If you’d like to have a bit more fun and maybe go slightly more science fiction than science, come up with a potential topic for the month and create a technical post that describes an exciting new feature or technology to your audience of June 2026. (Did I do the math properly there?)

T-SQL Tuesday #099 – Dealer’s Choice

Invitation and roundup from Aaron Bertrand.

Aaron is offering a choice.

Behind door #1:

In the spirit of my revelations about still being a hockey card nerd after all these years, and after seeing Drew Furgiuele’s great post on #sqlibirum, I would love to hear about something you are passionate about, outside of the SQL Server or tech community. Bonus points if it’s a passion that might surprise the rest of us. Play the Zeusaphone? Forge Samurai swords? Coach a chess boxer or extreme ironer? Maybe you dabble in toilet seat art? Tell me about it! Show me proof! If you choose door #1, I hope your post is full of pictures or other media, and not just a wall of text. Let’s keep it PG, though, OK?

Behind door #2:

Since many of you might be uncomfortable talking about your non-technical passions, I’ll give you an escape pod back to the more familiar. I have a long laundry list of T-SQL bad habits (there’s a big index here). What’s your favorite one? Which one do you disagree with most vehemently? What bad habits are missing from my list? This is not entrapment; I promise I’m not going to bait you into writing something just so I can argue with you. I’m really interested in reading your opinions and, also, to have more material I can point to when I talk about bad habits and/or best practices.

T-SQL Tuesday #098 – Your Technical Challenges Conquered

The current invitation (January 2017) is for T-SQL Tuesday #98. Invitation and round up from Arun Sirpal.

Please write about and share with the world a time when you faced a technical challenge that you overcame and you can go really technical with both the issue and solution if you like.

From data recovery, tempdb contention, concurrency issues to even DTU exhaustion within Azure SQL Database – there is plenty to potentially write about.

So tell us what the issue was, your troubleshooting mind-set, how knowledge in that specific area guided you and more importantly what you did to overcome this challenging event. Hopefully with this topic we will get to read from both advanced and beginner level bloggers.

You know the saying, When the going gets tough, the tough get going”.