sql

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 in order to install the correct Edition of SQL Server (2016, Enterprise, Standard etc.). You will not...

Featured
Azure SQL Database Performance Tuning

Azure SQL Database Performance Tuning

Azure SQL Database Performance Tuning is an important topic even if the database does not need a dedicated DBA to manage and maintain. There are several automatic optimization...

Featured
Best Practices for SQL on Azure VM

Performance Tuning Best Practices for SQL on Azure VM

In this post, I am going to talk about Performance Tuning Best Practices for SQL running on an Azure VM with key considerations. Understand the characteristics of running SQL...

Featured

How to Migrate SQL Server to Cloud for BI Workloads

How to Migrate SQL Server to Cloud for BI Workloads you ask? The short answer to this is “It Depends“. On a broader level, there are primarily three different ways...

Featured
SQL Server Performance Tuning

SQL Server Performance Tuning

SQL Server Performance Tuning SQL Server Performance tuning is a big topic and sometimes it becomes difficult to decipher the problem. So, in this blog topic, I am going to talk...

Featured
SQL Server 2014 Core Licensing

SQL Server 2014 Licensing

SQL Server 2014 Licensing has become complex over the years, especially when Microsoft decided to move from CPU Socket based licensing to CPU Core based Licensing with SQL 2012...