List of SQL Server Versions Build Numbers and Service Packs
List of SQL Server Versions Build Numbers and Service Packs: In this post, we have an Unofficial complied list of all known SQL Server Releases with additional metadata like file...
How to Find SQL Server Product Key
When you install SQL Server, you would be prompted to enter a product key in order to install the correct Edition of SQL Server (2016, Enterprise, Standard etc.). You will not...
Performance Tuning Best Practices for SQL on Azure VM
In this post, I am going to talk about Performance Tuning Best Practices for SQL running on an Azure VM with key considerations. Understand the characteristics of running SQL...
Why Upgrade to SharePoint 2016 BI Features
Why Upgrade to SharePoint 2016 BI Features In SharePoint 2016, Excel Online is the only service that can load workbooks with embedded data models. Other service application such...
BI Features in SharePoint 2016 On Premises
BI Features in SharePoint 2016 On Premises The BI features in SharePoint 2016 on premises have been unified, enhanced and more scalable. Unlike in SharePoint 2013, where you had...
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...
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,...
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...
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....
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...
