ABCloudz emerged from the world of data and established itself as a go-to partner for any IT needs. Our professionals are ready to help. Drop us a line today!
More from our Blog
Latest posts
12 sure steps to SQL Server upgrade success
Database migration to Microsoft SQL Server 2019 brings your software data management to a new level. It makes your application more secure, scalable, and customizable. Unfortunately, 44% of digitized businesses state that the lack of technical understanding is one of the main obstacles to successful database modernization. How can they overcome this problem? The solution requires a comprehensive approach and a full understanding of the best practices. We strongly advise to take advantage of the latest version of SQL Server 2019. In […]
Migrating to Azure SQL Managed Instance: Reasons and implications
Azure SQL Managed Instance (MI) is a highly-efficient Azure service that allows combining the broadest SQL Server database compatibility with numerous benefits of a fully managed PaaS (Platform as a Service). MI provides a much higher degree of capability than Azure SQL Database DTU and vCore service levels. Read this blog post to know the main reasons and implications of migrating to Azure SQL MI. Also, get to know how ABCloudz specialists can help you migrate quickly and efficiently. Why […]
Improving SQL Server statistics update: How do you make it 1000 times faster than traditional approaches?
One of our clients contacted ABCloudz to request help with their SQL Server app’s performance issues. They upgraded from SQL Server 2008 R2 to SQL Server 2019 and began experiencing problems shortly after. We analyzed their database system and discovered a complex issue with updating SQL Server statistics. These stats are used by the Query Optimizer to create an execution plan for each query. The problem was that the time to update statistics was taking much longer than the planned […]
Access modernization roadmap for a highly-outdated environment
One of our clients, a major health company, was operating a data system. Over the years, it had expanded dramatically. However, the client had never developed a comprehensive modernization strategy for their product. As a result, they ended up with a highly outdated and inefficient environment overloaded with thousands of Microsoft Access and SQL Server databases. The use of such an outdated system was associated with numerous performance, security, manageability, and scalability risks. In addition, there were frequent database corruptions. […]
