Uncategorized

Visual Studio vs JetBrains Rider: A Detailed Comparison

15:59 Uncategorized

Microsoft’s Visual Studio has been in use for over two decades. It is the default integrated...
Read More

Getting Started with SQL Server

00:23 Uncategorized • One Comment

This documentation section presents the topics on SQL Server
Read More

XML Made Easy – LINQ to XML

10:35 ASP .NET CORE, Languages & Coding, Uncategorized

LINQ to XML is an in-memory XML programming interface that enables XML manipulation. Similar to the more traditional Document Object Model...
Read More

Customer Segmentation with Data Flow in Oracle Analytics

16:48 Business intelligence, Oracle BI, Uncategorized

Customer Segmentation Analysis is a popular business issue, especially in Retail domain, where...
Read More

Git Branching Naming Convention: Best Practices

15:02 Database administation, Database Optimization & Structure, Uncategorized

Git offers flexible branching strategies, but what does it mean? In simple words, a branching strategy is a set of rules, a convention that...
Read More

How to Configure Database Mail in SQL Server

13:59 Database administation, Database Optimization & Structure, Uncategorized

INTRODUCTION Notifications are usual in most modern systems. SQL Server implemented means of sending notifications by email early with the...
Read More

Restoring the SQL Server Master Database

14:59 Database administation, Database Optimization & Structure, Uncategorized

INTRODUCTION The master database contains records of the structure/configuration for both the...
Read More

SQL Server System Databases – Basic Concepts

14:44 Database administation, Database Optimization & Structure, Uncategorized

Introduction The SQL Server design implies a one-to-many mapping between the database engine (instance) and the databases hosted on the...
Read More

How To Migrate SQL Server Jobs From One SQL Server Instance To Another

10:43 Database administation, Database Optimization & Structure, Uncategorized

Introduction In a previous article, we highlighted that the msdb database stores practically all objects related to automation. In this...
Read More
Close