Guide for CTE in SQL Server
The Common Table Expression aka CTE in SQL Server provides a temporary result set in T-SQL. You can...
Introduction to Amazon QuickSight
Nowadays, companies are moving their infrastructure from on-premise devices to the cloud. There are a few major cloud vendors like AWS,...
TempDB Full? How to Shrink and Maintain Your SQL Server’s Temporary Database
In my previous article about SQL Server System Databases, we learned about each system database that comes as part of SQL Server...
How to Setup SQL Server on the Amazon RDS
SQL Server is one of the most popular databases used in modern applications. Over the past few...
JSON in SQL Server: The Ultimate Guide to JSON Data Manipulation
In the last few years, JSON has positioned itself as a standard data exchange format between services, although XML is still widely used....
How to SHOW or LIST Tables in MySQL
There are two primary methods to view the tables in MySQL: In this article, we are going to explore them both....
ENUM (Enumeration) Data Type in MySQL: Top 12 Facts and Useful Tips
MySQL ENUM data is a string data type with a value chosen from the list of permitted values. You...
LINQ to XML: Easy Work in C#
LINQ to XML is an in-memory XML programming interface that enables XML manipulation. Similar to the more traditional Document Object Model...
How to Use a ROUND Function in SQL Server
The ROUND function in SQL Server is a powerful tool that allows you to round numeric values to a specific number of decimal places. This...
Oracle Data Integrator: A Tutorial Guide to Get Google’s Financial Service Data
RESTful API is a popular protocol for exchanging data between different applications and systems...
