How To
Create a New Oracle User and Grant Privileges: Syntax and Examples
In this article, we will talk about how to create a user in Oracle. You will learn how to add new database users, figure...
How to Move Your Scripts Folders to Azure Files and Keep Them Up-to-Date
The article presents a detailed step-by-step walkthrough on how to move a database scripts folder to the Azure Files storage and keep it up-to-date...
PostgreSQL Indexes: An In-Depth Guide
All relational database management systems, including PostgreSQL, provide specialized means and techniques to get the necessary information quickly and accurately. These means include indexes...
SQL Delete Statement: Remove One or Multiple Rows From a Table
The article is dedicated to the SQL Server DELETE statement. Here you will find detailed information about how to use the query in order...
The Ultimate Comparison of ADO.NET and Entity Framework
When developers start working on any applications (for both web or desktop versions), they spend a long time worrying about the backend database, its...
How to Build a Job to Import Multiple CSV files into a SQL Server Database
Have you ever faced the necessity to load data from multiple CSV files into multiple database tables? Not so uncommon, right? In this article,...
SSIS Execute Process Task Tutorial with Examples
What's the big deal with SSIS Execute Process Task?
Among the many SSIS components, Data Flow and SQL tasks are enough for simple tasks. Using SSIS...
Cross-Compiling in Lazarus on Linux Using UniDAC as an Example
The topic of cross-compiling projects in Lazarus on Linux systems has been repeatedly raised by our users. Therefore, in this article, we want to...
SQL Insert Statement to Insert New Rows of Data Into a Table
In this article, we are going to talk about the SQL INSERT statement and how to use it in order to insert new rows...
How to Connect to SQL Server Using SSMS, sqlcmd Utility, and dbForge Studio for SQL Server
In the article, we are going to provide a step-by-step guide on how to connect to SQL Server and execute SQL queries using the...
