Hear from our thought leaders, stay up to date with company news, and learn more about how we’re impacting our community.

Database performance tuning is a critical aspect of ensuring optimal system function and end-user experience. In our previous article, we explored the basics of database performance tuning, the importance of establishing a performance baseline, common performance issues, and a checklist of tasks for tuning SQL Server and Oracle databases. In this follow-up article, we will delve into more advanced strategies

What is database health: 

Database server versions come and go; updates ride in and out like predictable tides. SQL Server 2022 is one of the newer updates in the data world, only recently being released to the general public. Here are 5 update buckets in the SQL Server flagship (all unique only to SQL Server 2022) to keep an eye out for: 

 

Whether your company uses on-premise database systems or has made the popular jump to the Cloud, there is a definite uptick in automated systems. This is a newer option in which aspects of data upkeep are routinely updated, monitored, and fixed by an online system. 

Data backup and recovery processes are essential for operational efficiency and peace of mind. Think of all the valuable content stored in your organization’s database. From essential internal documentation to sensitive client data and beyond, data resources today are too valuable to take for granted.

Laurel George, our newest Solvarian, will be working as our new Community Relations Specialist. Welcome to the team, Laurel! 

Kerberos, a Windows authentication protocol that authenticates online service requests, has recently been found to have some issues.  

When shopping at a grocery store, you want an undemanding experience. The aisles should be organized and clearly labeled. All areas should be clean. And when checking out, you’re hoping for expedited lines and un-smashed eggs in your grocery bags. If a grocery store has any of these key pieces missing, a manager comes in to fix things.  

Is Azure SQL the same as SQL Server?