#TSQL2sday

[eitanblumin]

T-SQL Tuesday 177: Managing database code

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

[releaseteam]

New post from _AlexYates_: Continuous Database Deployment… to Production. #tsql2sday #119 https://t.co/iqQFToiyOC

— DLM Consultants (@DLM_Consultants) October 8, 2019

via: https://ift.tt/1GAs5mb

[gregdodd]

TSQL-Tuesday - Automate Your Stress Away

TSQL-Tuesday - Automate Your Stress Away #tsql2sday

Elizabeth Noble is hosting this months TSQL-Tuesday, and she asks a great question: How do you automate stress away from your life?

I love automation, not because automation is cool in itself (although it is) but I love it because of all the side benefits it gives you.

It means I stuff up less often

Do you need to run a process every month? Do you need to generate a report every day?…

[sqljoker]

Tweeted

Invitation to #tsql2sday 96: Give a shout out to people who have made a difference in your career.https://t.co/05EFdEt6Vy http://pic.twitter.com/tw7jTfrOcO

— Ewald Cress (@sqlOnIce) November 7, 2017

[eitanblumin]

Forced Quorum Mode and The Value of Democracy

#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…

[eitanblumin]

T-SQL Tuesday #158 - When Worst Practices are the Best

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

[eitanblumin]

T-SQL Tuesday #152 - Which version of my database was deployed? It depends!

This month's #tsql2sday is hosted by @dgmelkin who's inviting us for a rant. And boy, do I got one! #Microsoft #SQLServer #SSDT #DevOps #MadeiraData

This 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 🤭 (more…)

[eitanblumin]

T-SQL Tuesday #150 - My First Tech Job

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…

[eitanblumin]

T-SQL Tuesday 138 - sp_help_revlogin is dead, long live sp_help_revlogin2

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…

[eitanblumin]

T-SQL Tuesday #136 - Most and Least Favorite Data Type

[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…

[eitanblumin]

T-SQL Tuesday #135: The Tools of My Trade

[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…

[eitanblumin]

T-SQL Tuesday #134 - I WISH I could Take a Break

[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

[eitanblumin]

T-SQL Tuesday #130 - Eitan's Laws of Automation

[New #Blog Post] #tsqltuesday 130 - Eitan's Laws of #Automation

This month, Elizabeth Noble is hosting #tsql2sday with the topic of automation. This is very similar to previous couple of T-SQL Tuesdays hosted by Ken Fisher (127) and Jess Pomfret (123). I already wrote about the topic of automation extensively in those past posts. So, instead of repeating myself, I’m gonna write about this topic a bit differently.

(more…)

[eitanblumin]

T-SQL Tuesday 127 - Tips and Tricks to Automate Your Life

This month's #tsql2sday - Tips and Tricks to #Automate your life!

This month’s #tsql2sday is hosted by Kevin Fisher (b|t) who asks us to share tips unrelated to database systems. I will take this opportunity to talk about what you can do to easily automate a lot of your daily tasks, and never miss a thing.

(more…)

[eitanblumin]

#tsql2sday 126 - Responding to COVID-19

#tsql2sday 126 - @Madeira_Data Responding to COVID-19

This month’s #tsql2sday is hosted by the legendary Glenn Berry (b|t), and asks us about what we’ve been doing as a response to COVID-19. Madeira Data Solutions did quite a lot to chip in during these difficult times. Hopefully, it’s enough to make some kind of difference.

Due to the nature of this post’s content, it was published on the Madeira Data Solutions Blog. Check it out!

(more…)

[eitanblumin]

T-SQL Tuesday 143 - Short Powershell code to move DB files in AlwaysOn

This month's #tsql2sday is hosted by John McCormack (@actualjohn) who asks us to share some useful snippets of code that can help us in our every-day jobs. And today: a #Powershell code to move DB files in AlwaysOn #HADR. #SQLServer #MadeiraData

This month’s #tsql2sday is hosted by John McCormack who asks us to share some useful snippets of code that can help us in our every-day jobs. Well, honestly, this is more or less what my blog is mostly about anyway – sharing insights, scripts, and code snippets that I found to be helpful in my day-to-day job as a SQL Server consultant. (more…)