UPDATE: Technical Difficulties – Resolved

Update: I never promised to be quick about restoring the contents, but here we are 3 months and change later, back up and running. ūüôā¬† I have removed some of the older posts, mostly older photographs, and reviews of things I’m no longer interested in. The focus here now will probably be a bit narrower than its been in the past, and shifting a bit. Hopefully it remains interesting for some.

I’m experiencing some technical difficulties with this website. If there is older content you are interested in seeing, please check the Internet Wayback Machine at¬†https://web.archive.org/web/*/edpflager.com.

Since this is a non-commercial site, I’ll attempt to get my older content restored as soon as possible.

 

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)”

Map Windows host location to Linux container in Docker

I’ve been working more with Docker on a Windows PC lately. With the more recent versions of Docker, the application runs much better and there is task bar control panel for managing the processes. If you are interested in trying out Docker and don’t have a Linux machine to work with, go download the Windows Stable Community edition which was recently updated to 17.09.0.

Continue reading “Map Windows host location to Linux container in Docker”

Photo Break – Ambassador Bridge – Windsor

I attended a Photography workshop on Friday evening in Windsor, Ontario, Canada just across from Detroit. This was one of my top three images that I got. I like it partly because the dock is lit so well. That was an accident, as I had the camera on a thirty second exposure, and near the end of it, a car’s headlights near the dock came on.

NAT:HNS error with Docker SQL Server container on Windows10

As with many things I post here, this article was the result of a problem I encountered, and how to resolve or work around it. I have been working with Docker on Windows and was attempting to run a container provided by Microsoft that included SQL Server. The process is fairly easy, just pull the image and run it with the appropriate command options. Unfortunately, that didn’t work. When I used the supplied command to run the container, I would get this error message:

Error response from daemon: failed to create endpoint <container name> on network nat: HNS failed with error. Unspecified error.

I spent several hours working this out over the past few days, doing web searches and trying various ideas. Lots of people experiencing the problem, but no solutions. Eventually I figured out a solution. Hopefully this helps someone else. The error above I found out indicates a problem with the default ‘nat’ network that Docker creates when you install it.¬†¬†By using the default NAT network, you basically have a private network on your docker host.

You can attempt to delete that network by opening PowerShell as Administrator. (Microsoft has a good write-up on networking for Windows containers here.) Enter the following command to see a list of the virtual networks defined on your PC:

Get-NetNat

Stop Docker using the whale icon on your notification area, by right clicking on the whale and choosing Quit Docker from the menu. Then run this command:

Remove-NetNat

Enter “Y” at the prompt to remove all networks. Now restart Docker. ¬†If this doesn’t work for you, read on.

Continue reading “NAT:HNS error with Docker SQL Server container on Windows10”

Photo Break – Land Between the Lakes KY

 

Spent some vacation time last week in western Kentucky, near the Land Between the Lakes National Recreation Area. There are two large lakes with a peninsula between them making it a boater’s paradise¬† and there is some great scenery. This picture was take at one of the many marina near the Kentucky Dam at sunset.

Picture copyright by me, so do not use without permission.

Running Kettle (Pentaho Data Integration) on Mac OSX 10.12 Sierra

A new version of Mac OSX and a new version of Pentaho Data Integration (aka Kettle) but the same old problem getting Kettle to run. Apple tries to keep their operating system locked down and secure, so if you download applications from the Internet that aren’t from the Apple App Store, the files are quarantined.

With the update to Sierra, the quarantine process has been “improved”. Keep reading to see how to do it!

Continue reading “Running Kettle (Pentaho Data Integration) on Mac OSX 10.12 Sierra”

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)”

Use Linux SQL Server with R (JDBC)

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 good deal of my work involves connecting to Microsoft SQL Servers and a Linux version of SQL Server is now available, its a good opportunity to show how to connect to a SQL Server installed on Ubuntu from R, using a JDBC connection.

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 (JDBC)”