Database Optimization & Structure

SSDT (SQL Server Data Tools) for Visual Studio: Main Features

Database administation, Database Optimization & Structure

SQL Server provides SQL Server developers and administrators with dedicated client tools for...
Read More

Different Ways to Populate the Users of MySQL

Database administation, Database Optimization & Structure

This article explains different methods to populate the details of the Users in MySQL. We can view the list of users by using any of the...
Read More

SQL Server User-defined Functions

Database administation, Database Optimization & Structure

User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many...
Read More

SQL Server System Databases – Restore System Databases

Database administation, Database Optimization & Structure

In the previous articles of the SQL Server System Databases series, we have learnt the purpose of...
Read More

SQL Server System Databases – MSDB Maintenance

Database administation, Database Optimization & Structure, SQL Server

In the previous articles of the SQL Server System Databases series, we have gone through the System Databases that are installed by default...
Read More

SQL Server System Databases – the Tempdb Maintenance

Database administation, Database Optimization & Structure

In my previous article about SQL Server System Databases, we learned about each system database that comes as part of SQL Server...
Read More

SQL Server System Databases Maintenance

Database administation, Database Optimization & Structure

SQL Server Installation by default creates several system databases per instance to maintain and...
Read More

How to Get SQL Server Statistics Information Using System Statistical Functions

Database administation, Database development, Database Optimization & Structure, Stored Procedures

Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
Read More

Git Branching Naming Convention: Best Practices

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

Database administation, Database Optimization & Structure, Uncategorized

INTRODUCTION Notifications are usual in most modern systems. SQL Server implemented means of...
Read More
Close