In one of my previous blog posts, Automatically Enable or Disable Jobs based on HADR Role, I provided a solution for managing scheduled jobs correctly 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!
This month’s #tsql2sday is hosted by the legendary Glenn Berry, and asks us about what we’ve been doing as a response to COVID-19.
We at Madeira Data Solutions did quite a lot to chip in during these difficult times. Hopefully, it’s enough to make some kind of difference.
You might have seen the 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…
The #DataWeekender is a free online conference scheduled for May 2nd, organized by the SQL Server community’s finest, as an online replacement for all the SQL Saturdays and other SQL Server conferences that were being canceled en masse due to the COVID-19 situation.
I am also a speaker in the event, and I’ll be presenting my Development Lifecycle Basics for DBAs webinar!
This month’s #tsql2sday is hosted by Hamish Watson and this time touches on the extremely important topic of database unit testing. Its high importance and value should be a no-brainer. But it can be a very difficult topic, and the hardest thing about it, in my opinion, is knowing where to start. Hopefully, with this blog post, I can help you out with that.
Ever wondered what makes your SHRINK go so damn slow? It’s more common than you think, and not impossible to solve!
The lethal #COVID19 strain of the #Corona virus is officially a Pandemic, and we quickly realized how fast such a thing can spread in this era of Globalization. With the virus pandemic also arrives a pandemic of blog posts and social network noise. Everyone’s writing and talking about this topic. So, I guess I must too.
Can Azure SQL Analytics be a decent competitor to powerhouses such as SentryOne, RedGate, ApexSQ, Solarwinds and others? Let’s find out!
We all know the error log used by SQL Server to audit failed logins by default. But is it really good enough? For many scenarios, it isn’t. It’s actually missing a lot of important information. But, worry not, for there are better solutions!
This script performs compression savings estimation check across the ENTIRE database within which it is executed, AND generate the relevant remediation scripts for you.
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.
Other ways to find me: