{"id":2,"date":"2017-12-22T20:15:24","date_gmt":"2017-12-22T20:15:24","guid":{"rendered":"http:\/\/eipsoftware.com\/musings\/?page_id=2"},"modified":"2024-04-14T19:40:35","modified_gmt":"2024-04-14T19:40:35","slug":"sample-page","status":"publish","type":"page","link":"https:\/\/eipsoftware.com\/musings\/","title":{"rendered":"Welcome!"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Over the years in my professional life, I have strived to find a more optimal solution to the challenges presented to me. I will never contend I am a leading authority or the suggestions I present are the only way to tackle an issue.\u00a0 I am sharing the suggestions in efforts to make things easier on others; and possibly remind myself how to attack a problem.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the portfolio I have suggestions on issues with SQL, Python, R, and now some WebGL too. I am always open to hearing how others would approach a problem and trying to find a more optimal solution.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">If you have any comments or suggestions feel free to leave a comment or contact me via email.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"mailto:michael.data@eipsoftware.com\">michael.data@eipsoftware.com<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Latest Posts<\/h1>\n\n\n\n<h2 class=\"wp-block-heading\"><a href=\"\/musings\/category\/code\/python\/\">Python<\/a><\/h2>\n\n\n<ul style=\"background-color:#fdfdfd;\" class=\"wp-block-latest-posts__list wp-block-latest-posts has-background\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/microsoft-word-merge-file-app\/\">Microsoft Word &#8211; Merge File App<\/a><div class=\"wp-block-latest-posts__post-excerpt\">This app will use a web interface to facilitate merging content into a Microsoft Word file. It is the equivalent of the mail merge features with some notable improvements. The repo is available on github at github &#8211; word_file_merge_app<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/streamlit-crud-app\/\">Streamlit Table Editor App<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Today I will walk through using the Streamlit python framework to build a web based app that you can use to interact with a database. The app will allow you to Read, Update, and Delete tables in your database.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/connect-to-sftp\/\">Connect to sFTP<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Use Python to connect to an sFTP site and upload or download files.<\/div><\/li>\n<\/ul>\n\n\n<h2 class=\"wp-block-heading\"><a href=\"\/musings\/category\/code\/sql\/\">SQL<\/a><\/h2>\n\n\n<ul class=\"wp-block-latest-posts__list wp-block-latest-posts\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/temporal-tables\/\">Temporal Tables<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Where we are going, we need to keep track of the history in the tables. How to set up and use Temporal Tables in Microsoft SQL Microsoft SQL has native support for keeping track of Insert \/ Update \/ Delete from system versioned tables. The following explains how to set up and use temporal tables\u2026 <a class=\"wp-block-latest-posts__read-more\" href=\"https:\/\/eipsoftware.com\/musings\/temporal-tables\/\" rel=\"noopener noreferrer\">Read more<span class=\"screen-reader-text\">: Temporal Tables<\/span><\/a><\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/foreign-key-list\/\">Foreign Key List<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Query to show foreign keys for specified table and or column<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/search-value-in-multiple-columns\/\">Search Value in Multiple Columns<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Where is it? WHERE IS IT? WHERE???? Sometimes you need to search for a value in the table, but you have no idea where it is. The query will use a cursor allowing you to search through multiple tables and multiple columns to find the value.<\/div><\/li>\n<\/ul>\n\n\n<h2 class=\"wp-block-heading\"><a href=\"https:\/\/eipsoftware.com\/musings\/category\/visualization\/\" data-type=\"category\" data-id=\"7\">Visualizations<\/a><\/h2>\n\n\n<ul class=\"wp-block-latest-posts__list wp-block-latest-posts has-normal-font-size\"><li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/dashboard-service-line\/\">Dashboard &#8211; Service  Line<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Dashboard &#8211; Service Line Dashboard showing summary statistics by Hospital&#8217;s different Service Lines. Showing statistics about number of patients, number of encounters, surgical volume, and case mix.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/dashboard-survey\/\">Dashboard &#8211; Survey<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Dashboard &#8211; Survey Dashboard tracking students responses to organizational learning sessions. Students would rate the course, instructor, self-evaluations, and provide free-form comments.<\/div><\/li>\n<li><a class=\"wp-block-latest-posts__post-title\" href=\"https:\/\/eipsoftware.com\/musings\/dashboard-spiritual-health\/\">Dashboard &#8211; Spiritual Health<\/a><div class=\"wp-block-latest-posts__post-excerpt\">Dashboard &#8211; Spiritual Health Dashboard tracking the contacts between spiritual advisors and patients. Spiritual advisors can be for a specific religious denomination or non-denominational. The dashboard was used to ensure the hospital was in compliance with anti-discrimination laws.<\/div><\/li>\n<\/ul>","protected":false},"excerpt":{"rendered":"<p>Over the years in my professional life, I have strived to find a more optimal solution to the challenges presented to me. I will never contend I am a leading authority or the suggestions I present are the only way to tackle an issue.\u00a0 I am sharing the suggestions in efforts to make things easier [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"open","template":"","meta":{"_crdt_document":"","footnotes":""},"class_list":["post-2","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/pages\/2","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/comments?post=2"}],"version-history":[{"count":11,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/pages\/2\/revisions"}],"predecessor-version":[{"id":655,"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/pages\/2\/revisions\/655"}],"wp:attachment":[{"href":"https:\/\/eipsoftware.com\/musings\/wp-json\/wp\/v2\/media?parent=2"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}