Microsoft sql server

Featured
SQL Server Disk Configuration

SQL Server Disk Configuration SAN SSD and Partitioning Best Practices

SQL Server Disk configuration settings are one of the most important aspects of SQL Server performance tuning. Typically, disks are one of the slowest parts of the entire SQL...

Featured
Configure High Availability for SSRS

Configure High Availability for SSRS in Enterprise and Standard

When you are looking to Configure High Availability for SSRS, your options would be limited. Also, SSRS uses a custom web server and does not rely on IIS. It makes it a little...

Featured
Resolve Max Worker Threads issues in SQL Server

How to Resolve Max Worker Threads issues in SQL Server

Before we discuss performance issues related to Max Worker Threads (MWT), let’s understand what MWT does. MWT are worker threads available for SQL Server and using the...

Featured
Configure SQL Server Memory Options for Best Practices

How to Configure SQL Server Memory Options for Best Practices

SQL Server memory sizing should be planned from the beginning, in order to avoid bottlenecks later. However, in the real world, things are not so orderly. In this post, we are...

Featured

What's New in SQL Server 2016 Licensing

What’s New in SQL Server 2016 Licensing SQL Server 2016 has bought several new and improved features to the Database world, including new and improved Business Intelligence...

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

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