SQL

Featured

How to Run Failover Clustering FCI in Azure Virtual Machines IAAS

How to Run Failover Clustering FCI in Azure Virtual Machines IAAS Till recently, SQL Server Always On Availability Groups were the only Cluster based High Availability option...

Featured

How to Resolve SQL Locking issues in Microsoft Dynamics CRM

How to Resolve SQL Locking issues in Microsoft Dynamics CRM SQL Server Blocking refers to the situation where one connection blocks another, even though they come from the same...

Featured

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

Featured

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

Featured
How to find SQL Server Product Key

How to Find SQL Server Product Key

When you install SQL Server, you would be prompted to enter a product key to install the correct Edition of SQL Server (2016, Enterprise, Standard, etc.). You will not find the...

Featured
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 features in SQL Server 2016. Dynamic Management Views was...

Featured

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

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