IG

Featured
Power BI Service Desktop & Embedded Interview Questions and Answers

Power BI Service Desktop & Embedded Interview Questions and Answers

In this post, we are going to post about Power BI Service Desktop & Embedded Interview Questions and Answers. As per Gartner’s magic quadrant report, Microsoft is one of...

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
System Center Deployment Requirements and Restrictions for SQL Server

System Center Deployment Requirements and Restrictions for SQL Server

System Center contains a suite of products for Enterprises which enables them to deploy and manage Windows (Wintel) datacenter environments. The suite of upper growth include the...

Featured
How To License Your SQL Server on Google Cloud

How To License Your SQL Server on Google Cloud

In my previous post, we deployed SQL Server 2016 on a Windows Server 2012 R2 Operating system on Google Cloud. When you use the SQL Server Public Images, SQL Server and Windows...

Featured
Run Microsoft SQL Server 2016 on Google Cloud

How to Run Microsoft SQL Server 2016 on Google Cloud Step by Step

Google Cloud Services recently added Microsoft SQL Server to its offerings. Google’s move is primarily due to a strong customer demand. The customer wants to run...

Featured
Shrink SQL Server Database Log in Availability Groups

How to Shrink SQL Server Database Log in Availability Groups using TSQL

In my previous posts, I have already spoken about the best practices of Shrinking Log files and Database Files. From the recommendations, it is quite evident that Microsoft...

Featured
Manage your SQL Server Log and Database File Size Growth

How to Manage your SQL Server Log and Database File Size Growth

Before going into the discussion of managing SQL Server files (*.MDF & *.LDF ) it is essential to know the reasons why your files are growing in the first place. Understanding...

Featured
Upgrade from Expired SQL Evaluation Edition

How to Upgrade from Expired SQL Evaluation Edition

Looking to Upgrade from Expired SQL Evaluation Edition? Upgrading or recovering your data from an expired edition of SQL Server is not easy. It is always recommended to upgrade...

Featured
Shrink SQL Server Databases for Mirroring & Availability Groups

Shrink SQL Server Databases for Mirroring & Availability Groups

We know you will not like it, but, shrinking databases is a bad idea. Ask any experienced DBA or a database architect and he/she will tell you why. You can only make it a one-time...

Featured
How to Upgrade to SQL Server 2016 from Earlier and Older Versions

How to Upgrade to SQL Server 2016 from Earlier and Older Versions

Upgrading to the latest edition of SQL Server could be a breeze if planned properly. It is important to take note of all the SQL Server related services that need to be migrated....