For Free!
Here’s some stuff I’ve been working on lately:
- Added an inline table valued function that strips characters from a string
- Added a script to create useful Alerts in SQL Server
- Added the recompile_cause column to the output of the recompile event
- Added the wait_resource column to the blocking event output
- Fixed a bug around table creation
- MsSQLServerDBA fixed an issue where GO statements were preventing deploying with DBA Tools
- Remove a recompile hint that was leading to high tempdb allocations (more on that tomorrow)
- Fixed a bug where date filtering was messing up query results
Enjoy, and as always, please let me know if there’s anything I can do to improve the scripts usability, or any issues you encounter while using them.
Thanks for reading!
Going Further
If this is the kind of SQL Server stuff you love learning about: these days I have AI do the annoying stuff for me. My new video course teaches you to work the same way, and I teach whole teams in a one-day workshop. Someone still has to know enough SQL Server to keep the robots in check, and that’s what my training is for.
Hey! About dbatools PS module – if Invoke-DbaQuery stumbles upon a “GO” word surrounded in a string by whitespaces only, then it splits the input script where GO was found and then it executes it part by part with some .net stuff. They don’t / can’t analyze it if GO is inside quotes or comments. Therefore truncation can happen so it’s kinda by design.
https://github.com/sqlcollaborative/dbatools/blob/development/internal/functions/Invoke-DbaAsync.ps1#L163 (yeah I’m tryin’ to be a smartass)
Yeah, I’ve run into other oddball issues too: https://github.com/sqlcollaborative/dbatools/issues/6178
I can’t imagine how hard it is to script this stuff.