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. […]
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 […]
Database Slotting Strategies As many organizations are in the process of upgrading and migrating their databases, we as DBAs need to make sure the database has an ideal target environment. The target database environment needs to be able to support the new database(s) for the supported applications while not impacting or adding risk to the […]
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 […]
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.
How often should you assess your servers? Our answer is quarterly, and here are the top 5 reasons of why
As Fortified Data continues to push limits, we align our branding with who we are as a next-generation managed service provider & consulting service.
Fortified Data breaks down the difference between reactive and proactive SQL server database monitoring and which is preferable for your business.
Our SQL Server maintenance tips and recommendations will keep your databases healthy. Includes considerations around data protection, index maintenance, data integrity, data patching and more.