Execution Plans, Performance Tuning and Rum

This is me on the last cruise
In just a few more weeks I’ll be setting sail on the first of...

IT Pro Airlift 2015 Portugal – Microsoft Data Platform

On 22 of January 2015, Microsoft Portugal is organising a new IT Pro Airlift 2015 – – Microsoft Data Platform event. This...

Looking back on 2014

When a new year comes around it is always a great time to reflect on the previous year.

2014 was a...

Things I Learned in 2014

2015 is here!
Last year I wrote about what I had learned in 2013, and I try to make it a...

T-SQL Tuesday #62 - Invitation to HealthySQL

Greetings ALL and Happy New Year 2015!  I wish everyone an excellent year ahead, and
that 2015 will bring peace and...

Using an alternate TypeScript compiler inside Visual Studio

TypeScript team member Daniel Rosenwasser provided instructions for replacing the TypeScript compiler and language service used by Visual Studio here:

https://github.com/Microsoft/TypeScript/issues/1110#issuecomment-62451204

He...

Website Updated

Over the Christmas holiday period the gethynellis.com website has had a bit of revamp.

In terms of what has changed,...

Beware of Login Issues for Privileged Accounts

In a recent post, I described an attack against a privileged account using a simple SQL Injection technique of updating...

Case of the Mondays... causing me to randomly redefine the Scope of Global temp tables

Today, I was reminded that global temp tables scope lasts for the session, and doesn't last beyond that. The difference...

Effects of Max Mem on Plan Cache

Some effects on plan cache and max memory settings
Related Posts:

The Curiously Large CASE Statement March 20, 2019

Maintenance Plan Owner - Back to Basics December 13, 2018

ArithAbort and...