Generating Tables of Contents for Github Projects with PowerShell

Table Of Contents Initial Idea Clarifying Our Requirements The Code Special Thanks   Initial Idea Let”s generate a table of contents for a Github flavored Markdown document in PowerShell (because nobody else seems to have.)   Clarifying Our Requirements After talking with Claudio, he didn”t just want a TOC for a particular markdown file (though […]

Automate and Simplify DBCC CHECKDB

As a part of the T-SQL Tuesday run by Rob Sewell this month, I wanted to throw in a little post about using Test-DbaLastBackup which I will also be showing off a this year’s SQL Summit!   Come to the Precon If you like this post, don’t forget to signup for me and Chrissy Lemaire’s precon […]

You committed files to the wrong branch (master), and now you want to apply your changes to the right one (development)

I wanted to share a scenario and solution for a problem I am seeing arise in the dbatools project: Commits are registered against the “wrong” branch A pull request is submitted The file comparison shows hundreds of changes instead of 1-2 There are many ways this can happen, but usually due to forgetting to create […]

TIL – Trello(JSON) and PowerShell – Summarizing public boards

Had a need to look into a Trello board’s activity and thought I would blog the first of some “recipes” I am coming up with.

To start it off, I wrote some trivial functions to format Trello URLs (as they appear today) to return the JSON representation of the board, and return some basic information about the activity that recently occurred.

T-SQL Tuesday 85: Managing database snapshots with dbatools

For my second TSQL Tuesday post, I wanted to introduce a nifty feature in the dbatools lineup called Restore-SQLBackupFromDirectory, which used Ola Hallengren’s scripts as a baseline to restore a server from a backup folder, however during writing this I came across a newer command that Stuart Moore engineered (Restore-DBABackup) which made it entirely redundant, […]