Entries by Ben DeBow

Boost SQL Server Performance: 20 Indexing Strategy Tips to Elevate Your Database

How can you achieve a 1,000% improvement in a crucial database process with just one modification, all while maintaining your application’s functionality? The key lies in crafting the perfect indexing strategy for your database. Performance tuning is vital for ensuring that your SQL Server-based applications run seamlessly and efficiently. Among the most critical aspects of […]

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 […]

Database Subsetting: Optimizing Application Testing

In today’s fast-paced digital world, quality assurance and efficient testing methodologies are crucial elements of any successful software development project. A cornerstone technique for developers and database administrators (DBAs) alike is database subsetting. This strategy not only minimizes the overhead of testing environments but also preserves the quality and integrity of the testing process. What […]

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 […]

6 Ways to Enhance Microsoft SQL Server Security

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 […]

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 […]