Following are the most common types of backups available in SQL Server: Full, Differential, Transaction log and Tail Log backup.| SQL Shack - articles about database auditing, server performance, data recove...
This article explores the SQL Server Transaction log backup and log sequence number ( LSN) chain in combination with the Full backup| SQL Shack - articles about database auditing, server performance, data recove...
This article is the second part where we will show you some SQL interview questions on database backups, restores and recovery.| SQL Shack - articles about database auditing, server performance, data recove...
This article is the first part where we will show you some SQL interview questions on database backups, restores and recovery.| SQL Shack - articles about database auditing, server performance, data recove...
This article will be first article of series for SQL database backup and restoration using DBAtools, a open source library of PowerShell automation scripts.| SQL Shack - articles about database auditing, server performance, data recove...
This article will show how to use replication to improve the ETL performance in SQL Server environment.| SQL Shack - articles about database auditing, server performance, data recove...
This article will describe how to test Type 2 Slowly Changing Dimensions.| SQL Shack - articles about database auditing, server performance, data recove...
This article is to explain how to perform ETL using database snapshots and how to utilize database snapshots to perform incremental data extraction from an operational database to a data warehouse. Introduction As you are aware, ETL (Extract-Transform-Load) operations are one of the most challenging tasks in data warehousing due to many reasons. In the […]| SQL Shack - articles about database auditing, server performance, data recove...
Dinesh Asanka| SQL Shack - articles about database auditing, server performance, data recove...