Database administation

SQL Server In-Memory OLTP: The Basics

13:14 Database administation, Memory Optimization

This is the first article in a series of articles about In-Memory OLTP. It helps you to understand...
Read More

Query Performance Insight: Discovering What Consumes Resources of Your Azure SQL Database?

13:29 Azure, Cloud, Database administation, Perfomance Tuning

In this post, I’d like to take a brief look at the Query Performance Insight — SQL Azure tool which will help you to identify the most...
Read More

SQL Server Database Backup Encryption

15:55 Database administation, Security

To manage the data security that has been backed up by the file system as a database backup files, SQL Server provides the backup...
Read More

In-Memory OLTP: What’s new in SQL Server 2016

07:49 Database administation, Memory Optimization

SQL Server development team has added new features to In-Memory OLTP. All these features allow you...
Read More

SQL Server Transaction Log — Part 2

17:05 Database administation, Transaction Log

This is the second article in the series dedicated to SQL Server transaction log and its specificities. Here we are going to examine the...
Read More

SQL Server Transaction Log — Part 1

16:08 Database administation, Transaction Log • One Comment

Every SQL Server database contains one or more transaction log files in addition to data files. Log files record all transactions and...
Read More