SSDT (SQL Server Data Tools) for Visual Studio: Main Features
SQL Server provides SQL Server developers and administrators with dedicated client tools for...
MySQL SHOW USERS: How to List All Users in a 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...
User-Defined Functions in SQL Server
User-defined functions in SQL Server (UDFs) are key objects that each developer should be aware of. Although they are very useful in many...
SQL Server System Databases – Restore System Databases
In the previous articles of the SQL Server System Databases series, we have learnt the purpose of...
MSDB Maintenance: Your Ultimate Guide to SQL Server System Database Management
In the previous articles of the SQL Server System Databases series, we have gone through the System Databases that are installed by default...
TempDB Full? How to Shrink and Maintain Your SQL Server’s Temporary Database
In my previous article about SQL Server System Databases, we learned about each system database that comes as part of SQL Server...
SQL Server System Databases Maintenance
SQL Server Installation by default creates several system databases per instance to maintain and...
How to Get SQL Server Statistics Information Using System Statistical Functions
Often, we need to gather system statistics regarding running SQL Server Instances, such as the number of total connections attempted to SQL...
Import Data into Oracle Autonomous Data Warehouse using Oracle Object Storage
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...
Git Branching Naming Convention: Best Practices
Git offers flexible branching strategies, but what does it mean? In simple words, a branching...
