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....
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...
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...
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...
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...
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...
