Plan Cache bloat is generally bad – it wastes CPU, it wastes memory. Plan Cache bloat happens when SQL Server stores multiple query plans for seemingly identical queries….except they’re not identical. Let’s look at an example. Before we begin, let’s ditch the plan cache as this will help highlight the impact of our code. DON'T … Continue reading SQL Server Plan Cache Bloat
SQL SERVER…..GDPR…..ONE OF THESE IS MY FAVOURITE THING TO BLOG ABOUT….THE OTHER IS GDPR. Fortunately, this blog isn’t about GDPR! It’s about SQL Server, or more specifically, how to secure your data in SQL Server. However, if you care about GDPR (and let’s face it, we’re constantly told we should!) and you happen to have … Continue reading SQL Server and GDPR, what should you be doing?
I’m British, and we’re used to waiting in line for things, but why is my SQL Server waiting? This is a question that comes up a lot, and is a lesson 101 problem for any Database Admin. We know that SQL Server waits, but is this bad? Should we be doing something, or buying something? What do … Continue reading SQL Server Waits: How, What and Why
A question was asked on LinkedIn (https://www.linkedin.com/groups/137774/137774-6171222761881600002) regarding the difference between clustered and none-clustered indexes. Since LinkedIn limits the characters you can enter, I'm posting my (hastily written) reply here. I often explain it to SQL newbies using the example of a dictionary vs store catalogue. Let's say you pick up a copy of the … Continue reading SQL Server – Clustered vs Non-clustered indexes
In this blog I'm going to walk you through a serious SQL Server performance problem I had in a customer's production environment. Turned out that although the results were good, a miss-behaving table-valued function in one query was executing thousands of times more than necessary, and killing the performance. The code, as I found it, looked like … Continue reading SQL Server – Why a Table-Valued function could be killing your performance
I've just gone through the slightly torturous process of setting up my Raspberry PI (RPi) and PiFace. For my own reference, and for others, here's list of useful resources. Hopefully this will give you all the pieces of the 'Pi' that you need (sorry!!!). Good setup guide Setting up your PiFace Enabling Mesh in Scratch (allows … Continue reading Getting started with the Raspberry PI, PIFace and Scratch.
Introduction This is my second blog on my experiences in teaching programming to children. The first discussed what happened when I went into a primary school to teach some of the basics of Computer Science, such as binary, logic, and cryptology. IT in education is a big topic in the UK at the moment and … Continue reading Teaching Scratch