#tsql2sday

This month's #tsql2sday is hosted by the diligentdba, who asks us how we manage our #database code. Well, as the de-facto #DB #DevOps expert over at #MadeiraData, I felt obliged to participate. There's no way I'll be missing this one ;)

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 obliged to participate and contribute my piece. Continue reading T-SQL Tuesday 177: Managing database code

#AlwaysOn Availability Groups can be tricky when it comes to cluster configurations. Check out this real-life scenario involving DR exercises and quorum failures. #Microsoft #SQLServer #HADR #Blog #MadeiraData

In a recent incident involving AlwaysOn Availability Groups, an interesting lesson was learned about cluster configurations and the delicate balance of democratic votes within them. The scenario occurred during a routine DR exercise, where a client’s entire cluster collapsed unexpectedly, prompting an investigation into the root cause. As it turned out, the issue stemmed from the cluster…

This month's #tsqltuesday is an especially interesting one hosted by @SQLDoubleG. Raul asks us to talk about "Worst Practices" and when could they be a good thing to use.

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! Continue reading Untitled

This month's #tsqltuesday is hosted by @sqlstudent144 who asks us to talk about our first tech job. This could be an interesting story, don't you think?

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…

This 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 Andy Leonard (b|t), who is asking us to write about “software changes”. Specifically, the question is: “How Do You Respond When Technology Changes Under You?” And my answer is: “I try to change as well and adapt, since my work is often dependent on the changing technology” It’s not like we have any other choice, right? Link back to Andy’s invitation…

[New #Blog] My submission for this month's #tsql2sday 136 - Most and Least Favorite Data Type Hosted by @BrentO #SQLServer #TSQL

This month’s T-SQL Tuesday is hosted by Brent Ozar (b|t), who asks us to Blog about our Favorite Data Type (or Least Favorite). Link back to Brent’s invitation post 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? Here we go. Favorite Data Type: xml The xml data type in SQL Server exists since…

[New #Blog Post] Here's my #tsql2sday 135 submission hosted by @MikeyBronowski: The Tools of My Trade

This month’s T-SQL Tuesday is hosted by Mikey Bronowski (b|t), and asks us to share the tools of the trade that make our job awesome. Link back to Mikey’s invitation post I feel that this topic (again) links back to similar T-SQL Tuesdays about productivity where I also participated (see T-SQL Tuesday #123, T-SQL Tuesday #127, and T-SQL Tuesday #130). While I do feel that the tools that make…

[New #Blog Post] #tsql2sday 134 - I WISH I could Take a Break #tsqltuesday

I’m publishing this post a week late, I know. But that’s all the more fitting, considering the contents of this post. Continue reading