NTFS Compression and SQL Server Do Not Play Well Together
accidentally copying a database to a ntfs compressed volume can result in some unpleasant aftertaste. If you get the error The requested operation could not ...
powershell
Deleting a Directory That Has a Trailing Space Shouldn’t Be This Hard
Can’t delete a directory due to some edge case in naming errors… like a trailing space. Here’s the fix!
Exploring SQL Server With Powershell And SMO Basics
SqlServer Powershell Cmdlets 2017 - Initialize Look
Capturing Perfmon Counters With Telegraf
Other Posts in Series
InfluxDB and Annotations
Other Posts in Series
ANTS Performance Profiler for the SQL Server Dev
There are a few .NET tools that until recently I haven’t had the chance to work with as much, specifically ANTS Memory Profiler and ANTS Performance Profiler...
Update SSMS With PS1
Installing and Updating SSMS with a simple PowerShell script can be a nice little timesaver…
Add User To Admin Group on Machine
In setting up some build machines for development, it’s tedious to go and add several users to the admin group. Here’s a snippet to expedite that task and he...
Running InfluxDB as a service in Windows
Other Posts in Series
Setting Up InfluxDb, Chronograf, and Grafana for the SqlServer Dev
Other Posts in Series
Automate Windows Updates for Development
I’ve run into the case where I wanted updates continually applied, while the machine still was part of the GPO that didn’t automatically install updates. For...
TFS Custom Task - Service Actions (for TFS 2015 Update 2.1 or before)
Apparently, boolean values for custom VSTS tasks for versions prior to TFS 2015 Update 3) require some special handling as they don’t pass the checkbox value...
Quick Way to Run Powershell Tasks in Parallel
Running tasks in parallel can be a bit difficult in powershell. However, there are a few projects out there that optimize the performance and provide a bette...
Dynamically Set Powershell Variables from json
I created this small snippet to allow a list of values from a json file be turned into variables to work with. For working with a fixed list of configuration...
Scan folder of dlls to identify x86 or x64 compiled assemblies
Point this at a directory of dlls and you can get some of the loaded assembly details to quickly identify what type of processor architecture they were compi...
Attaching Database Using SMO & Powershell
Steve Jones wrote a great article on using this automation here titled The Demo Setup-Attaching Databases with Powershell. I threw together a completed scrip...
Parallel Powershell for Running SQL
This is just a quick look. I plan on diving into this in the future more, as I’m still working through some of the changes being made in the main parallel mo...
Easy SQL Maintenance with Minionware
Review of using Minionware sql maintenance solution
Powershell ISE: Updating Theme
For all the dark theme aficionados, or those who just want a better theme than the default, here’s a quick set of directions to update your ISE.1. Go to down...
Cool Tools: Powershell ISE-Steroids
Disclaimer: I have been provided with a free license because I am reviewing. This doesn’t impact my assessment of the tool. I have a passion for finding tool...