Programming an information system can be strenuous labor. If you’ve ever spent hours intently producing some intricately detailed textual composition, you know what I mean. And if you’re typing out mind-numbing technical verbiage every single work day, the repetitive stresses can wear you down. If you’re a programmer, your nervous system will scream for anything […]
Debugging Complex SQL Queries
Click to learn more about author Michael Blaha. We favor the offloading of application logic to SQL queries. Developers can save time, effort, and reduce mistakes by substituting SQL for programming code. This leads to lengthy and complex SQL that must be debugged. It is common to write a SQL query that initially fails to execute. […]
More Help on the Way for Democratizing Artificial Intelligence
It seems as if you can’t pull up a website on data these days without running into the term Artificial Intelligence. And with good reason: Markets and Markets has it pegged as reaching $16 billion by 2022. Wander around the Web and you can hit on stories about everything from the top AI stocks to […]
Database Reflections: Ten Things to Consider
Click here to learn more about author Michael Blaha. I’m going to do something different this month and reflect on some observations of the IT industry. My comments will focus on database-related topics. This is a smattering of ideas that is not intended to be comprehensive. I’m hoping that this article will stimulate dialogue. I […]
Identifying and Deleting “Empty” Columns in R data.frames
Click here to learn more about Steve Miller. Toward the end of last month’s blog on SAS, R, Python, and WPS, I mentioned a current project challenge of identifying and eliminating “mostly” null columns from wide SAS data sets. As the team discovered, such columns can impose a significant drag on performance. My take is that while […]
SAS, R, or Python – Enter World Programming System (WPS)
Click here to learn more about author Steve Miller. With more than a little serendipity, I came across a report detailing the results of the third annual survey by Burtch Works Executive Recruiting, entitled “SAS, R, or Python Survey 2016: Which Tool Do Analytics Pros Prefer?” The survey asked each respondent to name the single […]