An Overview of the SQL Variables Usage
The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle...
Exploring SQL Server LEN() Function
SQL Server supports different data types to store relevant data in SQL tables. These data types can be integer, float, Varchar, NVARCHAR,...
How to Build a Simple Data Warehouse in Azure – Part 2
This is the second part of the three-part article which aims to help both beginners and professionals in designing a simple but fully...
SQL Server COUNT Function
COUNT is one of the common SQL Server Aggregate operations done by almost all SQL Server Developers...
SQL Server Configuration Manager
Introduced in SQL Server 2005, SQL Server Configuration Manager is a tool that is installed by default with SQL Server Installation to...
SQL Server Limit Results
While executing SELECT queries on tables containing huge records, developers often need to limit the number of records being fetched out to...
Stored Procedure to Get Logins and Server Roles Inventory
Security is for sure one of the most important areas that we, as professional DBAs, must cover....
User-Defined Data Types In SQL Server
Introduction SQL Server platform comes with many data types, but there are cases when they are not sufficient. Or, custom data types could...
Varchar To Date Conversions In SQL Server
Introduction In many scenarios, date and time information is loaded and stored in the text format. Converting these values to the date/time...
How to Change Default MySQL Port in Windows 10
A network port is a communication endpoint used by applications, incoming connections, and external...