SQL Server

Featured
SQL Server 2019 System Requirements - Hardware & Software Prereqs

SQL Server 2019 System Requirements – Hardware & Software Prereqs

In this article, we will be sharing the SQL Server 2019 System Requirements based on the current release from Microsoft. The 2019 edition is going to be a significant release for...

Featured
T-SQL Performance Tuning on Bulk Load Data in SQL Server 2017

T-SQL Performance Tuning on Bulk Load Data in SQL Server 2017

In this article, we are going to talk about a specific scenario where T-SQL Performance Tuning is required for bulk load operations. This scenario aims to improve SQL Performance...

Featured
Fix Index Fragmentation on SQL Server

How To Check & Fix Index Fragmentation on SQL Server via Script & ssms

Before we learn to fix Index fragmentation on SQL Server, let us understand why this happens. Indexes can be fragmented primarily due to data modifications over shorter or longer...

Featured
PowerBI DAX Reference

PowerBI DAX Reference – Link To A Complete End to End Guide

While working on a PowerBI report development, I found this article which is a very useful reference for Data Analysis Expressions (DAX) Functions. The MSDN links are also added...

Featured
Fixing SQL Server Max Worker Threads

Fixing SQL Server Max Worker Threads: error: 35217, severity: 16, state: 1

If you try fixing SQL Server Max Worker Threads for errors such as: “The thread pool for AlwaysOn Availability Groups was unable to start a new worker thread.” then we...

Featured
GPU Offloading in SQL Server 2017

How To Do GPU Offloading in SQL Server 2017 For Parallelism

The idea of having GPU Offloading in SQL Server 2017 is quite attractive. It might be the key to all your performance woes in SQL Server. However, it is not the case. GPU...

Featured
Unable to create databases in SQL Server Management Studio 2016

Unable to create databases in SQL Server Management Studio 2016 For Dynamic 365

While working on the “Bring Your Own Database to Azure” functionality in Microsoft Dynamics 365 for Finance and Operations, Enterprise Editions/Microsoft Dynamics 365...

Featured
Exporting SSRS Key to Azure Key Vault

Exporting SSRS Key to Azure Key Vault for Scale-Out Deployments

You will have to agree that managing so many encryption keys for SQL Server could be a tedious job. With Azure Storage Value, storing and distributing keys is even more...

Featured
BYOL SQL License to Existing Azure VM

How to Apply BYOL SQL License to Existing Azure VM on Cloud IAAS

In case if you are looking to apply BYOL SQL License to Existing Azure VM, then this post is for you. If you or your customer have an Enterprise Agreement or Software Assurance...

Featured
PowerBI Trace File FlightRecorderCurrent.trc

PowerBI Trace File FlightRecorderCurrent.trc: Where and How to Find it

Learn how and where you can find out the PowerBI Trace File FlightRecorderCurrent.trc for debugging and troubleshooting. PowerBI Trace File FlightRecorderCurrent.trc PowerBI...