This month’s #tsql2sday is hosted by Malathi, a.k.a Mala, a.k.a diligentdba (b), and asks us about how we manage our database code.
Well, as the de-facto DB DevOps expert over at Madeira Data Solutions, I felt obligated (and obliged) to participate and contribute my piece.
Read More »T-SQL Tuesday 177: Managing database code
AlwaysOn Availability Groups can be tricky when it comes to cluster configurations. Learn from a real-life scenario involving DR exercises and quorum failures.
This month’s T-SQL Tuesday is an especially interesting one! Hosted by Raul Gonzalez (b|t), Raul asks us to talk about “Worst Practices” and when could they be a good thing to use. After all, the actual “best practice” is – well… it depends!
Read More »T-SQL Tuesday #158 – When Worst Practices are the BestThis month’s T-SQL Tuesday is hosted by Deb the DBA (b|t), who invites us to give a long rant about a question that a coworker could be asking us, without knowing what they’ve just gotten themselves into by doing that.
Well… I’ve got just the thing 🤭
Read More »T-SQL Tuesday #152 – Which version of my database was deployed? It depends!This month’s #tsqltuesday is hosted by Kenneth Fisher (b|t), who wants us to share stories about our first tech job (or first job ever if it makes for a good story).
My first job ever was delivering a magazine door-to-door in one neighborhood. It doesn’t actually make for a good story as it’s pretty bland and boring. Except maybe for how when I got my first paycheck (which was a measly 50 shekels for one morning’s work), I was so excited that my hands literally trembled and I had a stupid grin on my face that I couldn’t get rid of for the next hour or so (it’s stupid, I know, but come on, I was barely in high-school at the time).
I imagine that wasn’t very interesting, so I’ll tell you about my first real job (which was indeed a tech job).
Read More »T-SQL Tuesday #150 – My First Tech JobThis month’s #tsql2sday is hosted by @AndyLeonard, who asks us to write about “software changes”. Well, I think it’s time to be changing sp_help_revlogin. What do you think?
This month’s T-SQL Tuesday is hosted by Brent Ozar, who asks us to Blog about our Favorite Data Type (or Least Favorite).
I find it actually quite easy to decide both on a most-favorite, as well as a least-favorite data type in SQL Server. So, why not blog about both?
This month’s T-SQL Tuesday is hosted by Mikey Bronowski, and asks us to share the tools of the trade that make our job awesome.
While I do feel that the tools that make my job the awesomest are those that help me with productivity, this month’s topic is a bit broader.
I’m publishing this post a week late, I know. But that’s all the more fitting, considering the contents of this post.
Read More »T-SQL Tuesday #134 – I WISH I could Take a Break
This month’s #tsql2sday came to us from Rob Volk (b|t), who asks us to explain databases using an analogy, as if explaining to a 5 year old. I’m actually a big fan of The Feynman Technique (aka ELI5), so I really wanted to participate. But to be honest, I nearly missed out this time simply because I couldn’t think of an idea this whole week.
On the very last day, when the posts already started rolling out by all the bloggers, I’ve read a few, and only then the muse finally hit me. I kid you not, the time is literally 23:59 here in Israel as I hit the publish button!
So anyways, the idea I had was for the ALTER TABLE..SWITCH TO command in SQL Server.
Read More »T-SQL Tuesday #131 – Star Trek Candy and SWITCH TO