Question A couple years ago we ran into a situation where we were changing the database owner from a DBA’s login to sa, and immediately thereafter we received a complaint that the service login (which was NOT the DBA’s login) no longer had access to … [Read More]
This morning, my friend Aaron Bertrand (blog|twitter) posted a plea for help with STRING_SPLIT() improvements. I’m very much in Aaron’s corner on this, having written about the olden days myself. Why STRING_SPLIT() is supposed to be awesome CLR was fast, but inaccessible to many DBAs. … [Read More]
I’m super excited to announce that today I was notified that I will be joining the Friends of Redgate program! 🎉💃🎊
Question I can take databases offline (via GUI) but can’t bring them back online. The server details are as follow: RDBMS: MS SQL 2016 Express Host: Amazon AWS/RDS Free Tier Details/History of the Problem A few months ago, I created a db instance on Amazon … [Read More]
Copyright © 2024 | Andy Mallon | am2.co