IG

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

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
Auditing Features in SQL Server 2016 and Azure SQL Database

Auditing Features in SQL Server 2016 and Azure SQL Database

As a part of the robust security options provided by SQL Server, it also provides fine-grained auditing both on-premises and on the cloud. In this post, we would be exploring the...

Featured
New SQL Server 2016 Installation Features Walk through

New SQL Server 2016 Installation Features Walk through

In this post, we explore the New SQL Server 2016 Installation Features Walk through. If you are familiar with the SQL Server installation process, this should not be something...