Blog

Howdy! I am back with another exciting blog post on setting up our ER/Studio Repository in the Oracle Cloud. Let us walk through the process. Prerequisites Get a Oracle Cloud account. You can sign up for a Free Trial here https://myservices.u...

In 1961, Professor John McCarthy was the first to publicly suggest in a speech at the centennial celebration of the Massachusetts Institute of Technology that: “Computing may someday be organized as a public utility just as the telephone system...

Precise AdminPoint is available as a browser agnostic interface.  Open Precise in Chrome!, Firefox!.  Precise Applications will be available in HTML5 in version 10.  Sencha EXT JS is being used to rebuild Precise.  It is a remarka...

On behalf of the entire Aqua Data Studio team, we’re excited to announce the release of Aqua Data Studio version 19.5 with major Enhancements in the following areas. Platform Additions and Updates We have extended our Platform Support to includ...

SQL Diagnostic Manager 10.4 will be available soon and it currently available for our beta customers at https://community.idera.com/database-tools/database-management/beta What’s Coming in Diagnostic Manager 10.4? This release includes several ...

The cloud delivers information technology as a service on demand, allowing users only to consume the capacity they need. The cloud is the infrastructure that the services run on. The cloud is a computing solution that provides shared resources over t...

Healthcare organizations need methods to overcome challenges to achieve the data-driven financial and clinical objectives. Such approaches include ingesting, ***, storing, protecting, governing, maintaining, and accessing the data, then making it use...

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