Tech Posts

Featured
Power Map Samples for Excel 2013 and 2016

Power Map Samples for Excel 2013 and 2016

Power Map Samples for Excel 2013 and 2016 Microsoft Power Map is an Excel based Add-In which provides a three-dimensional (3-D) data visualization tool that allows you to do...

Featured
SQL Server 2014 Core Licensing

Direct Links To Download SQL Server Sample Databases

Introduction to SQL Server Sample Databases To get started with Microsoft SQL Server for demonstrations & training you need some sample databases to play with. There are many...

Featured

Introduction to Azure SQL Data Warehouse

Introduction to Azure SQL Data Warehouse Azure SQL Data Warehouse is an an elastic data warehouse as a service with enterprise-class features with distributed database...

Featured
SQL Server 2016 Is Faster Than Ever

Why is SQL Server 2016 Faster Than Ever

SQL Server 2016 is designed to work faster than any earlier version of SQL Server. There was a set of tweaking that was earlier required to be a manual process. At the same time,...

Featured
SQL Server Performance Tuning

SQL Server Diagnostics Best Practices

SQL Server Diagnostics Best Practices I have already spoken about Free SQL Server tools for analysing SQL Server performance in a previous post. In this post, I am going to talk...

Featured

Best Practices for Configuring SQL on Azure IaaS VM

Best Practices for Configuring SQL on Azure IaaS VM Running SQL Server workloads on Azure as IAAS (Infrastructure as a service) is becoming popular. With more SQL Servers running...

Featured

Comparing SQL Server in Azure IAAS VM with Azure SQL Database

Comparing SQL Server in Azure IAAS VM with Azure SQL Database There has been quite a lot of discussion about how Azure SQL Database PAAS Service compares with running SQL Server...

SQL Server Always On Availability Groups

SQL Server Always On Availability Groups I have already spoken about other high availability technologies like Log-Shipping, Database Mirroring, and Failover Clustering. I also...

Featured
SQL Server 2014 Core Licensing

SQL Server Hybrid Approaches for High Availability

SQL Server Hybrid Approaches for High Availability SQL Server High Availability technologies already gives you a lot of flexibility to fit diverse deployment typologies....