Blog

Largest Fine To Date Google recently made the news with a $57M (50M Euro) fine imposed by the French Regulatory building, CNIL. The case against Google is geared towards their use of automatically opting people into advertising programs and vague pri...

Every year, data becomes increasingly critical to the organization. And data becomes even more complicated to manage and keep secure. The growth in the diversity of the deployments of databases (such as physical, virtual, private cloud, and public cl...

Healthcare organizations must consider the essential properties of the analytics for big data that when commencing significant projects for analytics. Such features include relevance, reliability, soundness, diversity, stability, speed, and capacity....

Organizations are faced with an increasingly complex data landscape, finding themselves unable to cope with exponentially increasing data volumes, compounded by additional regulatory requirements with increased fines for non-compliance.  Enterpr...

Over the last few months, the IT Central Station team gathered reviews from IDERA ER/Studio’s customers with one goal: to find out more about their experience with this top ranked database development and management solution. As the leading sit...

Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions include support for clinical decisions, predictive analytics for big data, management of revenue cycl...

As organizations migrate their databases to the cloud, database administrators need to consistently manage databases on-premise and in the cloud with existing staff and tools. While it is relatively straightforward to provision and maintain databases...

As 2019 has just begun, it’s a good time to assess what you accomplished last year and what goals to set for the new year.  It's also a great opportunity to review, evaluate, and update your company’s Data Management Strategy to prom...

As companies migrate more and more applications and data to the cloud using services like Azure and Amazon, it is important to ensure that the SQL Server instances and databases running in the cloud are monitored to ensure that they are protected fro...

Microsoft Azure SQL Database is the relational database service offered as a Platform as a Service on the Microsoft Azure cloud. SQL Database has evolved significantly over the years and has become a robust and highly available database platform wrap...

Database professionals are often called upon to investigate performance problems related to locking, but most investigations into locking rarely go beyond checking for blocks or investigating deadlocks. It is not very often that database professional...

We are pleased to announce an updated version of IDERA SQL DM Performance Insights for Azure Data Studio. And we are excited to be announcing the inclusion of this new version in the Azure Data Studio Marketplace and to be making this announcement in...

Precise for Sybase builds a history of activity showing resource consumers.  SQL statements are correlated to stored producers, logins, and programs.  Execution sub-states and waits are measured.  The screens below show a simple e...

The executable process that is the SQL Server Database Engine is called the Database Engine service. The Database Engine service is an executable program that runs as a Windows service that can continuously operate without displaying any activity on ...

Data Warehousing DBAs usually work with huge tables, often possessing hundreds of millions or even billions of rows. And occasionally, these DBAs might need to perform maintenance that requires either recreating the entire huge table or some of its p...

“Dew knot trussed yore spell chequer two fined awl yore mistakes.” – Brendan Hills Although data modeling has been around for over 30 years, it ranks among the top areas from whence database application problems arise. Moreover, th...

Those who are watching the data management industry have definitely seen an increase in the volume of posts, whitepapers, and webinars on the topic of Data Governance. This activity is partly due to the data privacy regulations that also have receive...

As tables increase in size and more users come online, it becomes increasingly necessary to fine-tune your MySQL database server from time to time. The secret to knowing what adjustments need to be made is to perform regular monitoring. Most database...

As data professionals, we recognize and understand the need for data governance, focusing on data quality in particular. We have made some progress in this area, as illustrated by the emergence of the Chief Data Officer role in recent years. However,...

ER/Studio Data Architect contains extensive metadata for all constructs utilized in the models and data dictionaries, whether used in logical modeling, physical modeling, or both. This includes names, descriptions, comments, datatypes, lengths and a ...

There are many ways to share files or SQL statements using Aqua Data Studio.  These range from shortcuts to your own file directories or company mapped drives, to shareable Aqua files, to popular native features within the menus and toolbars.&nb...

SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important method to improve the performance of SQL queries is to use indexes properly to locate data quickly. To crea...

Today’s blog post concludes our four-part look into SQL performance and optimization. Part one introduced and explained relational optimization; part two reviewed query analysis and introduced single-table access path formulation; part three to...

Most people know that GDPR went into effect in May of 2018. For those of you who don't know, GDPR was put in place to protect people's PII (Personally Identifiable Information) Data.  This is the first holiday season with GDPR in effect, and add...

It seems like we hear about a new data breach on an almost daily basis.  This past week, we heard about two newsworthy data breaches that were caused/detected in some part by a Merger or Acquisition.  The first worth mentioning is the ...