Monthly Archives: July 2018

Smart Log backups SQL Server 2017

Smart log backups is a feature introduced in SQL 2017 to allow DBAs to manage the transaction log growth better. Before we go into details it might be better to understand what problem it was trying to solve. In any typical production workload we often have uneven usage on the database system, often the majority… Read More »

Changing Default port number for SQL on Windows/Linux Install

Changing the default port number of a SQL installation is one of the most basic post install steps performed. It is mainly used to make intrusion more difficult by preventing users from taking advantage of the default settings which are known in the public domain. SQL Server when install as a default instance uses port… Read More »