Microsoft

Featured
Internet Facing Deployments

SQL Server Licensing Internet Facing Deployments & External Connector

If you are looking for SQL Server Licensing details for Internet Facing Deployments, let us try to help you out! If you have an Internet-facing application which has an unknown...

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
SQL Server 2016 Pre-Upgrade Checklist

SQL Server 2016 Pre Upgrade Checklist and Unsupported Scenarios

Before upgrading to the newest version of SQL Server, you would ideally need to ensure that the transition is smooth. You can check out our SQL Server 2016 Pre-Upgrade Checklist...

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
Running SQL Server with Hyper-V Dynamic Memory

Best Practices for Running SQL Server with Hyper-V Dynamic Memory

Resources are scarce both in the real world as well as in the virtual world. When you are left with an overburdened virtual machine, system administrators tend to lean towards...

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
Explain How Big Should be Your Windows Server OS drive

Explain How Big Should be Your Windows Server OS drive

Question: Explain How Big Should be Your Windows Server OS drive Answer: For a clean installation of Windows Server 2012 R2, the System Requirements for Disk space is 32 GB...

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