Ryadel

SQL Server 2017 Install - Oops and Language not supported Errors - How to fix them How to overcome some typical install errors of SQL Server 2017 (and other editions) by checking the presence of previous installation files

September 28, 2018September 30, 2018 - by Ryan - 2 Comments.

If you've stumbled upon this post it most likely means you're struggling with one of the following errors that prevent you from installing SQL Server 2017. Here's the first (and …

Applications / Servers & Services / SQL / Windows

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 …

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)

July 16, 2018January 7, 2021 - 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, …

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

June 28, 2018 - 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 …

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

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. …

Applications / Coding / Software / SQL

How to copy, backup and restore one or multiple SQL Agent Jobs in SQL Server 2008-2017

December 1, 2017January 7, 2021 - by Ryan - 3 Comments.

Copying, moving, backing up and/or restore SQL Agent jobs is a common task for a SQL Server administrator: in this post we'll see how it can be done for a …

Coding / Servers & Services / SQL / Web

How to fix MSXML2.XMLHTTP and MSXML2.ServerXMLHttp Error 0x80070057 - The Parameter is Incorrect How to overcome the nasty Error 0x80070057 - The Parameter is Incorrect when executing a POST HTTP connection within a T-SQL Stored Procedure using the MSXML2.XMLHTTP or MSXML2.ServerXMLHttp object

July 8, 2017January 7, 2021 - by Ryan - 1 Comment

If you found this post it probably means that you are experiencing the following scenario: A Windows 2012 or Windows 2016 Server machine with SQL Server 2008, SQL Server 2008R2, …

ASP.NET / C# / Coding / SQL

Entity Framework Code-First: how to generate an auto-increment ID field

February 10, 2015January 8, 2021 - by Ryan - 3 Comments.

I've already covered the practical advantages of the code-first approach featured by Entity Framework 6 in a previous post: the key concept there was all about creating the whole data model starting …