Entries by Fortified

Migrate database from on prem to Azure Managed Instance

I recently had a client that wanted to move their on-premises databases to their Azure environment, specifically to a managed instance in Azure. When I started doing research on the steps to complete this migration, I was bogged down by having to look at different documents and blog posts to determine all the necessary steps. […]

SQL Performance Tuning: Scaling SQL Server

Scaling and optimizing SQL Server are complex exercises when you think about all the different variables that come into the equation because there is not a single checklist that you can apply to every SQL Server or Oracle database. But most companies have to go through the performance tuning exercise with their critical and highly […]

Power BI Datamarts: Bridging the Gap Between IT and Business Users

Introduction to Power BI Datamarts For everyday business function, Power BI Datamarts are positioned to become a strong wielding component to help bridge the gap between business users and the IT team. This new feature in Power BI allows for business users to extract data from different sources, define relationships, and store and explore that […]

SQL Server Upgrades | The Secret To Success Is Planning Ahead

Ask any Database Administrator about why organizations large and small tend to procrastinate about SQL Server upgrades and you’ll hear similar replies: “upgrades are painful, upgrades are difficult,” “everything breaks.” So instead of going through the process of upgrading, they ignore it until it creates a roadblock.