Ryadel

How to Install, Setup and Configure MS SQL Server 2017 Express Edition A quick tutorial explaining all the required steps to deploy an instance of MS SQL Server 2017 Express Edition on a Development, Testing or Production machine

August 17, 2018January 7, 2021 - by Ryan - Leave a Comment

If you're a .NET developer working with Visual Studio, you'll most likely know SQL Server LocalDB: a specialized edition of the well-known Microsoft SQL Server engine - firstly introduced in …

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

May 12, 2018 - 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 …

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

March 20, 2018January 7, 2021 - 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 …

Coding / SQL

LIKE operator equivalent for integer / numeric value Columns in a SQL (or T-SQL) Database

February 16, 2018April 20, 2018 - by Ryan - 1 Comment

Those who've stumbled upon this post are probably looking for a way to perform a LIKE statement on a numeric value column in a MySQL, MariaDB or SQL Server Database. …