SQL

MySQL, MSSQL, T-SQL, MariaDB, Percona & more.

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
Coding / SQL

The Importance of learning SQL Programming Language Why SQL Programming Language Is Essential While Building and Developing a Database with DBMS such as MS SQL Server, PostgreSQL, MySQL, MariaDB & more

- by Ariya Stark - Leave a Comment

Programming is simply setting instructions that will help a computer perform a certain task. A programmed computer can be used to generate accurate algorithms. Over the years, computers have evolved …

The Importance of learning SQL Programming Language Why SQL Programming Language Is Essential While Building and Developing a Database with DBMS such as MS SQL Server, PostgreSQL, MySQL, MariaDB & more Read More
ASP.NET / C# / Coding / SQL

Code-First vs Model-First vs Database-First: Pros and Cons A comparison of three different ORM Data Modeling Approaches: Code-First, Model-First and Database-First

- by Ryan - 6 Comments.

When working with object-relational mapping (ORM) frameworks such as Entity Framework, we often have to choose between one of the three available approaches to model the data structure: Model-First, Database-First, and Code-First. Each one …

Code-First vs Model-First vs Database-First: Pros and Cons A comparison of three different ORM Data Modeling Approaches: Code-First, Model-First and Database-First Read More
Applications / Coding / Servers & Services / Software / SQL / Windows

MS SQL Server - How to Change the Default TCP 1433 Port The required steps to configure your Microsoft SQL Server instance to listen on a non-standard TCP/IP port

- by Ryan - 1 Comment

As you probably know, the default communication port used by SQL Server for TCP / IP mode connections is TCP 1433. This simple - but far from trivial - configuration …

MS SQL Server - How to Change the Default TCP 1433 Port The required steps to configure your Microsoft SQL Server instance to listen on a non-standard TCP/IP port Read More
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
Coding / Servers & Services / SQL

MySQL - How to find all Table Columns in all Databases with a given Collation Name - Character Set Name

- by Ryan - Leave a Comment

If you've stumbled upon this post it probably means that you're trying to normalize the Collation of your Database(s), Table(s) and/or Column(s) to avoid hitting illegal mix type errors such …

MySQL - How to find all Table Columns in all Databases with a given Collation Name - Character Set Name Read More
Coding / Software / SQL / Tools & Utilities / Web

WordPress - How to perform Search and Replace on whole Database (post, pages, wp_options) using WP plugins or MySQL tools

- by Ryan - Leave a Comment

Those who are frequently working with Worpress often find themselves operating mass-replace tasks throughout the whole WP Database. Such situation most likely arises in the following scenarios: WebSite URL change …

WordPress - How to perform Search and Replace on whole Database (post, pages, wp_options) using WP plugins or MySQL tools Read More