Docker and SQL Server on Linux
SQL Server 2017 is the biggest release and most important releases in the Microsoft product history...
Configuring Heterogeneous Database Replication – SQL Server to Oracle
Introduction SQL Server Replication is an SQL Server feature that allows us to transfer data from one instance to another for such purposes...
Azure Cosmos DB Analysis
Azure Cosmos DB is the first globally distributed, multi-model database service for building world-scale applications. Over the years, it...
Jump to Start Test-Driven Database Development (TDDD)
As a rule, we start to develop database solutions by creating database objects, such as tables,...
Logon Triggers in SQL Server
A logon trigger, as the name suggests, is a trigger that fires in response to a LOGON event in SQL Server. In simple terms, a logon trigger...
How to Copy SQL Server Databases from One Instance to Another
Copying or moving databases is one of the most common tasks for data professionals who regularly deal with deploying scripts or new...
Exploring SQL Server 2016 Query Store GUI
Introduction Query store is a new feature, introduced in SQL Server 2016, that allows database...
Performing Data Changes Audit Using Temporal Table
SQL Server 2016 has introduced a feature called ‘System versioned temporal table’. Using normal table, you can retrieve current data;...
Planning of Disk Space for Databases
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,...
Choosing Azure SQL Purchase Model and Service Tier
When we are beginning to think of migrating our on-premises databases to Azure SQL, we have to...
