Database Optimization & Structure

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

Database administration, Database Optimization & Structure

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

MySQL SHOW USERS: How to List All Users in a MySQL

Database administration, Database Optimization & Structure, MySQL

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

User-Defined Functions in SQL Server

Database administration, Database Optimization & Structure, SQL Server, Statements

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 administration, Database Optimization & Structure

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

MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management

Database administration, 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

TempDB Full? How to Shrink and Maintain Your SQL Server’s Temporary Database

Database administration, 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 administration, 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 administration, 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

Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage

Cloud, Database administration, Database Optimization & Structure

Let’s imagine you have a large raw file and need to determine the best way to load it into an Oracle Autonomous Data Warehouse...
Read More

Git Branching Naming Convention: Best Practices

Database administration, Database Optimization & Structure

Git offers flexible branching strategies, but what does it mean? In simple words, a branching...
Read More
Close