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

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

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

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

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

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

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

Featured

How to Replicate your Data to an Azure VM with SQL Standard

How to Replicate your Data to an Azure VM with SQL Standard SQL Server Standard is undoubtedly one of the best selling editions due to its...

Featured

What are SQL Server 2016 Basic Availability Groups Restrictions

What are SQL Server 2016 Basic Availability Groups Restrictions With the release of SQL Server Always on Availability groups in 2012...