Is it me or is February dragging? Anyway, mixed in with this crazy week I’ve been reading: –

SQL Server vs SQL Server vNext
Henrico Bekker runs through a performance comparison of SQL Server against SQL Server on Linux

What Are FeFETs?
Article about a new memory type (FeFETs) that Startup FMC is developing

SQL Server in a Azure VM – What’s new
Channel 9 video in which Luis Vargas goes through what’s new for SQL Server in Azure

New Flagship Xeon E5 and E7 Processors
Glen Berry looks at the new Xeon processors

Altering a Job Step on Hundreds of SQL Servers with PowerShell
Rob Sewell details how he was able to make an alteration to hundreds of backup jobs in 5 mins (in an airport no less)

Have a good weekend!

Fun week, performed some RAM upgrades for my production SQL boxes which for one server, somehow fried its motherboard, hard drive AND backup drive, huh?? Meh, I like rebuilding servers…Also got a whole load of writing done so quite pleased with myself! 🙂

In-between all that, I’ve been reading…

Why databases are not for containers
I’ve been doing a lot of work into SQL Server running in containers recently and am keeping an eye out online for articles. Here’s one that’s in the minority…why you shouldn’t be using containers for database systems.

Understanding Docker for Windows
Continuing my docker obsession interest, here’s a youtube series on Docker for Windows, each part broken down into easily to digest sub 10 min videos.

Performance Testing: SQL Server on Linux vs Windows
Slava Murygin goes through a performance test of SQL Server running on Linux vs Windows.

Understanding Left vs. Right Partition Functions (with Diagrams)
Ever had your head slightly melted when trying to figure out partition boundaries? Kendra Little’s post has diagrams to make it (a little bit) easier.

Query Store: How it works? How to use it?
One of the new features that I haven’t played around much with (yet) is the Query Store. Here’s a technet post detailing what it is and how you can use it.

Have a good weekend!

2017 is trundling along now, this week I’ve been reading…

The GitLab incident report
We’ve all had that moment of “what did I just do??” Here’s how the guys at Gitlab responded to such a moment.

Linux OS Fundamentals for the SQL Admin
I don’t know how I missed this webinar but thankfully it’s been uploaded to youtube. Anthony Nocentino (b|t) goes over linux basics for us SQL DBAs.

How six lines of code + SQL Server can bring Deep Learning to ANY App
Rimma Nehme (t) goes through the what, why & how of using ML with SQL Server.

Stopping or Postponing an upgrade to SQL Database V12
Need to stay on v11 for now? Read this.

Hyper-V & powershell
Good starting reference for anyone using Hyper-V wanting to get into powershell

Have a good weekend!

Is it really still January? It seems like this month is dragging on a bit. Anyway, this week I’ve been reading…

Nearly everything has changed for SQL Server Powershell
The Scripting Guys at Technet go over the changes to SQL Server Powershell.

Learning Redis the hard way
Interesting post about the problems that Trivago had implementing Redis in their production environment.

Hack attaching a SQL Server Database
Argenis Fernandez details a way of hack-attached database with NORECOVERY, handy bit of knowledge to have.

How to secure your passwords with Powershell
Shawn Melton goes through how to store a password to be used in powershell scripts

Did someone say SQL Server AUTOPILOT?
Garry Bargsley takes us through using the undocumented DBCC AUTOPILOT command, cool stuff

And finally, why it’s called a patch

Have a good weekend!

Been an interesting week! My site has had the most views ever (so chuffed) and during all that I’ve been reading…

Microsoft’s Cyber Defense Operations Center shares best practices
Microsoft shares details some of their best practices for how they respond to cyberthreats in real time

CPU Scheduling Basics – Windows and SQL Server
Anthony Nocentino gives us a refresher on CPU scheduling

50+ free Data Science books
Looking at moving into a career in Data Science? Hey, even if you’re already working as a Data Scientist this is a great resource.

Viewing rolled back transactions after a crash
Paul Randal shares code on retrieving details of transactions that were rollback after a failure

Caching at reddit
A Senior Engineer goes through how caching has been implemented at Reddit

Have a good weekend!