go to post Chad Severtson · Apr 25, 2023 I plan to delete this article the second that the version containing Stochastic Sampling is installed everywhere. In the meantime, I can think of a few customers that need alternatives. Your SQL utilities are great and also available via Open Exchange.
go to post Chad Severtson · Apr 12, 2023 Consider $System.OBJ.ExportToStream() and .LoadStream() to avoid local files with a change to the appropriate implicit namespace between.
go to post Chad Severtson · Apr 12, 2023 It has been around for a few years.Personally, I hesitate to use the alias capability lest I find myself in an environment without them!
go to post Chad Severtson · Dec 15, 2022 This is an excellent article Murray! Thanks for putting it together. It was exactly what I needed for a conversation this morning.
go to post Chad Severtson · Nov 12, 2022 ENSDEMO is not included in IRIS installations. However, it is available here: https://community.intersystems.com/post/install-ensdemo-iris.
go to post Chad Severtson · Nov 4, 2016 The command $SYSTEM.SQL.DATEDIFF(outputFormat, start, end) is also quite useful for date arithmetic. It is a lot less picky about the format and a lot more powerful regarding the output.
go to post Chad Severtson · Aug 4, 2016 Write quote Hello World,Dollar SYSTEM Dot ProcessDot Terminate(Pid)
go to post Chad Severtson · Aug 1, 2016 The biggest question will be whether or not you have any sensitive information stored outside of Ensemble. Please note with Caché/Ensemble Encryption there is no backdoor.
go to post Chad Severtson · Aug 1, 2016 When a language isn't strongly typed, I often test unexpected but possible types -- for example: Numbers or Strings instead of Dates or Booleans. Other favorites: """null""undefined" Quotes, comments, and other injection attack patterns. As Jon Willeke suggested, I also use random data when possible (apart from the -1, 0, 1 defaults). The %Library.PopulateUtils class can be helpful for generating other preformatted random information.
go to post Chad Severtson · May 17, 2016 The version of the documentation should be clearly displayed as there are differences between the respective versions (and not just in appearance). The ordering of the sidebar is confusing to the point that I find it distracting.