T-SQL Tuesday #118 – Your Fantasy SQL Feature

Andy Levy
It’s early September, which means it’s time for T-SQL Tuesday! This month’s topic comes from Kevin Chant (blog | twitter). Our mission, should we choose to accept it (click the image to see the original invite): Recently I’ve had to submit suggestions to Microsoft about Azure DevOps and SQL Server. I will admit a couple of the suggestions had certainly been in my head for a while. In fact, I wish I had suggested them sooner.

T-SQL Tuesday #113 -A Database for the Great Outdoors

Andy Levy
This month’s T-SQL Tuesday comes from Todd Kleinhans (blog | twitter) who wants to know what we’re doing with databases outside of work. I’m curious- outside of work and learning, what do you personally use databases for? Tracking books you have, recipes, collections, etc? While it can be said using databases for personal use could be either overkill or a hammer in search of nails on the other hand, it is exactly what they are for- storing data.

T-SQL Tuesday #112 - The Cookie Jar

Andy Levy
This month’s T-SQL Tuesday comes from Shane O’Neill (blog | twitter). He starts us off with this: Dipping into the Cookie Jar is about when the going gets tough and you don’t think you can handle anymore, then you think back about your accomplishments and take some sustenance from them. You dip back into that cookie jar and use whatever energy that provides to keep going. So tell me about a time when you had an accomplishment that can keep you going.

T-SQL Tuesday #108 - Learning Tech Beyond SQL Server

Malathi Mahadevan (blog|twitter) is hosting this month’s T-SQL Tuesday, a monthly blog party for the SQL Server community. Malathi has asked us to: Pick one thing you want to learn that is not SQL Server. Write down ways and means to learn it and add it as another skill to your resume. If you are already learning it or know it – explain how you got there and how it has helped you.

T-SQL Tuesday #107 - Death March

Andy Levy
This month’s T-SQL Tuesday is hosted by Jeff Mlakar and he asks us to write about a project that went horribly wrong. My story isn’t really worthy of the name “death march” but it was a pretty rough project. The project started sometime in mid-2003. I was working as a web developer (Classic ASP) for an insurance company and they wanted to modernize the underwriting process with a web-based “workflow” application.

T-SQL Tuesday #104 - Code You Would Hate To Live Without

Andy Levy
This month’s T-SQL Tuesday is hosted by Bert Wagner and he asks us to write about code we’ve written that we would hate to live without. First off, “hate” is a pretty strong word so let’s go with “code you couldn’t bear to live without”. The first bit of code I couldn’t live without is reviled in some circles. More often it’s misunderstood and lamented, or…well, I’ll just show it to you.

T-SQL Tuesday #99 - Dealer's Choice / sqlibrium

Andy Levy
This month’s T-SQL Tuesday from Aaron Bertrand gives us a choice: Life beyond the technical in a search for what Drew with the Burdensome Name calls #sqlibrium Your own T-SQL bad habits And I’ve got one, maybe two posts in progress on the first topic. Alas, ironic that being swamped with work is blocking me from writing my #sqlibrium #TSQL2sday post — Andy Levy (@ALevyInROC) February 12, 2018 Thanks to Eugene Meidinger (blog|twitter) for nudging me in the direction of posting this.

T-SQL Tuesday #96: Folks Who Have Made a Difference

Andy Levy
It’s time for T-SQL Tuesday and this month’s edition is hosted by Ewald Cress (blog|twitter). It’s non-technical this month because we’re all recovering from PASS Summit. Ewald asks us to: give a shout-out to people (well-known or otherwise) who have made a meaningful contribution to your life in the world of data. This post is both difficult and easy. Difficult because there are so many people in the community whom I’ve learned from.

T-SQL Tuesday #94 - Automating Configuration Comparison

Andy Levy
This month’s T-SQL Tuesday is hosted by Rob Sewell and he’s posed the following question: What are you going to automate today with PowerShell? I’m cheating a little bit in that this is something I did a couple weeks ago, but it was immensely helpful. I’d been working on building out a new instance to migrate our test databases onto, but the developers had an urgent need to do some testing in isolation so they “borrowed” that new instance.

T-SQL Tuesday #92: Lessons Learned the Hard Way

Andy Levy
This month’s T-SQL Tuesday is hosted by Raul Gonzalez and he’s asked everyone to share things we might be a bit embarrassed about: For this month, I want you peers to write about those important lessons that you learned the hard way, for instance something you did and put your systems down or maybe something you didn’t do and took your systems down. It can be also a bad decision you or someone else took back in the day and you’re still paying for it…