SQL Server plays a significant role in storing and managing sensitive information. However, with the growing threat of cyberattacks and data breaches, it’s crucial to implement security measures to ensure that your data remains secure. It seems the news about system outages and data breaches is everywhere. In just the last few weeks, both Boost […]
Migrating Oracle Real Application Clusters (RAC) to Oracle Cloud Infrastructure (OCI) can be a complex process that requires careful planning and execution when dealing with this operating system. While there are many benefits to migrating to OCI, there are also several challenges that businesses may encounter during the migration process. In this blog post, we’ll […]
Migrating Oracle workloads to Oracle Cloud Infrastructure (OCI) can be a complex process that requires careful planning and execution. Though there are various benefits of migrating Oracle to OCI, there are also some challenges. While there are many benefits to migrating to OCI, there are also several challenges that businesses may encounter during the migration […]
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 […]
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 […]
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 […]
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 […]