Tag: DBMS

SQL Injection: Security Best Practices & Guidelines
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
Securing Databases in the Cloud: 4 Best Practices
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
Backup MySQL or MariaDB Server with a single Command-Line using mysqldump
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
Why are Databases Critical for Small Business Companies? Hear from a Remote DBA Expert
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
How to Migrate SQL Server DB to Azure SQL Server DB
Coding / SQL / Tools & Utilities / Windows

How to Migrate SQL Server DB to Azure SQL Server DB A detailed tutorial explaining how to migrate a SQL Server to an Azure SQL PaaS using Microsoft Data Migration Assistant (DMA)

- by Babu L Amarendra - Leave a Comment

In this article I’m going to explain how to effectively perform a SQL Server Data Migration to an Azure SQL (PaaS) instance. Since SQL Server provides various tools and features, …

How to Migrate SQL Server DB to Azure SQL Server DB A detailed tutorial explaining how to migrate a SQL Server to an Azure SQL PaaS using Microsoft Data Migration Assistant (DMA) Read More
SQL - The ntext data type cannot be selected as DISTINCT because it is not comparable - How to Fix
Coding / SQL

SQL - The ntext data type cannot be selected as DISTINCT because it is not comparable - How to Fix How to fix the "The ntext data type cannot be selected as DISTINCT because it is not comparable" error affecting MS SQL Server and other DBMS based on T-SQL

- by Ryan - Leave a Comment

If you've stumbled upon this post you're probably dealing with a SQL / T-SQL query which is either doing: a DISTINCT on a column having ntext data type. a JOIN with multiple …

SQL - The ntext data type cannot be selected as DISTINCT because it is not comparable - How to Fix How to fix the "The ntext data type cannot be selected as DISTINCT because it is not comparable" error affecting MS SQL Server and other DBMS based on T-SQL Read More