Short tip this time around. If you are running SQL Server on Linux and connect to it from a Windows system with Management Studio (SSMS), the SQL Agent will be off. If you right click the Agent in SSMS try to get the properties of it, you will receive a lengthy error with this included: …
I’ve posted before about how I don’t run certain services on my Linux system all the time, but rather only when I am working with them. For example, Docker, Pentaho applications, and several database servers like MySQL, MariaDB and now Microsoft SQL Server. The reasons are simple: because I experiment with a variety of technologies, …
This is my second article on using Microsoft’s new Linux version of SQL Server with R. This time, I’ll cover how to use RODBC to gather data from SQL Server. As a bit of background, over the past few months, I have been working to learn R, a free software environment for statistical computing. Its been …
Over the past few months, I have been working to learn R, a free software environment for statistical computing. Its been gaining popularity over the past few years, and Microsoft just gave it a huge boost by integrating R into their Power BI visualization software and the Windows version of SQL Server 2016. Since a …
Greetings all! I have been a bit absent from the blog for the past few months due to a variety of external factors, but I am endeavoring to be more regular on here. This time around you may be aware that Microsoft recently released a Linux version of SQL Server. Because I was testing something …
As I have stated previously when creating ETL workflows, its useful to store the information in a database repository, rather than as individual files on your workstation. This allows multiple users to have access to the information (why recreate the wheel?), it allows you to pull it into your jobs quickly and easily, and you …