SQL – Page 2 of 5

SQL Server - Reset the numeric counter (seed) of an Identity column How to reset the numeric value of the seed counter of an identity column with SQL Server 2002, 2005, 2008, 2008R2, 2012, 2016, 2017, 2019

March 25, 2019January 7, 2021 - by Ryan - Leave a Comment

If you came across this article, you probably need to reset the numeric value (seed counter) of an identity column used by a table in your SQL Server database. The …

Coding / SQL

WordPress - WP Post Views Counter plugin - import data from Yuzo Related Posts How to import the view count data of each existing post from Yuzo Related Posts to WP Post Views Counter WordPress Plugin

November 18, 2018October 19, 2020 - by Ryan - Leave a Comment

Today a friend asked me to uninstall the Yuzo Related Post plugin from her WordPress blog because she want to switch to the Jetpack built-in "related posts" feature. She could …

Coding / Servers & Services / SQL / Windows

SQL Server - Call a URL using GET or POST method and fetch Status Code and Response Text How to execute a GET or POST call to an external URL within a Stored Procedure (using HTTP or HTTPS protocol) and retrieve the StatusCode and ResponseText

November 9, 2018January 7, 2021 - by Ryan - 4 Comments.

We already talked about the MSXML2.XMLHTTP and MSXML2.ServerXMLHTTP objects in an older post: these objects provides methods and properties for server-safe HTTP access between different Web servers and can be used to exchange …

Servers & Services / SQL / Tools & Utilities / Windows

Enable DTS Designer in SQL Server Management Studio - How to How to make the DTS Designer component for SQL Server 2000 work in SQL Server Management Studio (SSMS) 2005, 2008 and above

October 28, 2018January 7, 2021 - by Ryan - 2 Comments.

Today I had to update a certain number of old Windows Server 2003 and Windows XP virtual machines to their Windows Server 2016 and Windows 10 up-to-date counterparts. Among the …

ASP.NET / C# / Coding / Servers & Services / SQL

Entity Framework Core Migrations error - Database already exists - How to fix How to fix the Database already Exists (or Table, or Relation) error that might occur when using Database.Migrate() method by conditionally calling it

September 30, 2018September 30, 2018 - by Ryan - 3 Comments.

Today I was working on my TestMakerFree Angular app, which I used as a sample app for my ASP.NET Core 2 and Angular 5 book: specifically, I was looking for a way …

Applications / Servers & Services / SQL / Windows

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 …

ASP.NET / C# / Coding / Other stuff / Servers & Services / SQL / Web / Windows

Microsoft MVP: Everything You Need to Know A list of (great) things you can actually do since the day you get the Microsoft MVP award e-mail

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

If you've stumbled upon this post, it probably means that your mailbox has been recently visited by an e-mail from Microsoft congratulating you for being awarded as a Microsoft® Most Valuable …

Coding / Linux / Servers & Services / SQL

How to safely upgrade from MariaDB 10.x to 10.3 without losing data A quick tutorial explaining how to perform a seamless upgrade from a previous version of MariaDB 10 to MariaDB 10.3 keeping all the existing databases intact

August 13, 2018March 26, 2019 - by Ryan - 6 Comments.

It has been a while since MariaDB 10.3 has been out, bringing its stunning pack of changes, improvements and new features - most notably, System-versioned tables and Sequences. If you found this …

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

August 12, 2018November 21, 2021 - 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 …