Designing and managing databases can be a daunting tasks. However, defining database coding standards can help keep everything in order. Join IDERA...
August #SQLChat – SQL Server Coding Standards
read more
IDERA
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...
Data Lineage – The Power to Connect the Dots in ER/Studio
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
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
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
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!
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
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
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
You may already know that the cloud provides always-on architecture, automatic monitoring and management, enterprise-class security, fast access to...
Webyog joins Idera’s Database Tools Family
We’re excited to announce that Webyog has been acquired by Idera, Inc. Idera, Inc. is a leading provider of B2B software productivity tools that...
Is Redshift giving you the Blues? ER/Studio has the cure.
In my 35 years of data modeling many data platforms have come and gone, while others continue to change. For many, maintaining pace with the...
Free Virtual Conference! IDERA Live 2018
It’s that time of year again! We invite you to join us for IDERA Live, our second-annual Virtual Conference, designed to educate and inform...
Virtual Machine Snapshots versus Database Backups
Virtual Machine Snapshots Virtual machines provide exciting possibilities concerning backup, recovery, and cloning of databases. Convenient...
April #SQLChat – Participate to Win an Amazon Tap!
Data Governance is essential for companies working in highly regulated industries and it is important for organizations to review their Data...
Five Important Features of SQL Diagnostic Manager
SQL Diagnostic Manager is a robust performance monitoring, alerting and diagnostics solution for SQL Server. It proactively notifies of health,...
Updated Free Tool: PowerShell Scripts for SQL Server 5.0: Added Center for Internet Security (CIS) Benchmarks
IDERA released an update of its free tool PowerShell Scripts for SQL Server. This release features 30 new scripts for Center for Internet Security...
Quickly deliver relevant data to the right people to improve DevOps
Challenge As the number of projects for developing applications increases, organizations struggle with quality assurance, release management, and...
How to monitor Always On availability groups
Always On availability groups are part of an integrated solution with the goal of achieving the highest level of data availability and disaster...
February #SQLChat – Becoming a Microsoft MVP
Are you hoping to become a Microsoft MVP? Or, have you already gone through the application process yourself? Then participate in our next Twitter...