Tag: database administration

Restoring Sample DW Database AdventureWorksDW2019

14:02 Database administation

Sometimes, we need a sample database that has all the required objects along with a large set of...
Read More

Setting Up the Data Flow in Oracle Analytics

11:37 Business intelligence, Oracle BI

The traditional approach to the transformation process (Extract, Load, Transform) requires that technical users get involved directly. They...
Read More

Fundamentals of Managing Datafiles in SQL Server

20:23 Database administation, Work with data

Introduction Datafiles are physical objects that constitute the most important part of the database system since they contain actual data....
Read More

Five Different Methods To Start, Stop, And Restart SQL Server Services

16:34 Tools & technologies

When we install the SQL Server, it also installs the following services: SQL Server database engine...
Read More

3 Easy and Secure Ways to Make Users Run SSIS Packages

11:17 Business intelligence, SSIS

Have you ever come across a situation where you needed to make users run SSIS packages? This happens when the user is not comfortable with...
Read More

Configure SQL Server Log Shipping

13:22 Database administation, Transaction Log

This article explains the step by step deployment process of the SQL Server Log shipping. It is the database-level disaster recovery...
Read More

Configure SQL Jobs in SQL Server using T-SQL

10:44 Code Management, Database development, Stored Procedures, T-SQL

SQL Server Agent is a component used for the database tasks automation. For instance, we need to...
Read More

Configure Database Mirroring in SQL Server

10:37 Tools & technologies, Utilities & Extensions

Database mirroring is a SQL Server high availability solution provided by Microsoft, with the following components. Principal database...
Read More

Deploying the first SQL to Azure Migration project with Azure Database Migration Service

09:08 Azure, Cloud

Azure Database Migration Service (ADMS) supports Schema and Data migration from different database technologies to the Azure platform. This...
Read More

Introduction to Azure Database Migration Service (ADMS)

14:54 Azure, Cloud

Microsoft Azure platform provides an Azure Database Migration Service (ADMS) – a convenient...
Read More