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...
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...
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...
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...
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...
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...
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...
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...
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...
How to Prevent “Only secure content is displayed” Message in IE
How to Prevent “Only secure content is displayed” Message in IE Sometimes, when you try to open certain webpages on the internet, you may prompted repeatedly a message that...
