Configuring Heterogeneous Database Replication – SQL Server to Oracle

Database administration, Database Optimization & Structure

Introduction SQL Server Replication is an SQL Server feature that allows us to transfer data from...
Read More

Azure Cosmos DB Analysis

Azure

Azure Cosmos DB is the first globally distributed, multi-model database service for building world-scale applications. Over the years, it...
Read More

Jump to Start Test-Driven Database Development (TDDD)

Database development

As a rule, we start to develop database solutions by creating database objects, such as tables, views, stored procedures, etc., based on...
Read More

Logon Triggers in SQL Server

Database development, Triggers

A logon trigger, as the name suggests, is a trigger that fires in response to a LOGON event in SQL...
Read More

How to Copy SQL Server Databases from One Instance to Another

Database administration, Database Optimization & Structure

Copying or moving databases is one of the most common tasks for data professionals who regularly deal with deploying scripts or new...
Read More

Exploring SQL Server 2016 Query Store GUI

Database development, Statements

Introduction Query store is a new feature, introduced in SQL Server 2016, that allows database administrators to historically review...
Read More

Performing Data Changes Audit Using Temporal Table

Database administration, Tables, Work with data

SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal...
Read More

Planning of Disk Space for Databases

Database administration, Memory Optimization

Do you think about something when you create a new database? I guess that most of you would say no, since we all use default parameters,...
Read More

Choosing Azure SQL Purchase Model and Service Tier

Azure, Cloud

When we are beginning to think of migrating our on-premises databases to Azure SQL, we have to decide on a proper purchase model, a service...
Read More

Configuring Azure SQL Long-term Backup Retention

Azure, Cloud

Backup is the most important case for database administration because it provides business...
Read More
Close