[Video] Data Mining/Science: Supervised Time-Series Model

Keyhole Software Development Technologies & Tools, Educational Event, PostgreSQL, Python, Videos 1 Comment

In this video, Alex presents an introduction to data science “big ideas” relevant to the model, an explanation of its data modeling process, and a demonstration of the real-life machine learning solution implemented with Python, Postgres SQL, and H2O (an open-source machine learning algorithm). Multiple data sources and technologies were combined to create an accurate model that allows farmers and recreationists to make actionable insights about the future. A few questions and answers round out the discussion.

Getting Started with Azure Data Studio

Todd Horn Articles, Azure, Cloud, Databases, Development Technologies & Tools, DevOps, Project Management Leave a Comment

On my last two projects, I decided to give Azure Data Studio a try to see how it measured up to SSMS. Azure Data Studio gives you a more modern editor experience. Itโ€™s comparable to Visual Studio Code with IntelliSense, source control with GIT, and an integrated terminal for Powershell or SQLMD commands.

Azure Data Studio was built with a data platform user in mind, and its easy editing and export options, built-in charting of query results, and customizable dashboards make it an incredibly valuable tool.

In this post, Iโ€™ll go over some of the basics of how to use Azure Data Studio.

Parameterizing Queries in SQL

Parameterizing Queries for SQL Server

Clayton Neff Articles, Databases, Programming, SQL, SQL Server 2 Comments

This is just a short article (more of a blog-ette than a full blog) about some things we as developers need to consider when sending queries to Microsoftโ€™s SQL Server. While some of this information may also be true for other flavors of database servers, these things are known to be true for SQL Server.

Native MongoDB to Sequelize with PostgreSQL

Native MongoDB to Sequelize with PostgreSQL

John Boardman Articles, Databases, Heroku, MongoDB, PostgreSQL Leave a Comment

Every long-term project will outlive at least some of the technologies it was originally built with. For example, a project I have been involved with recently ran into this situation. The app is hosted on Heroku, and over the years, the available MongoDB add-ons have changed and dwindled until now, there is only one.

Several migrations between MongoDB add-ons have already happened because of shutdowns. So, it was decided that rather than migrating to the last one still in existence, the project would switch to using PostgreSQL, which is supported directly by the Heroku team.

Large Datasets with Spring Batch

Utilizing Spring Batch for Large Dataset Summarization

Clayton Neff Articles, Databases, Java, Spring, Spring Batch Leave a Comment

Attention: This article was published over 6 years ago, and the information provided may be aged or outdated. While some topics are evergreen, technology moves fast, so please keep that in mind as you read the post.I was recently tasked with summarizing the data of a several-million-row table, and the task proved to be a bit grueling at first. Eventually, …