It’s an honor to host this month’s T-SQL Tuesday. In case you don’t know the rules already, here is a recap of them: Earlier this year, when I was looking for a new job, I realized that there are a lot of conceptions about what…
A coworker recently introduced me to the SQL Server Schema Compare extension in Azure Data Studio. It has come in handy since we don’t have any paid-for tools, so it has been a great help to have this extension installed. I will show you how…
First, thank you to Guy in a Cube for a great licensing/cost video. My company is exploring what data warehousing technology to use in Azure. I needed to learn more about the licensing and costs associated with Microsoft Fabric. This is all stuff you can…
Restoring a SQL Server backup in a Docker container is quite easy. To begin with, you will need persistent storage on your Docker container to follow this blog post. To get that setup, you can follow the instructions in this blog post. I found that…
This all started because I wanted to follow Tracy’s directions on setting up Ola for index maintenance in Runbooks. I couldn’t set up the automation account permissions unless I was logged in with Azure Active Directory – Univeral with MFA. When I Googled, I didn’t…
Information security and privacy are key in today’s data-driven world. Sensitive data needs to be protected from unauthorized access. With column masking in SQL Server and Azure SQL, you can conceal sensitive data, allowing only authorized users to see it. Understanding Column Masking Column masking…
This is an easy way to retain the data and settings you create and change on your SQL Server Docker instance. There’s a lot of talk about attaching databases after creating your Docker container. I found that you can mount the volumes that SQL Server…
Update: My favorite way is with Elastic Agent now. You can find my posts on that here. Database maintenance is crucial for the health and performance of any database system, including those in Azure. Without regular maintenance, databases can become slow, unstable, and prone to…
Thank you to Data Platform WIT and DEI for hosting Mental Health and Wellness Day! I was honored to be included. To see the full lineup, please visit https://www.meetup.com/data-platform-dei/events/293091941/ DISCLAIMER: THIS WEBSITE DOES NOT PROVIDE MEDICAL ADVICEThe information, including but not limited to, text, graphics,…
This is part of a series of new job blog posts. You can find them all here. As a DBA, the first six weeks on the job can be challenging and exciting. During this period, you are expected to learn about the company’s processes. You…
