Migrating SQL Server to Azure SQL Database provides essential benefits. Such advantages include the following: lower cost by shifting expenses from...
SQL Doctor
Let the Doctor Fix Your Ailing SQL Server Performance
Microsoft SQL Server is one of the most popular database management systems (DBMS) in the world. As a result of its popularity, many...
A Visit to the Doctor Can Resolve Your Slow Query Issues
Even the most dedicated DBA is occasionally afflicted with some type of physical ailment that requires a day or two off from work. Sometimes all...
How can you tune the performance of SQL Server by analyzing the past to predict the future?
The history of mankind says that we have learned a lot from our past mistakes and improved our future. Similarly, SQL Server performance tuning is...
How do you start with performance tuning for Azure SQL Database?
Have you been interested to see how you can baseline performance and improve performance with an Azure SQL Database? Do you want to grasp the secret...
What are the five essential SQL scripts for SQL Server performance tuning?
Performance tuning is a complex subject and one of the most critical. Every manager wants their server to run faster. And every database...
Where do you start with SQL Server performance tuning?
Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...
How did a large enterprise, banking company in the USA achieve better system uptime and usability?
Mizuho Securities is a large enterprise banking company in the USA. They have 100 to 499 SQL Server databases in their environment. They suffered...
How are you tuning SQL Server in the hybrid cloud?
As organizations migrate their databases to the cloud, database administrators need to manage databases on-premise and in the cloud with existing...
How did a medium enterprise healthcare company in the USA proactively troubleshoot SQL Server issues?
Methodist Hospitals of Dallas, Inc. is a medium enterprise healthcare company in Dallas, Texas, USA. They have 10 to 24 SQL Server databases in...
Keeping Users Happy with High-Performance Databases
Without users, databases are rather abstract constructs that, it can be argued, have no real purpose. It is certainly an interesting technical...
How can you improve the performance, disaster recovery, and security of SQL Server?
SQL Doctor tunes SQL Server performance, security, and disaster recovery via expert recommendations in physical, virtual, and cloud environments -...