Tag: SQL Server

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
The Importance of learning SQL Programming Language
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
SQL Server - Recuperare il Product Key da una installazione esistente
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
SQL Server - Recuperare il Product Key da una installazione esistente
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

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

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 Read More