Enterprise Tech

Featured

SQL Server Failover Clustering for High Availability

SQL Server Failover Clustering for High Availability I have already written about Database Mirroring and Log shipping in my previous posts. Both Database Mirroring and Failover...

Featured

What is SQL Server Log Shipping and How to Set it Up

SQL Server Log Shipping Logshipping in SQL provides database redundancy to multiple servers in a cost effective way since no specialized hardware or shared storage is...

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