How to Downgrade SQL Database from Enterprise to Standard Edition
If you want to Restore a SQL Server 2014/2016 backup from a higher version of SQL to a lower version, i.e. from Enterprise to Standard Edition, you can do so, but before you do...
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...
SQL Server Performance Tuning with Dynamic Management Views
SQL Server Performance Tuning with Dynamic Management Views In my previous posts, I have already spoken about SQL Server Performance tuning basics, as well as the new Performance...
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,...
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...
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 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...
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....
