-
SQL Server Policy-Based Management the hidden configuration baseline.
Policy-Based Management Policy-Based Management is a policy based system for managing one or more instances of SQL Server. This has been around in SQL Server since 2008 but is often overlooked for both its primary function in administration as well as its ability to store baselines. If you open up SQL Server Management Studio (SSMS)…
-
Regain access to SQL Server via inject service
One way to regain access to SQL Server is to use a simple inject technique which overrides the current Image Path for the SQL Writer service. PsExec can alternatively be used to access SQL Server as shown in the post below. This relies on the NT AUTHORITY\SYSTEM account having been granted system administrator on…
-
Microsoft SQL Server 2016 build
Here is a quick post for the recommended patches to deploy for Microsoft SQL Server 2016. After deploying Microsoft® SQL Server 2016 I would recommend immediately patching to 13.00.1708 by applying the MSVCRT patch. (Unless planning to apply a later CU or SP) Critical update for SQL Server 2016 MSVCRT prerequisites https://support.microsoft.com/en-us/kb/3164398 This ODBC patch…