NOTE: This post first appeared on Simple-Talk.
I often joke that I wish cloning was perfected so that I could be two places at once. Sometimes, it is hard to decide which opportunity is more important, for example, my niece’s graduation party ended on up the same day as a concert with my favourite band. My ticket included a meet and greet pass. (Sorry, Katie, I chose the concert, but I did send you a nice card and check.)
A couple of months ago, our manager informed the team when the next SQL in the City broadcast would be, the 20th of June. Oops, I have the biggest holiday trip of my life planned that week, a trip I have been planning and saving towards for five years. Along with my husband, our kids and their families, I will travel to one of the hottest spots on earth right now, The Big Island of Hawaii. Yes, that is where Mount Kilauea has been erupting for several weeks.
Thanks to modern technology, I don’t have to be in Cambridge on the day of the SQL in the City broadcast. I made a trip to the UK in May to record my session so that I can experience my vacation trip without worrying about my job. Hopefully, everyone will enjoy my presentation even though it is not live like the rest of the day.
Each SQL in the City broadcast has a theme. This time, the theme is Compliant Database DevOps. This is an important topic as companies around the world make sure they are compliant with the GDPR. Understanding the GDPR and other regulations is important for database professionals, especially database administrators who are really the caretakers of data in most companies. My session demonstrates how monitoring can help DBAs with compliance. I see monitoring divided into four areas: resources, configuration, maintenance, and performance. Aspects of data protection are baked into all of them.
This event is a great way to learn more about ways to protect data, such as creating a catalogue of servers, databases, and tables that contain sensitive information and providing clones of production databases for developers with all sensitive information masked. You’ll also learn how your team can be more efficient when writing T-SQL Code.
While on vacation, I’ll miss seeing my fellow MVPs Grant Fritchey (@gfritchey) and Steve Jones (@way0utwest) that week, but you don’t have to miss out. Register today!