In one of my previous blog posts, Automatically Enable or Disable Jobs based on HADR Role, I provided a solution for automatically enabling or disabling scheduled jobs in combination with Availability Groups and Database Mirroring. In this blog post, I’m going to build upon my previous solution and improve it even further – taking it to the next level of automation!Read More »Control SQL Jobs based on HADR Role – Taking it to the Next Level
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.Read More »T-SQL Tuesday #126 – Responding to COVID-19
You might have seen this blog post by Paul White: New Metadata-Only Column Changes in SQL Server 2016. It talks about how, when a table is compressed, you can change (i.e. increase) a column’s data type without having to create a new table and migrate the data into it, and without having to refactor all of the underlying data. But, not everything is rainbows and unicorns…Read More »The new “metadata-only column changes” feature in SQL Server 2016 is useless!