Relational Division

Relational Division

Dr. Codd’s original relational algebra had eight basic operations. Since relational database management systems are based on set theory, the first four are traditional set operations: intersection, set difference, union, and product. These operations are...

Setting up the IDE for your First Android App

Setting up the IDE for your First Android App

I have had a growing number of customers asking recently about getting started with Android programming with Delphi, so I thought it was a good time to refresh how to check your IDE is set up, how to enable developer mode on an Android phone, and show how you can...

Secure MySQL Databases with These Best Practices

Secure MySQL Databases with These Best Practices

Organizations that make efforts to secure MySQL databases can massively mitigate the risk of suffering a data breach. The escalating number of data breaches that afflict corporate information resources shows no signs of slowing down any time soon. Your MySQL databases...

Best Practices for Securing MySQL Databases

Organizations that make efforts to secure MySQL databases can massively mitigate the risk of suffering a data breach. The escalating number of data breaches that afflict corporate information resources shows no signs of slowing down any time soon. Your MySQL databases...

The Right Tools Makes All the Difference

The Right Tools Makes All the Difference

The earliest evidence of the ancient use of tools goes back to about 2.6 million years ago. Basic stone implements were one of the driving forces behind the rise of the human race. The ability to use their intellect to use found objects in constructive ways was one of...

What are the real benefits of database automation?

What are the real benefits of database automation?

Many of the administrative tasks required to keep databases operating efficiently need to be performed regularly. While in some respects, these activities can become routine and mundane for the administrative team, they are nevertheless vital for the organization and...

SQL Server Tuning Tips You Need to Know

SQL Server Tuning Tips You Need to Know

Tuning their systems for optimal performance is one of the main responsibilities of database administrators. It can often be a difficult task to find the right ways to satisfy the user demands put on their SQL Servers. Numerous moving parts can be tweaked in an...

Best Practices for a Successful Data Migration

Best Practices for a Successful Data Migration

Data migration is defined as the process of transporting data between computer systems, storage devices, or formats. While it is usually not part of a DBA’s daily routine, data migrations are one of those types of activities that most database teams are called...

Surviving the Damages of a Data Breach

Surviving the Damages of a Data Breach

Just about the last thing that any IT organization wants to experience is a data breach. The ramifications of misappropriated data can be severe and long-lasting to both the organization and individuals affected. You might get an argument from some observers who say a...

Is your organization ready for the Internet of Things (IoT)?

Is your organization ready for the Internet of Things (IoT)?

The Internet of Things (IoT) is the term used to describe the connection of network-capable devices to the Internet and other connected devices. The equipment that makes up the IoT go far beyond the computers that were connected to form the consumer Internet. IoT...

Welcome to the Modern Precise

Welcome to the Modern Precise

Welcome to the modern Precise UI. Precise is now available on all modern browsers such as Chrome and Firefox and can even be launched on tablets too. The new UI is faster and slicker and avoids the need to have Flash and ActiveX in your environments. Precise has been...

A Whole New Embarcadero Blogging Platform

A Whole New Embarcadero Blogging Platform

As mentioned in Atanas' August 2020 GM Update, Embarcadero is moving off of the Idera community platform to a whole new Embarcadero only blogging platform. We are migrating all the existing blog posts there, so no content will be lost (famous last words I know). We...

IDERA Newsletter August 2020 (Database Administrator edition)

IDERA Newsletter August 2020 (Database Administrator edition)

  Product Release SQL Diagnostic Manager for SQL Server 10.6 We are delighted to announce that the latest release of SQL Diagnostic Manager is now available. What's New: Improved user interface, including intuitive range control Multiple instance navigation...

1 20 21 22 23 24 124