Enable Linux SQL Server Agent

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:
SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server.

All good and normal. So how do you turn SQL Agent on?

Continue reading “Enable Linux SQL Server Agent”

Shell Script to control services on Linux Mint (especially SQL Server)

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, I don’t want to dedicate resources unnecessarily and there may often be conflicts such as web server interfaces using the same ports. So to alleviate some of those problems I generally disable services and start them when necessary.

To do that I usually create Bash scripts to start and stop the services, and save those in a named location in /opt that is associated with the server application. I would have two scripts, one to start and one to stop, but since I’ve had some time lately I’ve worked up a method to do this in one script. Below is a script I drafted to start and stop Microsoft SQL Server on Linux. I saved this to the /opt folder where the SQL Server components are installed and then created a Launcher shortcut to add it to my menu. Now I just select that option in the menu, and I see the current status of the server, and I can start it or shut it down as need be.

Its heavily commented to provide information, so use it as a source for yourself if you are running on Debian based systems.

Continue reading “Shell Script to control services on Linux Mint (especially SQL Server)”

Access a Raspberry Pi with Remote Desktop Protocol (RDP) and REMMINA

    I am a huge proponent of Open Source software, and when I have the choice between a proprietary application or an open source one with similar features, I’ll generally opt for the open source program unless there is a compelling reason not to. In the case of remotely accessing PCs, I prefer to use RDP software over VNC. While RDP is a proprietary protocol developed by Microsoft, and VNC is open source, I find RDP easier to use for remotely accessing GUI based systems. If I need to access a non-GUI system, I do fall back to SSH though.
   Recently I have been experimenting with Raspberry Pi computers. (I am working to setup a Hadoop cluster, and will hopefully write more about that in the future.) The initial setup of the PI’s includes updating the package lists and installing any newer versions of the included software, setting a static IP and then installing xRDP. After that I use my Linux Mint laptop to make any further changes after I have them headless in the rack using REMMINA , which supports SSH, VNC and RDP.
    Installing xRDP on the PIs is pretty straightforward. Here is how to do that:

Continue reading “Access a Raspberry Pi with Remote Desktop Protocol (RDP) and REMMINA”

Use Linux SQL Server with R (ODBC)

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 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 in the Windows version of SQL Server 2016. Since a good deal of my work involves connecting to Microsoft SQL Servers  its a good opportunity to show how to connect to a SQL Server installed on Ubuntu from R using ODBC.

For this tutorial, I am going to assume that you already have R installed. For my purposes,  I am running R on the same Ubuntu machine as the SQL Server. If you need instructions for installing SQL Server on Linux, Microsoft has provided a write-up already. So now let’s get started.

Continue reading “Use Linux SQL Server with R (ODBC)”