SQL Server Archives

SQL Diagnostic Manager 10.4 Preview

SQL Diagnostic Manager 10.4 will be available soon and it currently available for our beta customers at...

What are visual SQL tuning diagrams?

SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important...

Announcing SQL Inventory Manager 2.5 General Availability

by Joy Ruff

We are pleased to announce the general availability of SQL Inventory Manager 2.5. Existing users may upgrade to this version through the IDERA...

How to Find and Fix SQL Server Deadlocks

by Peter

Introduction Locking is required for concurrent operations of relational databases to prevent data inconsistency and loss. However, locking impairs...

DBA Paradox – Plus ca change, plus c’est la meme chose

by Scott Stone

The quote comes from Jean-Baptiste Karr. And while some may not be familiar with the source and that original language version, almost...

Five reasons SQL Server health checks are life savers

by Peter

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...

September #SQLChat: Automation in SQL Server – How to Work Only 40 Hours a Week

by Former Member

Automation in SQL Server - the one thing that can salvage the sanity of the DBA. While automating backups and maintenance processes is common place...

Secrets of FireDAC: Pagination With Grids And LiveBindings

by Eli M.

If you want to display only a range of results from a recordset you can using paging (otherwise known as pagination) to do so. It is a common...

Top SQL Server Backup mistakes and how to avoid them

by Peter

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

by Peter

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....

Does Database or Version Matter?

by Bert Scalzo

I’m sure you’ve heard the saying, “Never discuss politics or religion in polite company”. That’s good advice. This...

SQL Diagnostic Manager 10.3 General Availability

by Scott Stone

We are pleased to announce the general availability of SQL Diagnostic Manager 10.3. Existing users may upgrade to this version through...

Initializing replication from backup

by Peter

Initialization of a transactional replication subscriber is a highly valuable tool. For very large databases (VLDBs), snapshot generation and...

Understanding database backup strategies

by Peter

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

by Peter

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

by Peter

Everybody would love to find the mythical “go faster” switch in SQL Server. Unfortunately, this switch does not exist. There are, however, many...

GDPR and the SQL Security Suite

by Kim Brushaber

On May 25th, 2018, GDPR (General Data Protection Regulation) went into effect. This regulation affects anyone who collects PII (Personally...

Announcing ER/Studio 17.1 General Availability

by Ron Huizenga

We are pleased to announce the general availability (GA) of IDERA ER/Studio 17.1 ER/Studio 17.1 contains improvements and enhancements in a number...

August #SQLChat – SQL Server Coding Standards

by Former Member

Designing and managing databases can be a daunting tasks. However, defining database coding standards can help keep everything in order. Join IDERA...