Fun week! I moderated a couple of great sessions for 24 Hours of PASS: Summit Preview. As someone getting into presenting, watching the Pros do it is invaluable.

Here’s the sessions that I moderated: –

PowerShell for DBAs, What’s in it For Me?
Ben Miller gave a great overview of the powershell for DBAs out there just getting into it

Becoming Proficient with Columnstore Indexes
Niko Neugebauer with an introduction to Columnstore Indexes – really handy if you haven’t used them before

On Transactions and Atomic Operations
Gail Shaw with a cool back to basics sessions on how transactions within SQL Server work

Recordings should be up in a week.

I’m also speaking for the PASS Virtualisation chapter next month, at 17:00 (UTC) on the 9th of August. Details are here, hope you can join in!

Have a good weekend!

Fun week, and what a Lions final test last weekend. Still can’t believe it!

Here’s what I’ve been reading…

STOPAT And Date Formats
Dave Mason tests if different date formats are compatible with point-in-time database restores

How the SQLCAT Customer Lab is Monitoring SQL on Linux
Post on the SQLCAT Team using apps in containers to monitor SQL on Linux

Various Dockerfiles for Windows
Stefan Scherer’s github with a load dockerfiles

Docker on a Raspberry Pi
Step-by-step guide to getting Docker up-and-running on a Raspberry Pi

NASA’s Juno Spacecraft Spots Jupiter’s Great Red Spot
NASA’s Juno probe has sent back some stunning photos

Have a good weekend!

Final Lions Test tomorrow! The win last week sets up a thrilling series decider, if they win they’ll be the first Lions Team to win a series against New Zealand for 46 years! In the build up I’ve been reading…

Setting up Visual Studio Code Tasks
I’ve been using VS Code for a bit now and this week set up tasks to run some of my powershell scripts. Really useful.

Best OS for Docker Host?
A Reddit thread about which OS is recommend for a Docker Host.

Building a dedicated backup test server
Chrissey LeMaire goes through how to automate testing your backups using dbatools.io commands

The Feynman Technique: The Best Way to Learn Anything
Article on a learning technique. The advice about teaching is very true!

SQLSaturday Porto
SQLSaturday #685 has been announced and the call for sessions is open

Have a good weekend!

Second test for the British & Irish Lions tomorrow, they need this one to keep the series alive. I’ll be up early to watch it tomorrow, the team selection is here.

But anyway, this week I’ve been reading…

Using SQL Server Diagnostics
Arun Sirpal goes through how to use a new extension for SSMS that analyses SQL Server dump files

PowerShell Module for the SQL Server Diagnostics API – 1st Command Get-SQLDiagRecommendations
Continuing looking at the new SQL Server Diagnostics tool, Rob Sewell goes through a powershell module he’s built to interact with the API

Demystifying Microsoft Distributed Transaction Coordinator and SQL Server HA Configurations
Allan Hirt clarifies an area that always been a bit of a black box for me, Distributed Transactions

SQL Server 2012 SP4 now to be released in September 2017
I wonder what they found when testing 🙂

‘Vaccine’ created for huge cyber-attack
There’s a defence against the latest ransomware, but that doesn’t mean you shouldn’t be fully patched

Have a good weekend!

The weather has been absolutely boiling here in Dublin all week, I’m dying for a cold beer! Anyway, whilst drinking beer I’ll be reading…

Docker Basics Webinar Q&A: Understanding Union Filesystems, Storage & Volumes
Webinar (with transcript) going into the storage concepts behind docker containers

Continuous Delivery to Microsoft Azure with Docker
How to run the Azure CLI from a container

Fresh Paint – Give VS Code a New Look
VS Code is a great editor. This post details some of the themes that can be set.

PASS Summit 2017 – Speakers
More speakers have been announced for this year’s Summit. The line up looks fantastic!

British & Irish Lions Squad Announcement
First Test against New Zealand tomorrow! Here’s the squad.

Have a good weekend!