Notes from the Summit: Day 3 Summary

This is the third and final installment of my daily notes from the 2016 Powershell and DevOps Global Summit. Day 1 wrap-up is here, and Day 2 is here.

Sessions

9 AM (Don Jones): What DevOps Really Looks Like

Don Jones is an effortlessly entertaining speaker who’s not afraid to eviscerate ideas he finds stupid, sort of like (and I mean this in the best possible way) the Donald Trump of Windows IT. He is also a man who thinks clearly about DevOps, a subject usually buried in fuzziness and hype. (I highly recommend his short e-book on DevOps from an ops perspective.)  In this session, he gave a typically animated fireside chat about what a DevOps culture really is: an embrace of the idea – foreign to many ITIL shops – that failure is inevitable and change is good. (He brought down the house with a line about ITIL being IT governance borrowed from the DMV.)

Continue reading “Notes from the Summit: Day 3 Summary”

Notes from the Summit: Day 3 Summary

5 SQLPS Tips and Tricks

Powershell and SQL Server have been natural buddies from day one. SQL Server administrators need to automate file operations and other Windows tasks in conjunction with their database duties all the time, and xp_cmdshell only gets you so far. Fortunately, since the introduction of the SQLPS Powershell module in SQL Server 2008R2, you no longer have to load tiresome SMO assemblies to interface with SQL Server through Powershell. SQLPS uses a suite of cmdlets to provide a pretty decent user experience for the Powershell/SQL developer, although it’s not without its quirks. Let’s take a look at a few quick tips and tricks I’ve picked up while using this module in the wild. I hope they save you some of the time it took me to learn them!

5 Tips and Tricks for using SQLPS

Continue reading “5 SQLPS Tips and Tricks”

5 SQLPS Tips and Tricks