Deploying Database from Source Control

Deploying Database from Source Control
4 (80%) 1 vote

These days, development teams start new projects from choosing a version control system. There are many benefits of source control systems in coordinating the efforts of the development team. It ensures a complete audit trail of all changes to the code and allows the team to reproduce any specific revision or build. Along with the programming code, databases can and should be placed under source control. In this article, we will have a look at how to deploy a database that is in the remote repository. Read More

SQL Server Database Backup Encryption

SQL Server Database Backup Encryption
3 (60%) 1 vote

To manage the data security that has been backed up by the file system as a database backup files, SQL Server provides the backup encryption feature. In this article, we will talk about encryption options available in SQL Server for database backups. We will have a closer look at the usage details, benefits, and recommended practices for encrypting SQL Server database backup during the backup process. Read More

Database Checkpoints in SQL Server

Database Checkpoints in SQL Server
Rate this post

In this article, we will talk about SQL Server Checkpoints.

To enhance performance, SQL Server applies modifications to database pages in memory. Often, this memory is called the buffer cache or buffer pool. SQL Server does not flush these pages to disk after every change. Instead, the database engine does checkpoint operation on each database from time to time. The  CHECKPOINT operation writes the dirty pages (current in-memory modified pages) and also writes details about the transaction log. Read More

SQL Server Unit Testing with tSQLt Framework

SQL Server Unit Testing with tSQLt Framework
Rate this post

In this article, we will talk about the tSQLt framework — a free database unit testing framework for Microsoft SQL Server. You can use tSQLt to create unit tests for SQL Server 2005 (service pack 2 required) and all further versions. The main convenience is that you do not need to switch between various tools to create code and unit tests. Read More

Dive Into SQL Server Transaction Log — Part 3

Dive Into SQL Server Transaction Log — Part 3
4.3 (85%) 4 votes

This is the third article in a series of articles about SQL Server transaction log. In this article, we will have a look at log record details.

Log Records

Log records are the core of the logging and recovery mechanisms. A log record describes a single change in a database. Thus, every change to a database has a log record or log records that help to describe that particular change.  Although you do not need to understand log record details, to understand what is going on with logging and recovery, those details are extremely interesting. Read More

Best FREE SQL Server Tools for Database Developers and Administrators!

Best FREE SQL Server Tools for Database Developers and Administrators!
Rate this post

This article provides a comprehensive list of the best SQL Server FREE tools for database developers and administrators! You can download the following tools and use it in your commercial projects!

Feel free to share the link with your colleagues and friends in Twitter, Facebook or any other way convenient for you! Read More

Dive Into SQL Server Transaction Log — Part 2

Dive Into SQL Server Transaction Log — Part 2
3.5 (70%) 2 votes

This is the second article in a series of articles about SQL Server transaction log file architecture. In this article, we will have a look at two SQL Server statements that allow examining transaction log details. If you would like to get an introductory information about how SQL Server transaction log works, read Dive Into SQL Server Transaction Log — Part 1 Read More