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...
IDERA
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...
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 -...
How did an IT consulting firm save time and money on performance fine tuning for SQL Server?
When companies are looking for a SQL Expert to help with performance challenges, they turn to Oregon-based consulting firm Lake IT for experienced...
How did a healthcare company in South Africa fix a slow and erratic SQL Server?
An IT company that deals with the healthcare industry in South Africa develop a variety of software products, which cover a wide range of...
What do IDERA’s customers have to say about SQL Doctor?
Are you curious about who the customers of SQL Doctor are in terms of the organization, industry, and country? What is the size and the deployment...
How are you tuning the performance of SQL Server, Azure SQL Database, and Amazon RDS for SQL Server?
SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance...
Lessons Learned From 3 Years in the Trenches with AWS
Since the time of our founding, IDERA has been using Amazon Web Services (AWS). It was critical to us to use cloud technologies to build our...
Making Time Using Temporal Data
SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what...
Normalization Heuristics
Heuristics and normalization are the goals of all databases. Heuristics refers to a trial-and-error method of problem-solving used when an...
All Skewed Up
Data can be skewed by its nature. How can you tell if you have skewed data in your database? And if you do, how do you handle it when writing...
Relational Division
Dr. Codd’s original relational algebra had eight basic operations. Since relational database management systems are based on set theory, the...
How can you handle the complexities of analytics for big data for healthcare?
Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...
What are the real benefits of database automation?
Many of the administrative tasks required to keep databases operating efficiently need to be performed regularly. While in some respects, these...
What do you need to consider when moving databases out of the cloud during cloud repatriation?
The promise inherent in new paradigms can often be the impetus for making major decisions in the business world. Companies want to take advantage of...
Is your organization ready for the Internet of Things (IoT)?
The Internet of Things (IoT) is the term used to describe the connection of network-capable devices to the Internet and other connected devices. The...
Learn about advanced database performance tuning for SQL Server and Azure SQL Database.
The roles of database professionals are always evolving. However, their tuning skills should remain sharp. Tuning proficiency is still one of the...
IDERA Newsletter August 2020 (Database Administrator edition)
Product Release SQL Diagnostic Manager for SQL Server 10.6 We are delighted to announce that the latest release of SQL Diagnostic Manager is...
IDERA Newsletter August 2020 (Database Developer edition)
Product Release New! Aqua Data Studio 20.6 We are delighted to announce that the latest release of Aqua Data Studio is now available....