Browse the archive
If this dog-umentation is right, can you spot all the problems in the generated arf-ifact? For years, I’ve advocated for keeping developer documentation in the same code repository as the code it describes. In the age of AI, that practice has become even more …
Continue readingWe used to call Callie "C". There’s a particular kind of writing that has become increasingly easy to produce: technically plausible, grammatically correct, reasonably well organized, and almost completely exhausting to read. You know the stuff–it has a lot …
Continue readingQuestion 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 readingLast 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 readingI’m super excited to announce that today I was notified that I will be joining the Friends of Redgate program! 🎉💃🎊 “What’s the Friends of Redgate?” you ask? Well, the Friends of Redgate is a program for SQL Server Community members who blog/speak/etc within …
Continue readingI 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 readingThis red panda is sad because it has to use [brackets] on its code. Might also be sad to find out it's not actually a panda. The number of people who really love having their code [quoted] with [square brackets] is pretty small. The vast majority of people …
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 readingSharing is caring, unless the share is using SMBv1. In case you’ve missed it (though, if you’re a data professional or other IT pro, you must live under a rock if you’ve missed it), SMBv1 should never ever be used. Alas, some shares out there still exist & …
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 reading
