Entries by Fortified

The Financial Gains in Engaging a Database Managed Services Company

We are over a year into the Great Resignation and there are no signs of it slowing. With the Great Resignation and a saturated hiring market, many companies are challenged with finding expert talent to take care of their internal database systems. Add this to the impending recession and many companies are finding themselves in […]

SQL Server Consolidation Planning

As many organizations are in the process of upgrading and migrating their databases, it is a great opportunity to save money, improve performance and increase the database service offerings for the organization. Typically, the organization is expecting a certain level of consolidation during the project to help reduce licensing, hosting costs and administrative costs long […]

SQL Server Memory Health: Performance Monitor Counters

Often there are times that we to need assess the health of a SQL Server instance, but we have not yet added all the monitoring tools to the environment, which can involve approvals to install software, assign admin rights to accounts, and in general just take time to set up. What do we do if […]

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 Aheads

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.