Introduction to ABP Framework – a Complete Web Platform for Software Development

Uncategorized

ABP Framework is a complete infrastructure that helps developers build modern web applications...
Read More

An Overview of the SQL Variables Usage

Languages & Coding, SQL Server, Uncategorized

The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle starts with declaration and ends with...
Read More

Exploring SQL Server LEN() Function

Database development, SQL Server, Statements

SQL Server supports different data types to store relevant data in SQL tables. These data types can be integer, float, Varchar, NVARCHAR,...
Read More

How to Build a Simple Data Warehouse in Azure – Part 2

Azure, Cloud, Microsoft Azure

This is the second part of the three-part article which aims to help both beginners and...
Read More

SQL Server COUNT Function

Database development, Statements

COUNT is one of the common SQL Server Aggregate operations done by almost all SQL Server Developers for their day-to-day needs. In this...
Read More

SQL Server Configuration Manager

Database development

Introduced in SQL Server 2005, SQL Server Configuration Manager is a tool that is installed by default with SQL Server Installation to...
Read More

SQL Server Limit Results

Uncategorized

While executing SELECT queries on tables containing huge records, developers often need to limit...
Read More

Stored Procedure to Get Logins and Server Roles Inventory

Uncategorized

Security is for sure one of the most important areas that we, as professional DBAs, must cover. Within SQL Server, there are many...
Read More

User-Defined Data Types In SQL Server

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

Varchar To Date Conversions In SQL Server

SQL Server

Introduction In many scenarios, date and time information is loaded and stored in the text format....
Read More
Close