Tech Posts

Featured
SQL Server Failover Cluster Checklist

SQL Server Failover Cluster Checklist

In this post, we will talk about the Pre-Installation SQL Server Failover Cluster Checklist that might be helpful for you to prepare the environment. Please note that they steps...

Featured
SQL Server 2014 Core Licensing

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
SQL Server 2014 Core Licensing

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 2014 Core Licensing

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
SQL Server 2014 Core Licensing

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 Is Faster Than Ever

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

Featured
SQL Server 2016 Is Faster Than Ever

SQL Server 2016 Business Intelligence Features

The new features of SQL Server 2016 Business Intelligence Features are more on the Reporting Services side. The integration of Datazen with SSRS 2016 and implementation of HTML...

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 Is Faster Than Ever

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 Is Faster Than Ever

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