Jon Gurgul's Blog - Page 6 of 10 - Jon Gurgul with SQL Server...and occasionally something else.

How to Set Up a Chessboard Correctly

2026-02-08

SQL Server Policy-Based Management the hidden configuration baseline.

2018-03-05

Regain access to SQL Server via inject service

2017-08-12

Microsoft SQL Server 2016 build

2016-10-16

Backup History

2016-08-07

SQL Server and PowerShell (SQLPS) Starter

2016-05-28

SQLBits XV – 4 – 7 May 2016

2016-03-30

Using the default system_health Extended Event

2016-02-28

Creating a Deadlock

2016-02-01

Samsung Gear VR2

2015-11-30

Bits, Bytes and the Binary Decimal confusion

2015-11-28

New Lab Environment 2015 and vpro VNC blackscreen

2015-10-17

SQLRelay Bristol (13th Oct 2015)

2015-08-30

Most Recent SQL Query

2015-07-30

SQL Server Locks

2015-06-21

Database Corruption Week 7 Solution

2015-06-21

Database Corruption Week 6 Solution

2015-05-28

Database Corruption Week 5

2015-05-18

Database Corruption Week 4 Solution

2015-05-05

Database Corruption Week 3 Solution

2015-05-03

Database Corruption Week 2 Solution

2015-04-26

Database Corruption Week 1 Solution

2015-04-25

New Lab Environment 2015

2015-03-31

SQLBits XIV – 4 – 7 Mar 2015

2015-03-01

Help, I have lost a SQL data file and I have no backup

2015-01-27

SQL Index dm_db_index_xxx_stats

2014-12-27

Surface Pro 3

2014-11-30

Find SQL Server Instances

2014-10-24

A simple what is running script aka a modern sp_who2

2014-09-28

T-SQL: Sequential Numbering

2014-08-18

Check status of SQL Jobs

2014-07-22

SQL Event for July 2014

2014-06-30

Checking what permissions they have in SQL Server

2014-05-29

Dangers of giving dbo in MSDB

2014-04-22

SQL Saturday 269 Exeter

2014-02-28

SQL Server Login password hash

2014-01-30

Running as local system to allow administrators in to SQL Server

2013-12-15

Simple Table and Index Breakdown With Buffered

2013-11-27

Detailed Table Index Breakdown With Buffered

2013-11-27

Quick data wipe via truncate

2013-11-27

Leap Year

2013-11-27

Last Backup Occurred

2013-11-27

Get-VolumeFreeSpace

2013-11-27

Dell Service Tag

2013-11-27

First day of the week

2013-11-27

Get-DatabaseSizes

2013-11-27

Transaction Log Usage By Session ID

2013-11-27

Coalesce vs ISNULL

2013-10-31

SQL Events 2013 Part 2

2013-09-21

Suppress messages in SQL log

2013-08-22

Configure Alerts SQL Server

2013-07-17

My MCM plaque, bag and laptop case

2013-06-29

SQL Server Page Types

2013-06-02

SQL Server Row Internals

2013-05-27

MCM 2008 Success

2013-04-12

SQL Server Partitioning Data Movement

2013-02-15

SQL Server Partitioning Overview

2013-02-15

Find Uptime / Last Boot Up Time Commands

2013-01-16

SQL Events 2013

2012-11-22

SQL Object Decryption

2012-11-18

Get-StringHash and Get-FileHash

2012-11-02

Consultancy / Contract Work / New Certification Goal

2012-09-23

SQL Server Memory Usage – Buffer

2012-08-25

Failing the MCM Lab exam

2012-07-27

Post MCM Lab Exam 88-971 thoughts etc

2012-07-06

TORN_PAGE_DETECTION Internals (SQL 2005 onwards)

2012-06-22

SQL Server Max Row Size 8060 Part 2

2012-06-09

Passed MCM Knowledge Exam 88-970

2012-05-16

Page Life Expectancy

2012-04-20

SQL Servers Virtual Columns and Row Cracking

2012-04-16

SQL Server Max Row Size 8060

2012-04-13

SQL Server Instance Security: Scripting Permissions Part 2

2012-03-22

SQL Server Instance Security: Scripting Permissions

2012-03-22

Tidy Blog, lazyness and SQLBITS X

2012-03-22

Capturing Deadlocks

2012-03-22

SQL Server Profiler Trace

2012-03-22

Delta and Cumulative IO Stats

2012-02-26

SQL Server Memory: Max Server Memory or Task Manager is wrong

2012-01-27

Studying for the SQL MCM 2008 (Microsoft Certified Master)

2012-01-09

Motivation & Exams MCDBA MCITP cough

2011-12-23

List Installed Software aka Get-InstalledSoftware

2011-12-06

WMI Classes Via Powershell

2011-11-25

Time Calculations (Rounding time to 00:00 or x minute)

2011-10-26

Simple Table and Index Breakdown

2011-10-19

Detailed Table and Index Breakdown

2011-10-19

Investigating CHECKPOINT

2011-09-19

Database Created Version or Internal Database Version – dbi_createversion

2011-09-12

What is the easiest way to compare data in a SQL Server table and fix any differences?

2011-08-16

SQL Updates

2011-08-02

What has changed in SQL 2008 R2 SP1?

2011-07-20

Policy-Based Management Execution Mode

2011-07-04

Chess

How to Set Up a Chessboard Correctly

The Complete Guide Using dArk White King BaNneR Setting up a chessboard is one of the most common stumbling blocks for beginners.Most guides give you a list of disconnected rules:…

Jon Gurgul 2026-02-08

Powershell SQL Server

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

Configure Alerts SQL Server

As a base set of alerts for monitoring SQL Server I tend to use the following out of the box categories, with the obvious exception of syntax errors. This will…

Jon Gurgul 2013-07-17

Blog

My MCM plaque, bag and laptop case

Look what I got in the post... Free stuff from Microsoft. Well true you need to pass a few exams to get them, but how cool is the swag. I…

Jon Gurgul 2013-06-29

SQL Server Page Types

There are lots of different page types and Paul Randall list them in his article. However as I tend to have a rather poor memory for remembering them first off…

Jon Gurgul 2013-06-02

SQL Server Row Internals

Row Storage A Row is stored on a Page which is 8192 Bytes, and this is broken down in two key areas when considering physical storage. Firstly on all pages…

Jon Gurgul 2013-05-27

Blog SQL Server

MCM 2008 Success

I got an email from Microsoft! The lab I took on the 11th April. (Yesterday). I passed!!! So.... a long time ago in a place....no wait... I passed the prerequisite and…

Jon Gurgul 2013-04-12

SQL Server Partitioning Data Movement

Introduction This is a continuation to the partitioning overview post to help explain how data movement is performed using Alter Partition with Merge and Split Commands. Getting Started In order to…

Jon Gurgul 2013-02-15

SQL Server Partitioning Overview

Introduction This is a guide to help explain partitioning setup; which although introduced way back in SQL 2005 is still an area which throws up a lot of questions. Requirements…

Jon Gurgul 2013-02-15

Find Uptime / Last Boot Up Time Commands

There are numerous ways to find how long a machine has been powered on for, and below I will list a few of them: CMD Powershell

Jon Gurgul 2013-01-16

Blog SQL Server

SQL Events 2013

2013 is shaping up to be a good year for me getting to events, so far penciled in are SQLSaturday in Exeter and SQLBits XI in Nottingham. Hope to see lots of…

Jon Gurgul 2012-11-22

SQL Object Decryption

Background The ability to "decrypt" an object in SQL Server be it stored procedure, view, function or trigger is something that I have run into a few times. In this…

Jon Gurgul 2012-11-18

Chess

How to Set Up a Chessboard Correctly

Jon Gurgul 2026-02-08

Powershell SQL Server

SQL Server Policy-Based Management the hidden configuration baseline.

Jon Gurgul 2018-03-05

Blog Powershell SQL Server

Regain access to SQL Server via inject service

Jon Gurgul 2017-08-12

SQL Server

Microsoft SQL Server 2016 build

Jon Gurgul 2016-10-16