Featured

SQL Server Database Mirroring

SQL Server Database Mirroring SQL Server Database Mirroring is still the most popular way to replicate SQL Server across sites over a LAN or a WAN connection in near-realtime....

Featured

Introduction to SQL Server High Availability

This post is about the introduction to SQL Server high availability. Here we would be talking about the various replication options available in SQL Server using which you can...

Featured

SQL Server 2016 Cloud Integration

SQL Server 2016 Cloud Integration SQL Server 2016 integration with Microsoft’s own Azure Service is essential these days. SQL Server 2016 introduces Simplicity with new...

SQL Server 2016 Always On Enhancements

SQL Server 2016 Always On Enhancements I have already spoken about SQL 2016 Performance features and Security features. SQL Server Always On was first introduced in 2012...

Featured

SQL Server 2016 : Security Features

The last couple of SQL Server releases were about Cloud Integration and Hybrid deployments. The current SQL Server release has closed the gap between the features offered on the...

Featured

SQL Server 2016 New Performance Features

SQL Server 2016 New Performance Features I have already written about SQL Internals improvements on a different post. With SQL Server 2016, Microsoft has continued to invest in...

SQL Server Performance Tuning in a Virtual Environment

SQL Server Performance Tuning in a Virtual Environment I have already spoken about SQL Server monitoring, SQL I/O best practices, and general SQL performance best practices. In...

Featured

SQL Server Performance I/O Characteristics

SQL Server Performance I/O Characteristics : SQL Server has different IOPS characteristics and it is difficult to generalize IO patterns of SQL Server. SQL is a back-end platform...