SQL

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

ASP.NET / C# / Cloud / Coding / Design / Servers & Services / SQL / Web

ASP.NET Core Web API - The Book A practical guide explaining how to create fully featured Web APIs with the ASP.NET Core framework using REST and GraphQL - Now available for Early Access!

- by Ryan - Leave a Comment

Today I'm proud to announce that my future book - ASP.NET Core Web API, which I'm currently writing for Manning Publications - has just reached the MEAP state! In case you …

ASP.NET Core Web API - The Book A practical guide explaining how to create fully featured Web APIs with the ASP.NET Core framework using REST and GraphQL - Now available for Early Access! Read More
Applications / Coding / Software / SQL / Tools & Utilities

Database Software Review: dbForge Studio for Oracle Senior Technical Analyst Nikos Minaidis reviews the main features, advantages, and drawbacks of the Studio in comparison with SQL Developer, PL/SQL Developer, TOAD, and DBeaver

- by Nikos Minaidis - Leave a Comment

dbForge Studio for Oracle is a multifunctional tool for Oracle database administration and development. Often considered one of the best, most effective database IDEs given its features, it has a …

Database Software Review: dbForge Studio for Oracle Senior Technical Analyst Nikos Minaidis reviews the main features, advantages, and drawbacks of the Studio in comparison with SQL Developer, PL/SQL Developer, TOAD, and DBeaver Read More
ASP.NET / C# / Cloud / Coding / Cyber Security / HTML & CSS / JavaScript / Servers & Services / Software / SQL / Web

ASP.NET Core 5 and Angular Fourth Edition - What's new? A brief interview with the author to shed some light on the new contents of the best-selling ASP.NET Core and Angular book series fourth edition, featuring ASP.NET Core 5 and Angular 11

- by Ryan - Leave a Comment

The ASP.NET Core and Angular series of titles have established themselves as a popular choice for learning full-stack development. This new edition is an in-depth guide completely rewritten to cover …

ASP.NET Core 5 and Angular Fourth Edition - What's new? A brief interview with the author to shed some light on the new contents of the best-selling ASP.NET Core and Angular book series fourth edition, featuring ASP.NET Core 5 and Angular 11 Read More
Cloud / Servers & Services / SQL / Web

How to create an Azure SQL Managed Instance How to setup and configure a SQL Managed Instance on the Azure Cloud Portal: a great way to create, host and mantain SQL Databases in the cloud

- by Ryan - 2 Comments.

Providing ourselves with a SQL Managed Instance on the Azure Cloud Portal can be a great way to create, host and mantain SQL Databases in the cloud. As we most …

How to create an Azure SQL Managed Instance How to setup and configure a SQL Managed Instance on the Azure Cloud Portal: a great way to create, host and mantain SQL Databases in the cloud Read More
ASP.NET / C# / Coding / SQL / Web

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider

- by Ryan - Leave a Comment

In this article we'll see how to take advantage of Serilog, a neat open-source diagnostic logging library for .NET applications, to log our ASP.NET Core web application’s data to a …

ASP.NET Core SQL Server and MySQL database logging with Serilog How to use the ASP.NET Core's built-in ILogger logging API to write application logs to SQL Server, MySQL and/or MariaDB using Serilog logging provider Read More
SQL

3 Types of SQL server deadlocks and how to prevent them A small yet useful guide to identify the three most common causes of SQL deadlocks and what to do to prevent and/or avoid them

- by Alice - Leave a Comment

Identifying and dealing with SQL server deadlocks is all part and parcel of what a DBA has to handle as part of their role. Of course if you are a …

3 Types of SQL server deadlocks and how to prevent them A small yet useful guide to identify the three most common causes of SQL deadlocks and what to do to prevent and/or avoid them Read More
ASP.NET / C# / Cloud / Coding / JavaScript / SQL / Web

ASP.NET Core 3 and Angular 9 - Third Edition The new edition of the best-selling full-stack web development with ASP.NET Core 3.1 and Angular 9 book is finally out!

- by Ryan - Leave a Comment

I'm happy to announce that the ASP.NET Core 3 and Angular 9 book is finally available for purchase – in E-Book and Paperback format – on all the major online …

ASP.NET Core 3 and Angular 9 - Third Edition The new edition of the best-selling full-stack web development with ASP.NET Core 3.1 and Angular 9 book is finally out! Read More
Coding / SQL / Web

WordPress: SQL query to add or remove categories on multiple posts A set of useful MySQL queries to perform bulk operations against the WordPress Database such as adding and/or removing categories on multiple posts

- by Ryan - 7 Comments.

In this article I will try to explain how to perform a series of operations on the WordPress categories associated with articles using SQL queries that act directly on the …

WordPress: SQL query to add or remove categories on multiple posts A set of useful MySQL queries to perform bulk operations against the WordPress Database such as adding and/or removing categories on multiple posts Read More
ASP.NET / C# / Coding / JavaScript / Spam and Scam Alert / SQL / Web

My new Angular book is not out yet, but is already a scam ASP.NET Core 3 and Angular 9 book won't be available until February 11th, but you can already get robbed while trying to download it

- by Ryan - Leave a Comment

Writing a programming book is a task that almost always proves to be much more difficult than expected, especially when dealing with mutable and unpredictable frameworks such as ASP.NET Core …

My new Angular book is not out yet, but is already a scam ASP.NET Core 3 and Angular 9 book won't be available until February 11th, but you can already get robbed while trying to download it Read More
Coding / SQL

SQL Server - How to ALTER one or more Table Columns avoiding a Command Timeout in T-SQL How to change the type and/or the format of one or more SQL Server Table Columns with an ALTER query avoiding command timeout and without restarting the Database

- by Ryan - Leave a Comment

If you've stumbled upon this post it most likely means that you need to change the type and/or format of one or more table column of a SQL Server using …

SQL Server - How to ALTER one or more Table Columns avoiding a Command Timeout in T-SQL How to change the type and/or the format of one or more SQL Server Table Columns with an ALTER query avoiding command timeout and without restarting the Database Read More