An Overview of the SQL Variables Usage
The SQL variable is a local variable that can store a single data value temporarily. Its lifecycle...
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. Within SQL Server, there are many...
Automation of Database Maintenance in SQL Server 2019 Express Edition
This article explains how to automate the database maintenance tasks in SQL Server Express Edition....
Visual Studio vs JetBrains Rider: A Detailed Comparison
Microsoft’s Visual Studio has been in use for over two decades. It is the default integrated development environment (IDE) for building,...
Getting Started with SQL Server
This documentation section presents the topics on SQL Server
XML Made Easy – LINQ to XML
LINQ to XML is an in-memory XML programming interface that enables XML manipulation. Similar to the...
Customer Segmentation with Data Flow in Oracle Analytics
Customer Segmentation Analysis is a popular business issue, especially in Retail domain, where companies need to discover the data and...
Git Branching Naming Convention: Best Practices
Git offers flexible branching strategies, but what does it mean? In simple words, a branching strategy is a set of rules, a convention that...
How to Configure Database Mail in SQL Server
INTRODUCTION Notifications are usual in most modern systems. SQL Server implemented means of...