In this blog post, I will demonstrate a technique to query the status of a SQL Server Agent job that executes the SSIS package. SQL Server Agent scripts are asynchronous in nature. This can make it difficult to make code decisions based on the execution status of a script of this type.
In this blog, we will build a flow rate prediction algorithm for the Norfork River in Arkansas. Both farmers and recreationists are heavily dependent on the flow rate of the river. As the river flows faster, the risk of flooding increases and flooding can destroy crops for farmers and ruin vacations for tourists.
My goal with this flow rate prediction algorithm was to give a better idea of what the next 4 days of river flow will look like. Below, I will discuss the data science process that I underwent to make these predictions.
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.
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.
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.
