PowerShell Tools and Books That I Use (Revisited)

A friend of mine found this blog yesterday and commented on “PowerShellToolsandBooksThatIUse“. I thought that it would be good to update the list since it’s almost 2 years old.  The changes are mostly incremental: version changes, a few new items, a few I don’t use much anymore. Without further ado, here we go (now with …

Continue reading ‘PowerShell Tools and Books That I Use (Revisited)’ »

A few functions for working with SQL Agent Job data

If you’ve ever looked at sysjobhistory, you know that the way SQL Server stores datetimes and durations in this table are not very friendly. Well, that’s not quite true. They are human-readable if they are small, but if you’ve got a job that runs for hours (days?), it becomes more and more difficult. For example, …

Continue reading ‘A few functions for working with SQL Agent Job data’ »