Book Review – SQL Server Query Tuning and Optimization (2nd Edition)

The nice people from Packt Publishing sent me a digital copy of Benjamin Nevarez new book to review: SQL Server Query Tuning and Optimization – Optimize Microsoft SQL Server...

Daily Coping 1 Dec 2022

Today’s coping tip is to discover your artistic side. Design a friendly greeting card. A fun one for me today. I saw this just after returning from the PASS...

New Database Job – The 6 Month Plan

So, we made it through our first 90 days, things start getting tougher now as now we really got to start looking at getting projects
The post New Database Job...

SQL Homework – December 2022 – What’s new in SQL Server?

SQL Server 2022 has been released! Long live SQL Server! No really, I’ve still got a while before retirement. I ... Continue reading

My Office Setup

At the PASS Summit a few weeks ago, I had a great chat with some folks about our home office setups. More and more of us are working from...

Creating a user for a STONITH resource in vSphere

I previously blogged about how to create a STONITH resource for a pacemaker cluster in VMWare virtual machines. Ok, I have a confession…you need to specify credentials when creating...

Default event_file path for Extended Events

Foreword
Have you ever wondered where the .xel file is saved when you create a new Extended Event session and don’t specify the full path (just the file name)?
Like so:

Well,...

Query Store Hints in SQL Server 2022

Another neat little feature in SQL Server 2022 is Query Store Hints. This is the ability to apply a query hint through Query Store rather than having to modify...

Daily Coping 30 Nov 2022

Today’s coping tip is to learn a new skill from a friend or share one of yours with them. I like learning, so in this case, I took advantage...

Encrypting Your SQL Data Should be Your Default Option

Cyber-attacks and data breaches seem to be perpetually on the rise. Every week we hear news of large companies that have had data stolen with both financial and reputational...