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…
Category: Azure
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…
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…
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 crashes and other errors. Maintenance tasks such as index optimization and statistics updates ensure query processing happens…
I was working on two publisher contracts at the same time. I highly recommend never doing that. One is done, though, and it’s officially published as of September 2022. Check out my database auditing book published with Apress! https://www.amazon.com/Practical-Database-Auditing-Microsoft-Server/dp/1484286332 More to come (hopefully soon) on…
When migrating to managed instance from SQL Server, most features are supported, but you need to assess your SQL Server and the databases you want to migrate to ensure there aren’t any features enabled that aren’t supported. You can do this with the Data Migration…