Friday Reading 2017-09-08

It’s going to be a fun weekend as it’s SQLSaturday Cambridge tomorrow! Haven’t been to this event before, it looks like it’s kinda big. I’ve got the slot just after lunch so hopefully everyone will manage to stay awake during my presentation ๐Ÿ™‚

This week I’ve been reading…

Please Donโ€™t Do This!
Monica Rathbun (t) asks us all not to leave the default fill factor setting at zero

Containers are not VMs
Old post on the Docker blog detailing the differences between containers and VMs

Why I joined Heptio
Dave Cheney (t) talks about virtualisation, containers and orchestration

DBA Fundamentals September 2017
Shane O’Neill (t) details what sessions the DBA Fundamentals VG has in September

GroupBy – September Sessions
The second round of GroupBy webinars in September is today. I can’t make it as I’ll be travelling but bookmarked and will come back to them.

Have a good weekend!

Friday Reading 2017-09-01

Going to be a busy few weeks as conference season gets into full swing. Really looking forward to the next couple of months, lots to do and lots of places to visit. ๐Ÿ™‚

Anyway this week I’ve been reading/watching…

HASSP-2 Has Returned to Earth!
The second launch of the really cool High Altitude SQL Server Project took place last Saturday. Drew Furgiuele (t) talks about the day and the results

HASSP-2 – Side Facing Camera Footage
Pretty cool footage on youtube from one of the cameras

Offline Microsoft Documentation? Download it!
Clรกudio Silva (t) shows us how to download MS docs with PoSH

Creating Continuous Integration Build Pipelines With Jenkins, Docker and SQL Server
Chris Adkin (t) shows us how to build CI pipelines utilising SQL Server containers

SQL Server on Linux Engineering Town Hall: Introduction to SQL Server on Linux in Docker Containers
The next MS Town Hall focuses on SQL Server running in Linux containers. Interested to see the best practices section

Kubernetes Meets High-Performance Computing
Cool post discussing the challenges of running high performance computing workloads with Kubernetes

Have a good weekend!

Friday Reading 2017-08-25

Great week this week as I’ve been selected to speak at 4 of the SQL Relay events in October! Really chuffed with that as it’s a whole week of talking about SQL Server & Containers! Anyway this week I’ve been reading…

The Trillion Row Table
What happens when you load one trillion rows into a table in SQL Server?

Docker images for custom SQL Server Installations
James Anderson (t) shows us how to run a SQL Server in a container with the Advanced Analytics features enabled. I was asked about this awhile ago and it really cool to see that James has worked out how to get it setup.

The Evolution of Container Usage at Netflix
Netflix launches one million container per week!

HASSP-2 Launch Details
Details of the second launch of SQL Server in SPAAAAAAAAAAAAAACE! (well, nearly)

Your Serverless Raspberry Pi cluster with Docker
Cool article about running Docker in Swarm mode on multiple Raspberry Pis

Have a good weekend!

Friday Reading 2017-08-18

Cool week, I’ve been selected to present at SQL Saturday Holland & SQL Saturday Denmark this year. September and October are going to be busy months!

Anyway, this week I’ve been reading…

Open Query Store v1.1 has landed!
v1.1 of the very cool project to enable Query Store functionality in versions of SQL Server before 2016 has been released

Working with Very Large Tables Like a Pro in SQL Server 2016
Guy Glantser (t) presenting on working with vlarge tables. What’s cool about this is he goes over new functionality that can help, stretch databases for example

SQL Server 2017 โ€“ New T-SQL Functions
Rob Reid (t) goes over some of the new T-SQL functions available in SQL Server 2017

Azure Cloud โ€œFearโ€ Busting #4 โ€“ Losing Control?
Arun’s (t) final post in his Azure Fear Busting series (you’ve read the other ones right?)

Announcing the new release of Docker Enterprise Edition
Official Docker blog detailing what’s new in Docker EE v17.06

Have a good weekend!

Friday Reading 2017-07-28

Hope you all had a good week. Been pretty chilled out here so I’ve been reading…

Announcing Azure Container Instances
Microsoft blog about a new Azure service allowing us to deploy containers from the Azure CLI

sp_WhoIsActive Documentation
All of the supporting docs for Adam Machanic’s excellent sp_WhoIsActive

13 things you should know about Statistics and the Query Optimizer
Old post but always good to have a refresher into how the Query Optimizer works

Remove all user defined variables without restarting the PowerShell Console or ISE
Interesting post on how to reset variables in powershell

Downloadable SQL Server Desktop Wallpapers
Kendra Little’s awesome handdrawn SQL wallpapers. I’ve got my eye on the partitioning one ๐Ÿ™‚

Have a good weekend!