SQL

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

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
How to Shrink SQL Server Database Log in Availability Groups using TSQL

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
How to Manage your SQL Server Log and Database File Size Growth

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

How to Manage your SQL Server Log and Database File Size Growth Managing the Database and log file size growth can be a difficult task sometimes. When things go out of hand, DBA...

Featured
How to Upgrade from Expired SQL Evaluation Edition

How to Upgrade from Expired SQL Evaluation Edition

How to Upgrade from Expired SQL Evaluation Edition SQL Server Evaluation Edition is a full-blown Enterprise Edition that you can run for 180 days. That is a right amount of time...

Featured
Shrink SQL Server Databases for Mirroring & Availability Groups

Shrink SQL Server Databases for Mirroring & Availability Groups

Shrink SQL Server Databases for Mirroring & Availability Groups Shrinking SQL Server Databases and Log Files is a popular discussion among both experienced and entry level...

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

How to Upgrade to SQL Server 2016 from Earlier and Older Versions SQL Server 2016 comes with multiple components. Upgrade considerations for each one of them is different. Before...

Featured
SQL Server 2016 Pre Upgrade Checklist and Unsupported Scenarios

SQL Server 2016 Pre Upgrade Checklist and Unsupported Scenarios

SQL Server 2016 Pre Upgrade Checklist and Unsupported Scenarios SQL Server 2016 introduced a large number of enhancements and feature releases, which have prompted corporations to...

Featured
Auditing Features in SQL Server 2016 and Azure SQL Database

Auditing Features in SQL Server 2016 and Azure SQL Database

Auditing Features in SQL Server 2016 and Azure SQL Database SQL Server auditing features allow you to track and log both server level events, as well as individual database...

Featured
SQL Server 2016 Is Faster Than Ever

New SQL Server 2016 Installation Features Walk through

New SQL Server 2016 Installation Features Walk through SQL Server 2016 came up with some exciting new features, which could sometimes be overwhelming for data professionals. On...

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

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 cost-effectiveness and feature sets. Its...

FOLLOW @ INSTAGRAM