IDERA Archives

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

Azure MySQL Database as a Service – The next best thing to an Azure Database as a Service Addon

by Anil M

Azure MySQL...

Welcome Webyog Social Media Followers!

by Former Member

We are excited to welcome Webyog into the Idera, Inc. family! In an effort to streamline all social media accounts, we are transitioning Webyog and...

SQL Diagnostic Manager for MySQL 8.7 General Availability

by Scott Stone

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

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

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

Top 5 SQL Server cluster setup mistakes

by Peter

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

by Peter

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

by Peter

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

by Peter

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

by Peter

Unlike their failed counterparts, solutions are successful solely because systems, users, and organizations have come to depend upon them. Solutions...

Data Lineage – The Power to Connect the Dots in ER/Studio

by Anil M

Howdy! Ever considered or wanted to know how Data would move around the organization? Data Lineage is a key driver that ensures on connecting the...

How to become a database administrator for SQL Server

by Peter

Database administrators need to handle all facets of managing Microsoft SQL Server ranging from installation and patching to creating databases to...

How to learn PowerShell for free

by Peter

Microsoft’s Windows PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language...

Connecting to PostgreSQL and MySQL via ODBC to IDERA’s ER/Studio Data Architect

by Anil M

Howdy! Introduction: In this blog post, we will show you how easy it is to connect to MySQL and PostgreSQL via ODBC. As you are aware we can reverse...

Welcome AquaCluster Users to the IDERA Community!

by Former Member

We are excited to welcome the AquaCluster users to the IDERA Community! As you know, IDERA acquired AquaFold in July 2017, and we are committed to...

How To Improve a Business-critical Third-party Application by Optimizing Its Generic Database Settings

by Peter

Problem Background A business-critical third-party application for Microsoft SQL Server configured the database with generic settings, including...

June #SQLChat – Soft Skills for the DBA / Developer

by Former Member

As a database administrator and IT professional there are certain technical skills that one is expected to know - but what soft skills are...

Learn More about the Cloud with these Free Resources

by Peter

You may already know that the cloud provides always-on architecture, automatic monitoring and management, enterprise-class security, fast access to...