Your documentation belongs with your code
Why technical documentation belongs alongside the code it describes, and how that improves maintenance.
Continue readingBrowse the archive
Tools & Automation
Clear, Concise, Complete, and Correct: Avoiding AI Slop
Why polished but generic AI writing can be exhausting, and how clear, concise, complete, and correct writing helps.
Continue reading
Function to create SQL TABLE does not works well using Powershell
Question I need to get the values from a Excel Sheet (in a shared folder) to export it and then create a SQL Table in my instance. After of this I will execute a Stored Procedure (I already created) in order to create extended properties for a specific schema …
Continue reading
Redgate Streamed
Last week, I had the pleasure of participating in Redgate Streamed, a three-day virtual conference organized by my friends at Redgate. My session was Shortcuts from an impatient DBA–discussing a bunch of Management Studio tips & tricks for data professionals. …
Continue reading
Joining the Friends of Redgate program 🎉
I'm super excited to announce that today I was notified that I will be joining the Friends of Redgate program! 🎉💃🎊
Continue reading
Using PowerShell to tidy up CSV files
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 reading
Removing [square brackets] from generated SSMS scripts
The 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 reading
Generating artificial CPU load 🔥
I 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 reading
Is that share using SMBv1?
Check whether a Windows file share still uses SMBv1 before disabling the legacy protocol.
Continue reading
Using PowerShell to navigate SQL Server as a drive
I 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 reading