SQL Server - Jon Gurgul's Blog

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…

Jon Gurgul 2018-03-05

Blog Powershell SQL Server

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…

Jon Gurgul 2017-08-12

SQL Server

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…

Jon Gurgul 2016-10-16

SQL Server

Backup History

If you want to see more than just when the last backup occurred. Here is a script for backup history with two bonus features. Backup compression ratio - CompressionRatio Backup…

Jon Gurgul 2016-08-07

Blog Powershell SQL Server

SQL Server and PowerShell (SQLPS) Starter

The following two snippets of code are two ways to achieve the same outcome, which is the $Server object containing the default instance. Or when opening a SQL PS (Powershell)…

Jon Gurgul 2016-05-28

Blog SQL Server

SQLBits XV – 4 – 7 May 2016

Very exciting SQLBits is nearly here again. Still time to register if you have not already done so :) Exhibition Centre Liverpool Kings Dock Waterfront Liverpool Merseyside L3 4FP United…

Jon Gurgul 2016-03-30

SQL Server

Using the default system_health Extended Event

The default extended event system_health appeared in SQL 2008 and provides several key monitors, which can prove useful when investigating issues. In the past I have mentioned this in the…

Jon Gurgul 2016-02-28

SQL Server

Creating a Deadlock

Previously we have looked at how to capture a deadlock, but how do we go about creating a deadlock? I think the following is the simplest method: 1. Create two…

Jon Gurgul 2016-02-01

Blog SQL Server

SQLRelay Bristol (13th Oct 2015)

Just checked and this is down to the last 60 tickets, so I would register quick if you are able to come to the south west for this one. This…

Jon Gurgul 2015-08-30

SQL Server

Most Recent SQL Query

Here is another query that is useful to have when you need to find out what everyone is up to. Or in some cases when we need to recover what…

Jon Gurgul 2015-07-30