SQL Server indexes can improve SQL Query performance when done correctly - but how do you create an optimal set of indexes? Join IDERA...
SQL Server
Enjoy May Day without “mayday” – protect your SQL Server data
May 1st is traditionally celebrated as “May Day” to welcome the return of spring. In Central Texas, we often get a lot of rain in the...
Data Modeling Made Easy using ER/Studio Data Architect
Howdy folks! Today we will be taking a look on how to create a simple Data model using IDERA's Flagship Data Modeling tool, IDERA...
Aqua Data Studio – Working with Complex Data Environments Can Be A Challenge.
Companies are expanding their systems beyond relational databases to incorporate big data and cloud deployments, creating hybrid configurations....
IDERA Live 2019! Free Virtual Conference
Join us for our third-annual IDERA Live Virtual Conference designed to educate and inform users of any level in a fun, engaging atmosphere....
SQL Diagnostic Manager 10.4 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.4. Existing users may upgrade to this version through...
SQL Diagnostic Manager 10.4 Preview
SQL Diagnostic Manager 10.4 will be available soon and it currently available for our beta customers at...
Use ER/Studio Governance Attachments in SQL Server (and other platforms too!)
ER/Studio Data Architect contains extensive metadata for all constructs utilized in the models and data dictionaries, whether used in logical...
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
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
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
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
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
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
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
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....
Does Database or Version Matter?
I’m sure you’ve heard the saying, “Never discuss politics or religion in polite company”. That’s good advice. This...
Welcome Webyog Social Media Followers!
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 10.3 General Availability
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
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, however, many...