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 […]
Recently we had a report in the dbatools project: there was an issue installing from the PowerShell Gallery (via Install-Module.) Error “Invalid characters in path.” We had a few scattered notifications of the issue and even one of the dbatools developers affected internally, but it proved to be a stubborn bug and the people involved […]
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, […]
TL;DR: In SQL 2000 the undocumented stored procedure xp_dirtree returns a null byte at the end the filenames it enumerates; this null byte can will likely cause issues if you don’t strip it when consuming it with .NET tools.
@sqlbek (Andy Yun) posted a challenge for T-SQL Tuesday 84, and encouraged people thinking about becoming a speaker to write about their experience giving their first talk, a topic they wanted to present on in the future, or even on starting the road to creating their blog and establishing themselves in the SQL space.
I wanted to flesh out an idea I have had for a first talk, which is about my experience with dbatools.io and introducing a production DBA to the value of PowerShell.
Notes on automatic variables in Powershell.
It depends on if you are more of a production, developer, or devops DBA, but I would definitely read everything below: Guide for the accidental DBA Brent Ozar ULTD 6 month training plan SQL Server Query Performance Tuning http://www.brentozar.com/blog/ Aaron Bertrand Adam Machanic sqlsoldier MCSA Cert 461/462 for basics.
Configuring SSRS authentication to IIS can be a pain, here are some things I have done in a pinch, and almost all of them are terrible, but if you repeatedly get a 401 unauthorized with SSRS, these might be able to help. SSRS native mode on one domain, IIS on another – DMZ In this […]
I just came across a situation where I was looking at long running queries across a few production servers, I wanted to quickly and easily run my query across them all to make sure that I wasn’t missing a problem on each server where a user had left a specific query for a looong time. […]
Once in a while I have a few questions from my classes about what music is playing over the speakers during down time or tests. This is some of the music I play for my classes, honed over a while.