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, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that and need to solve performance problems quickly.
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.