Microsoft markets a variety of SQL Server availability technologies under the umbrella term Always On. Always On is a broad term covers many...
Why your Always On solution is not always on
read more
Peter
Five database administration mistakes that can cost you your job
Everyone makes mistakes. Database administrators are no exception to that rule. When database administrators make mistakes, they are often the ones...
Seven steps to alert effectively
Automated alerts are essential to performance monitoring. Automated alerts enable spotting issues in infrastructures, identifying their causes, and...
Learn more about SQL Server statistics
Statistics, or “stats,” are fundamental components of SQL Server performance, but vastly under-appreciated and misunderstood. They are...
How to balance database security versus database performance
The security of any database can be improved. However, that likely degrades the performance of the database. The cost increases to improve database...
How to Find and Fix SQL Server Deadlocks
Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 3
This is the third part of a three-part series of blog posts. Read also the first part and second part. Analyze Queries In addition to...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 2
This is the second part of a three-part series of blog posts. Read also the first part. Click here to view the third part. Get Overview The...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 1
This is the first part of a three-part series of blog posts. Click here to view the second part. Overview SQL Diagnostic Manager for...
KB: link to blog post “Updated Free Tool: PowerShell Scripts for SQL Server 5.0”
The hyperlink to the Community blog post “Updated Free Tool: PowerShell Scripts for SQL Server 5.0” is...
Five reasons SQL Server health checks are life savers
SQL Server health checks have garnered a great deal of notoriety over the last five years. What was initially a niche offering more than ten years...
Top SQL Server Backup mistakes and how to avoid them
Backing up SQL Server databases is one of the most critical tasks that database administrators perform in their SQL Server environments every day....
How to comprehensively manage SQL Servers on-premise and in the cloud
The volume, velocity, and variety of data is ever-increasing. At the same time, data is becoming ever more critical to the growth of organizations....
Introduction to Windows Azure SQL Database
Many organizations are adopting the cloud computing as their primary computing environment, and others find ways to use Microsoft Azure to enhance...
Initializing replication from backup
Initialization of a transactional replication subscriber is a highly valuable tool. For very large databases (VLDBs), snapshot generation and...
Understanding database backup strategies
As seasoned database administrators, you should be well on top of your backup strategies. These strategies are not written in stone. It is a journey...
How to Start SQL Server Performance Tuning
Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to...
Five reasons your SQL Server is slow
Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch does not exist. There are,...
Top 5 SQL Server cluster setup mistakes
Windows Server Failover Clustering (WSFC) provides infrastructure features that support the high-availability and disaster recovery scenarios of...
Updated Free Tool: PowerShell Scripts for SQL Server 6.0: Added Scripts for Microsoft Azure SQL Database
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 15 new scripts for Microsoft Azure SQL...
Demystify tempdb performance and manageability
Microsoft SQL Server stores a significant amount of data in the tempdb system database. Consequently, tempdb can fill up quickly when disk space is...
Learn about index fragmentation to improve SQL Server performance
As the data in the database tables of Microsoft SQL Server changes, their indexes change. Over time these indexes become fragmented so that ordered...
How to increase SQL Server performance with existing hardware
Unlike their failed counterparts, solutions are successful solely because systems, users, and organizations have come to depend upon them. Solutions...
How to become a database administrator for SQL Server
Database administrators need to handle all facets of managing Microsoft SQL Server ranging from installation and patching to creating databases to...