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...
Blog
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
How to Create a Plan for Regulatory Compliance
Many reasons may make it important for an organization that collects and stores digital information to be concerned with regulatory compliance. Data...
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...
Announcing the Release of SQL Safe Backup 8.7
We’re excited to announce the release of SQL Safe Backup 8.7 SQL Safe Backup is the industry leading mission-critical backup and recovery solution...
Announcing the Release of SQL Defrag Manager 3.6
We’re excited to announce the release of SQL Defrag Manager 3.6 SQL Defrag Manager is an industry leading automated performance solution that...
How ISV’s Drive Innovation with InterBase
I recently ran a webinar, alongside Mary Kelly, discussing how InterBase ISV’s are innovating faster while improving profitability and return...
The Right Tools Make a DBA More Productive
The work-life of a SQL Server DBA can be unpredictable. One might be called upon to address a performance issue, setup logins, verify the backup...
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...
KB: Selection of PowerShell Resources
Microsoft Windows PowerShell Infographic: Why DBAs Should Learn PowerShell? Whitepaper: The Guide to Learning PowerShell Geek Sync Webcasts: The...
RATs Can be a Security Threat to Your SQL Servers
Before you click away, let me assure you that this post is not about rodents chewing on power cords or networking cables. RATs is an acronym for...
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...
Cloud Day 2—High Availability and Disaster Recovery in the Cloud
One of my favorite topics in cloud computing is disaster recovery. A decade ago, if you wanted to have true disaster recovery across multiple...
Why You Should Care about Database Index Fragmentation
Providing smoothly running systems that quickly respond to user queries keeps both customers and management happy. All but the most inexperienced...
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...
Where Can I Host MySQL Databases in the Cloud?
Organizations can enjoy many benefits by choosing to migrate some or all of their computing resources to the cloud. There are often financial...
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...
Keeping an Eye on All of Your SQL Servers
The majority of organizations that use SQL Server as one of their database solutions have more than one instance in their environment. In some...
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...
Geek Sync | Improving Query Performance in Azure SQL Database
Moving to Azure SQL can help with many things, including faster scalability and easier disaster recovery strategy implementation. Unfortunately, one...
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 -...
Prepare for the Worst, Hope for the Best
If you have spent any time in the IT world, you probably know that things do not always go according to plan. In fact, at times it seems that...
Cloud Day 2–Understanding Cloud Storage
Welcome to the Cloud Day 2—in this series you will learn about some slightly more advanced topics in the public cloud. We’re going to go...
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...
Don’t Fear the Robot Database Administrators
Nightmares about automation can conjure up images of shiny robots toiling away tirelessly without ever making an error or requiring a break. At...
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...
Why You Should Consolidate Your SQL Server Environment
Microsoft’s SQL Server is one of the most widely-used relational database solutions on the planet. Due to its popularity, there are numerous...
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...
How to Handle Unexpected Issues During Cloud Migration
A common issue that affects many areas of the IT world is that things often do not go as smoothly as anticipated. Despite the best efforts that...