Tag: Database

Coding / Cyber Security / Servers & Services / Web

SQL Injection: Security Best Practices & Guidelines How to prevent SQL injection attacks and other injection-based threats targeting web applications and services

- by Ryan - Leave a Comment

Few weeks ago we wrote a post enumerating the most common Input Validation vulnerabilities in software development and how to fix them. In this article we will deal with one …

SQL Injection: Security Best Practices & Guidelines How to prevent SQL injection attacks and other injection-based threats targeting web applications and services Read More
Applications / Coding / Software / SQL / Tools & Utilities

Database Software Review: dbForge Studio for Oracle Senior Technical Analyst Nikos Minaidis reviews the main features, advantages, and drawbacks of the Studio in comparison with SQL Developer, PL/SQL Developer, TOAD, and DBeaver

- by Nikos Minaidis - Leave a Comment

dbForge Studio for Oracle is a multifunctional tool for Oracle database administration and development. Often considered one of the best, most effective database IDEs given its features, it has a …

Database Software Review: dbForge Studio for Oracle Senior Technical Analyst Nikos Minaidis reviews the main features, advantages, and drawbacks of the Studio in comparison with SQL Developer, PL/SQL Developer, TOAD, and DBeaver Read More
Cloud / Cyber Security / Privacy & Compliance / Servers & Services / Web

Securing Databases in the Cloud: 4 Best Practices If you are storing databases in the cloud, it’s less a question of if you’ll be attacked, but more of when it will happen: to minimize your liability, you need to take proactive steps to secure your databases. 

- by Gilad David Mayaan - Leave a Comment

In October 2019, Adobe faced a data breach in which around 7 million Creative Cloud accounts were compromised. The source of the breach? A database that was directly exposed to …

Securing Databases in the Cloud: 4 Best Practices If you are storing databases in the cloud, it’s less a question of if you’ll be attacked, but more of when it will happen: to minimize your liability, you need to take proactive steps to secure your databases.  Read More
Coding / SQL

SQL Server - How to ALTER one or more Table Columns avoiding a Command Timeout in T-SQL How to change the type and/or the format of one or more SQL Server Table Columns with an ALTER query avoiding command timeout and without restarting the Database

- by Ryan - Leave a Comment

If you've stumbled upon this post it most likely means that you need to change the type and/or format of one or more table column of a SQL Server using …

SQL Server - How to ALTER one or more Table Columns avoiding a Command Timeout in T-SQL How to change the type and/or the format of one or more SQL Server Table Columns with an ALTER query avoiding command timeout and without restarting the Database Read More
Coding / Servers & Services / SQL

Backup MySQL or MariaDB Server with a single Command-Line using mysqldump How to perform a full backup of a MySQL or MariaDB Server instance on a Windows or Linux machine with single command-line

- by Ryan - 1 Comment

If you like playing with MySQL or MariaDB servers, you most likely know that both of these great open-source DBMS come with mysqldump, a neat command-line utility that can be used to …

Backup MySQL or MariaDB Server with a single Command-Line using mysqldump How to perform a full backup of a MySQL or MariaDB Server instance on a Windows or Linux machine with single command-line Read More
Coding / PHP / Servers & Services / Web

WordPress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix What to do if you're randomly and repeatedly getting the "Error establishing a database connection" with your WordPress installation using MySQL or MariaDB

- by Ryan - Leave a Comment

The "Error establishing a database connection" WordPress error is a rather common one. You can either get it upon each request, meaning that you WordPress site is entirely down, or intermittently (randomly …

WordPress - Error establishing a database connection repeatedly and intermittently (MySQL / MariaDB) - Fix What to do if you're randomly and repeatedly getting the "Error establishing a database connection" with your WordPress installation using MySQL or MariaDB Read More
Applications / Servers & Services / Software

Why are Databases Critical for Small Business Companies? Hear from a Remote DBA Expert Some important reasons why your small business company needs to be fueled by strong databases for an effective growth and development.

- by Claire Williams - Leave a Comment

Running a business is a tough task as it deals with a lot of unheard and unexpected challenges that come with the day to day operation. When it comes to …

Why are Databases Critical for Small Business Companies? Hear from a Remote DBA Expert Some important reasons why your small business company needs to be fueled by strong databases for an effective growth and development. Read More