Browse the archive
I was recently fussing with a CSV file that had an inconsistent number of columns. UGH. There was a bunch of historical data that had 4 columns, and then more recent data had a new attribute added with 5 columns. I spent a few minutes cursing whoever was …
Continue readingThe number of people who really love having their code [quoted] with [square brackets] is pretty small. The vast majority of people who I meet really hate them, and promptly remove them.
Continue readingI was recently asked: For testing, I need to generate artificial CPU load on the server, outside of SQL Server. Do you have any ideas? Maybe something with PowerShell? I quickly replied: Heck yea, PowerShell can do that. I mean, I knew PowerShell could do it. …
Continue readingCheck whether a Windows file share still uses SMBv1 before disabling the legacy protocol.
Continue readingI might be a SQL Server pro, but I’m still a PowerShell novice. I learn best by doing, so I keep pushing myself to do more with PowerShell so that I can learn more. If you don’t already know this about the SqlServer PowerShell Module, you can access SQL Server …
Continue readingUpdated (2018-09-24): SQL Ops Studio is now generally available, and has been renamed Azure Data Studio. I've updated the cheat sheet to reflect the name change, but the shortcuts remain the same. Feel free to grab the updated PDF with the new label, or keep …
Continue readingUse a backup to NUL to test SQL Server backup throughput without writing a backup file.
Continue readingI often get asked, “Do you have any of your sessions recorded so I can watch them online?” And the answer has always been, “No, you’ll have to come see me in person.” I’m a tad of a perfectionist, so if I was going to record something just for publication …
Continue readingShortcuts & tips from an Impatient DBA This series of short posts will demonstrate some lesser-known features, keyboard shortcuts, and other tips that make my day as a DBA more productive. None of these are groundbreaking super-secret features–they are the …
Continue readingvstrien is using the (legacy) SQLPS Powershell module, and running into a bug where importing the module changes your current directory.
Continue reading
