SQL Archives

A User-Centric Tuning Philosophy

Collaborative Holistic Tuning of the Application Stack When planning for this blog, I deliberated over the title much more than anyone should ever...

SQL Server Alert Management: From Chaos to Clarity

by Idera

Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction In the fast-paced world of database administration, staying ahead...

Navigating SQL Server CPU and Memory Usage Woes

by Idera

Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Microsoft SQL Server is a powerful database management system, but...

Making the Most of Historical Data: Preventing Future SQL Server Issues

by Idera

Author This blog post was authored by Pinal Dave from SQLAuthority. Introduction Forecasting future SQL Server performance issues can often feel...

How to Maintain Security Compliance to Prevent a Costly Breach

by Kyle

As businesses and government organizations shift a growing amount of their operations online, data security has become an increasingly important...

Announcing the General Availability of SQL Compliance Manager 6.0

by Elan Kol

We’re excited to announce the release of SQL Compliance Manager 6.0 SQL Compliance Manager is the industry leading SQL Server auditing solution that...

Announcing the General Availability of SQL Secure 4.2

by Mostafa Khalilnasab

We are pleased to announce the general availability of SQL Secure 4.2 SQL Secure is the industry-leading, state of the art auditing and security...

Improve ETL Performance by Disabling Non-clustered Indexes

by Jeff Iannucci

Perhaps you just read the title and thought, “Disable indexes…say what?” Stay with me here, and I'll show you how this...

The Most Surprising SQL Antipattern We Use

by Jeff Iannucci

Do you like hammering nails with screwdrivers? Me neither, but all too often we take this kind of approach when writing our SQL queries. We use the...

A Tool for Creating More Efficient SQL Code Quickly

by Robert Agar

Information technology has become one of the most important manifestations of society’s technological advancements. IT systems are widely used...

Announcing the GA Release of SQL Safe Backup 8.6

by Former Member

We are pleased to announce the general availability of SQL Safe Backup 8.6. IDERA SQL Safe Backup provides a mission-critical backup and recovery...

DBArtisan Tips and Tricks Webinar November 2019

by BryanThomas

The November edition of DBArtisan tips and techniques Webinar covered three tips for using DBArtisan. Using Projects to organize your work...

A One-Stop Solution to SQL Coding Problems

by Robert Agar

A One-Stop Solution to SQL Coding Problems One of the challenges a DBA must deal with on a daily basis is negotiating the multiple database...

Announcing the General Availability of SQL Safe Backup 8.5.2

by Former Member

We are pleased to announce the general availability of SQL Safe Backup 8.5.2. Existing users may upgrade to this version through the IDERA Customer...

May #SQLChat – Designing Data Warehouses

by Kirsten Baumann

IDERA’s #SQLChat is back! Join IDERA (@Idera_Software) and host Leslie Andrews (@landrews5807) on Wednesday May 29 at 11AM CT for...

How to Create High Quality SQL Code that is Easy to Edit. – Aqua Data Studio IDE

by Crystal Berry

In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...