Matthew McGiffen

I started my career in IT as a developer with Visual Basic, C# and ASP working with SQL Server backends. For the last ten years though I’ve focused on the SQL Server side of things. Currently I’m working for a leading software vendor for the financial industry as a DBA, doing a mixture of development and data architecture. If I have a speciality it is in making things run faster.

Twitter: @MattMcGiffen
Website: https://matthewmcgiffen.com/

All authors

SQL Puzzle 1: Magic Squares

by Matthew McGiffen

Matthew McGiffen DBA

This is the first in what I hope will be a semi-regular series of recreational puzzles where SQL can be...

2017-06-07

1,609 reads

Working with Data in Always Encrypted

by Matthew McGiffen

Matthew McGiffen DBA

In this post we’re going to create some encrypted columns in a table in a test database and look at...

2017-06-06

10,915 reads

Tuning Parallelism on SQL Server

by Matthew McGiffen

Matthew McGiffen DBA

Parallelism and MAXDOP
There’s no doubt that parallelism in SQL is a great thing. It enables large queries to share the...

2017-05-26

5,311 reads

SQL Server 2016 SP1 – A significant change to licencing

by Matthew McGiffen

Matthew McGiffen DBA

A lot has been written about the change of licencing in SQL 2016 SP1. Here's my two-pence worth.

2017-05-17

17 reads

Splitting Strings on SQL Server 2016

by Matthew McGiffen

Matthew McGiffen DBA

A small change, but a great one, in SQL 2016 is native support for splitting strings.
This has to be about...

2017-05-09

781 reads

Tuning Parallelism on SQL Server

by Matthew McGiffen

Matthew McGiffen DBA

Thoughts on how to think about parallelism in SQL Server - and how to tune it.

2017-04-18

16 reads

Working with Data in Always Encrypted

by Matthew McGiffen

Matthew McGiffen DBA

In this post we’re going to create some encrypted columns in a table in a test database and look at some of the practicalities and limitations of working with...

2017-04-10

10 reads