DSP Blog: SQL Server

-->

Latest Posts

Assessing an application’s Data Access Layer using SQL Server Data Migration Assistant

When upgrading to a higher version of SQL Server, or when migrating to Azure, there can be certain compatibility issues between versions of SQL Server that can throw a spanner in..

Read More

How to modernise when SQL Server 2014 enters End of Extended Support

Attention all SQL Server 2014 users! The clock is ticking - extended support for this version ends on 9th July 2024, and it is time to take a look at the options that will keep..

Read More

Optimising SQL Server Queries: A Performance Tuning Success Story

We recently had an SQL Server customer who reported intermittent poor performance with an SQL query, similar to the statement below. The SQL query referenced a view, and that view..

Read More

Top 10 Signs Your SQL Server Needs a Health Check

When was the last time you underwent a thorough SQL Server Health Check? If you can't remember, or if it's been quite a while, now might be the right time to consider one. Just..

Read More

SQL Server 2012 End of Support: What are your options?

SQL Server 2012 will soon enter End of Support and Microsoft will no longer provide security updates to users. If you're currently using SQL Server 2012, now is the time to choose..

Read More

How to select and get the most out of your Managed Service Provider

Selecting and managing your Managed Service Provider (MSP) is critical to slick business operations and success in the cloud. With many alternative options available, I want to..

Read More

Keeping your Managed Services under one roof

Making your environment cloud capable is a key step towards modernisation and consolidation. However, many organisations with estates hosted across multiple technologies – for..

Read More