Monitoring & Performance
Security & Compliance
Data Modeling and Architecture
Aqua Data Studio
SQL Development and Tuning
Uptime Cloud Monitor
Uptime Infrastructure Monitor
Ask the Experts
sql diagnostic manager
Blog - Post List
By view count
By comment count
Why Data Breach is a Significant Part of GDPR
Last week I spoke at DAMA Day in NYC. The day was focused on GDPR and all of the implications in the regulation. I decided to focus my talk on why Data Breach is such a big deal that it has its own articles included in the GDPR Regulation. Data...
28 Jun 2018
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 data retrieval becomes less efficient. Consequently, the fragmentation adversely affects the performan...
27 Jun 2018
Changing Lanes: Part II. Shifting between Relational and Big Data Platforms
In the last blog
, I covered Shifting Roles with Relational and Big Data Platforms and how that is affecting the people and their roles within companies. This blog will focus on the actual platforms and what it means to be Relational vs NoSQL. W...
26 Jun 2018
Lots more support for Azure monitoring! Part 2 of 5
Part 2: Details of All Azure Monitored Services This is the continuation of
Part 1: Monitor Azure Resources from Uptime Cloud Monitor
. This is the second blog post in a series of 5 that will give you an overview of how to configure th...
26 Jun 2018
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 are not necessarily successful because they were well crafted, intelligently designed, or adhere to a...
20 Jun 2018
Lots more support for Azure monitoring! Part 1 of 5
Part 1: Monitor Azure Resources from Uptime Cloud Monitor As of today,
IDERA Uptime Cloud Monitor
(UCM) now supports monitoring for more Microsoft Azure services including Azure Virtual Machines, Azure MSSQL, Azure database for MySQL and Azure d...
19 Jun 2018
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 right dots with the business and its sources. According to Technopedia: "Definition - What does Da...
18 Jun 2018
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 managing permissions that allow users to use the databases. However, more than anything, they are respo...
13 Jun 2018
Announcing the GA Release of SQL Compliance Manager 5.5
We’re excited to announce the release of SQL Compliance Manager 5.5 SQL Compliance Manager is a comprehensive database auditing solution that monitors and tracks changes to SQL Server objects and data, and sends alerts on suspicious activity. ...
7 Jun 2018
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 that simplifies the management of Windows environments. It is designed primarily for system admin...
6 Jun 2018
July #SQLChat - Death of the DBA
“The DBA is dying” has been a common concept for at least 15 - 20 years. What makes this time period different? Join IDERA (
) and host Kenneth Fisher (
) on Wednesday, July 25 at 11 AM CT for a community discu...
6 Jun 2018
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 engineer databases natively with SQL Server Oracle Hive Sybase ASE Azure SQLDB and Mongo...
4 Jun 2018
Enhance Database Performance with SQL Tuning in DB Optimizer
In today's economy it is imperative that database developers work smarter, not harder, to meet the demands put on them by line of business owners, senior management, and the company as a whole. Due to time, money, and resource limitations it is often...
4 Jun 2018
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 the continued success of AquaFold and its products. As a member of our IDERA community, AquaCluster us...
31 May 2018
Using Precise for Database to Tune Tables and Indexes
When looking at a database to improve performance, I look at three types of tuning; statement, object, and instance. I want to walk you through some of the tools and features available within the Precise for Database solution that can help you identi...
29 May 2018
Creating a Data Culture Through Continuous Improvement
Industry leading organizations recognize and manage data as a strategic asset. By ensuring high data quality, they are able to rely upon data for critical decision making. Business intelligence and analytics spending has been increasing dramatically ...
28 May 2018
Databases Don't Build Themselves
Last week I was fortunate to be asked to present during the IDERA Live Event. There were many great presentations and those who attended received a lot of good information. I wanted to post a summary of
here for those that were unable...
24 May 2018
Announcing Precise 9.9 General Availability
Precise 9.9 is now generally available. This is a brand new version of Precise and heralds a change for us with the Precise AdminPoint being developed on a new UI framework. Precise 9.9 also provides support for the following: MS-Azure support Amazon...
24 May 2018
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 general indexes. Such generic parameters are likely going to lead to suboptimal performance and may even ...
23 May 2018
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 important? Angela Tidwell (
) will be leading a community discussion on soft skills for the DBA / ...
23 May 2018
What Happened to My Database?
Every DBA has at some point asked: “What the heck happened to my database?” In this blog, we’ll review some of the more common scenarios where some little detail slips through the proverbial crack and that often results in some kind...
21 May 2018
IDERA Database Tools roadmap for DBAs, database developers and data architects
At IDERA, users drive our product direction. That’s why we have been listening to your needs and have built a roadmap centered around you. In the coming year, we will be hard at work extending our most popular products to support the newest pla...
21 May 2018
Essential Alerting for Oracle, DB2, and Sybase DBAs
Precise tests availability, space, deadlocks, backups, jobs, CPU, load and performance trending plus many more conditions on a scheduled basis with defined blackout times. When there is a problem, Precise sends an email, a message, execute...
11 May 2018
Backing Up Databases in a High Availability Group
If you are a database administrator, then you are no stranger to the idea that data must be highly available. High availability simply helps ensure that business operations continue to run with as little downtime as possible. Over the years...
8 May 2018
TEMP is A Four Letter Word
It’s not uncommon to observe rampant over reliance of database application code on TEMP tables, most often as a SQL language programming crutch. I have a theory as to why. Programmers are chiefly taught record oriented or “record at a tim...
5 May 2018