The Vital Role of Database SQL Server Capacity Planning
The world is in the midst of a data revolution. The world’s data is expected to grow to 175 zettabytes by 2025, which is five times more than in 2010. As businesses increasingly operate in data-rich environments, scaling and managing this deluge of data effectively is a key concern. Planning the capacity of databases is […]
The Case for SQL Server 2022: Top Features and the Power of Data Analysis
As businesses grapple with ever-increasing volumes of data, the need for robust and efficient data management platforms has never been more critical. Microsoft’s SQL Server 2022, the latest iteration of their flagship database system, is stepping up to address this challenge. Packed with a slew of innovative features and enhancements, this release is setting new […]
End of SQL Server Support Leads to Opportunities
The end of SQL Server support can be a cause for concern, but it also presents opportunities for organizations to optimize their database environment and incorporate new technology features into their service offerings around data. As Microsoft’s support lifecycle for SQL Server comes to an end, organizations may become vulnerable to security risks and other […]
SQL Server Upgrades: Which Is Right For Your System?
In a previous post, we discussed the importance of planning ahead for SQL Server upgrades. Part of planning is understanding which type of SQL Server upgrade is best for your needs. Here, we discuss the advantages and disadvantages of in-place versus side-by-side upgrades. If you have been following our blogs, you know the importance of […]
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
SQL Server Consolidation Planning – SQL Server Tips 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 SQL Server consolidation during the project […]
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 […]
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 […]
Database Migration and Slotting
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 […]
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.