What Are the Risks of Paying for Ransomware?

What Are the Risks of Paying for Ransomware?

Ransomware is a particularly nasty type of malware that is being deployed with increased frequency over the past several months. In a ransomware attack, files are encrypted and held captive by criminals until a financial ransom is paid. The culprits often demand...

Why DBAs Need to Look for Trouble

Why DBAs Need to Look for Trouble

In some professions, individuals are expected to wait patiently until called upon to perform their functions. There are no opportunities for people engaged in these jobs to take any type of proactive action that will impact the activities they will need to carry out...

Making Time Using Temporal Data

Making Time Using Temporal Data

SQL is the first programming language with temporal data types. The SQL-92 standard added temporal data to the language, acknowledging most of what was already in most SQL products by that time. The problem is that each vendor made a trade-off internally. Read the...

How to Secure Your SQL Servers from Internal Threats

How to Secure Your SQL Servers from Internal Threats

The tremendous value of enterprise data resources makes them an inviting target for malicious actors. Losing sensitive financial or personal data can destroy an organization’s reputation, put customers’ information at risk, and lead to serious penalties for...

Normalization Heuristics

Normalization Heuristics

Heuristics and normalization are the goals of all databases. Heuristics refers to a trial-and-error method of problem-solving used when an algorithmic approach is impractical. Normalization refers to removing redundancy from a database schema and to have the schema...

Who Do You Trust with Your SQL Servers?

Who Do You Trust with Your SQL Servers?

Protecting enterprise data resources has never been more important. The large quantities of data that many organizations store present an inviting target to both external actors and malicious insiders. Hackers have used the COVID-19 pandemic as cover to ramp-up their...

Why is MySQL So Popular for Website Development?

Why is MySQL So Popular for Website Development?

Most websites that provide any degree of usefulness or functionality make use of one or several databases. Whether the site is designed to simply collect and display information or to enable customers to engage in eCommerce activities, a database is an essential...

Join the New Worldwide Embarcadero Community!

Join the New Worldwide Embarcadero Community!

Over on the new Embarcadero Blogs site, we are compiling a directory of Delphi & C++Builder communities around the web. We will continue to expand that list to make it easier for you to find an active and vibrant developer community to join and find answers to...

Installing Help and Samples for RAD Studio

Installing Help and Samples for RAD Studio

The Help and Samples (for both Delphi and C++) are very useful when Programming as they provide quick reference and examples of how to use different language and component features. If you are using the RAD Studio IDE and find that F1 is not opening up the help files,...

How to Monitor and Streamline SQL Server Jobs

How to Monitor and Streamline SQL Server Jobs

One of the appeals of using SQL Server as a database platform is the functionality and productivity that can be enjoyed through the use of the SQL Server Agent. Using this SQL Server facility wisely can make a big difference in the ability of database developers or...

Why You Need to Defragment Your SQL Server Indexes

Why You Need to Defragment Your SQL Server Indexes

In the quest for optimal database performance, DBAs need to leave no stone unturned. After keeping the data resources in their systems secure, there is probably no task more important than providing acceptable response time to database users. A failure to keep...

All Skewed Up

All Skewed Up

Data can be skewed by its nature. How can you tell if you have skewed data in your database? And if you do, how do you handle it when writing queries? Mitigating skewed data is hard and not obvious. There is no magic formula, just a few tricks that have to be...

Maintaining System Visibility in a Cloudburst

Maintaining System Visibility in a Cloudburst

For those readers attracted to the title of this post in the hopes of finding a new way to cope with your vehicle’s windshield wipers in a heavy downpour, please accept my apologies. We are not talking about that kind of cloudburst. We are going to focus on the...

New and Persistent Threats to Your SQL Servers

New and Persistent Threats to Your SQL Servers

It would be nice if there existed some methodology that enabled DBAs to fully protect their SQL Server environment from hackers, malware, and unauthorized access. Something like a simple script that once executed, ensured that nothing could penetrate your database...

1 19 20 21 22 23 124