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… Continue Reading →
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… Continue Reading →
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… Continue Reading →