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.
I am starting a new mini-series called “Today I Learned” to start blogging a bit more about simpler topics, not so much about things that will definitely help you as much as things that helped me (and I will probably forget about in 3 months.)
Today’s topic is about how to get VS Code working with PowerShell 2.0.
A friend of mine was recently discussing using Flame Graphs in a project of his, and it inspired me to see how I could abuse the format to present a visual model of SQL execution. Originally I had thought of building my own interface, but apparently the author of the above site also maintains a […]
A friend of mine had an idea for a project based on new and upcoming domain names and wanted some help transforming the Zone files into something a little more intelligible. While we wait for confirmation, I used an existing scans.io dataset to get him his first results, feel free to download the data and […]
This is some code came together as a result of straightforward requirements; a team needed to spend a significant amount of time doing manual restores, and were tired of the GUI nonsense from SSMS. But also wanted some basic flexibility due to the fact that the servers configuration may change significantly (but not during the […]
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. […]