This is a 2-part blog post, the first in the series can be found on the Microsoft SQL Server blog here. The recently released SQL Server 2019 on Linux includes several updated features, including replication, support for Microsoft Distributed Transaction Coordinator, and Change Data Capture (CDC) support. If you’re running SQL Server 2017 on Linux, these are great reasons to upgrade to SQL Server 2019 to take advantage of these updates. Microsoft SQL Server 2019 was subjected to significant testing and supported to run on several Linux distribution platforms: Red Hat Enterprise Linux (RHEL), SUSE Linux Enterprise Server (SLES), and…
-
-
So you want to run mssql-cli on Ubuntu Linux, but you received a number of errors and even if you got through some errors, you’re still stuck? I’m here to try to help you get through them and hopefully I’ve captured them all. Trust me, the Oracle DBAs have been here- our databases and tools failed for a very long time until Linux administrators came to know what we needed and started to build us the images with the correct libraries and versions we needed, so we feel your pain! The easiest scenario for many to deploy SQL Server 2019…
-
I enjoyed the opportunity to test out my PASS Summit shell scripting session at SQL Saturday Denver. It was the first run on it and Glenn Berry sat in my session. Afterwards, this wise and long-standing member of the community had a very valuable piece of constructive criticism- change the background on my bash terminal for Azure Cloud Shell, as the black background and colors could be troublesome for some attendees. I agree with him- you never know what the projector quality will be, the lighting in the room, color-blind attendees or other factors that could impact the readability of …
-
In the previous blog posts, we learned how to set up the first part of a standard shell script- how to interactively set variables, including how to pass them as part of the script execution. In this next step, we’ll use those to build out Azure resources. If you’re working on-premises, you can use this type of scripting with SQL Server 2019 Linux but will need to use CLI commands and SQLCMD. I will cover this in later posts, but honestly, the cloud makes deployment quicker for any business to get what they need deployed and with the amount of…
-
Almost every Linux or Unix person has seen the help forum post from a novice looking for an answer to a frustrating problem and the arrogant fool that responds with “Just type in rm -rf / and it will fix the problem.” For anyone who is part of the “do no harm” technical community, this can make us wish for a way to revoke the arrogant fool’s privileges to the internet— permanently. Recycling Commands This leads me to a great post from Carlos Robles this last week on using aliases with docker commands. As with many command line utilities, certain…
-
Hello from Atlanta, where I’m preparing for tomorrow’s SQL Saturday and arrived for the great news announcing this year’s PASS Summit 2019 Learning Pathways. These sessions are two or more sessions to provide a more complete learning opportunity for the attendee. I’ll be part of two of these pathways: Technical Leadership: Becoming a Technical Leader with Denise McInerney Linux for SQL Server Professionals: Empowering the SQL Professional with Linux Scripting I’m looking forward both to the first, a leadership talk, as we rarely see a focus on how to forge a path in a technical career without often sacrificing our…
-
Azure Directory is available with Linux SQL Server 2019 in Preview and as I was setting it up in my Azure environment on a Linux Red Hat 7.3 VM, I was, as many are, happy that they list the commands for the Azure CLI to set up authentication with Azure Directory, but was concerned, that with so many new to Linux, that they didn’t describe in the steps WHY we were running certain commands or setting best practices around Linux database server design. The setup expects that you already have a Linux VM and SQL 2019 already up and running.…
-
As I dig deeper into Linux for the SQL Server DBAs and for Oracle HotSos, I’m digging into DIG. Yeah, I went there with that first sentence…. What is DIG? DIG stands for Domain Information Groper, (no, not that kind of groper…) and it’s an important part of deeper Linux learning for all database technologists. You can’t connect to data if you don’t know how to get from point A to point B and DIG is the utility to help you gather information surrounding DNS. DIG allows the user to gather deep information using both command line arguments and batch…
-
Yes, there’s a Part III! You’re going to have to start scripting and now that you know a few VI/VIM commands, lets talk beginning scripting with shell. In our example below, we’re going to start a new project called “test”. For this, the requirements are: create a new folder off of the /u01/scripts directory create a new file called test.sh inside the testdir directory ensure it uses bash as our chosen shell # cd /u01/scripts # mkdir testdir # cd testdir # touch test.sh # ls test.sh # pwd /u01/scripts/testdir As you can see, I’ve now fulfilled the first two…
-
So more than one person contacted me about my last post and stated that they didn’t see a problem with SQL Server on Linux running as the root user. Me: Although enhancements have changed Windows installations for applications to run with a unique user, I created a mssql OS user even back on SQL Server 2000 on Windows as I had a tendency to use similar security practices for all database platforms as a multi-platform DBA. With that being said- yes, it introduced complexity, but it was for a reason: users should be restricted to the least amount of privileges…
-
I’m here for the last day of UKOUG Tech17 and it’s been an awesome event. This is my first time to this event while in Birmingham and although quite the party town on the weekends, its a great city to have an event like UKOUG’s trio of events during the week. I was welcomed to great turnouts to both my presentations and then enjoyed numerous sessions by other’s, such as Richard Foote, Jonathan Lewis, Roger MacNicol and others that one might not get a chance to see in at most US Oracle User Group events. My biggest challenge in my…
-
So while finishing up my slides for the Microsoft Pass Linux Marathon webinar on Dec. 13th, Tim and I started to discuss the apples vs. oranges comparison of SQL Server on Linux process management vs. an Oracle instance. We discussed the differences one might expect to see using different tools with the two database platforms and the first question surrounded information pmap would provide. We commonly use pmap to map out processes, including child and sub-processes of a particular PID. As my current images have multiple database platforms on each of them, I quickly spun up a Docker image of…
-
So we’ve covered a few basics of a Linux host in Part I– The File System Users, groups Basic Commands with basic arguments And file and directory permissions Hopefully, what I share next will build on the first post and enhance your knowledge as you move forward with Linux. Reading the contents of a directory, gathering information on files and locating files are some of the most common tasks a DBA will perform as they work on a server. Many of the following commands require you to “pipe” a second command onto the first. This is done by joining the…
-
For the Oracle DBA, Linux is life. When I was at Oracle, Linux projects were the easy part of my job, unlike the ones on Windows, AIX, HP-UX and at times, even Solaris. You knew the Linux ones received the most love from development, had the most time towards patching and received attention if there was a bug. History Linux was introduced in 1991, thanks to Linus Tovalds and has been in active development, with introduction of different “flavors” of the OS over the years. As many folks know, Linux was carved out of the GNU open license project, which…
-
I thought I’d do something on Oracle this week, but then Microsoft made an announcement that was like an early Christmas present- SQL Server release for Linux. I work for a company that supports Oracle and SQL Server, so I wanted to know how *real* this release was. I first wanted to test it out on a new build and as they recommend, along as link to an Ubuntu install, I created a new VM and started from there- Ubuntu Repository Challenge There were a couple packages that were missing until the repository is updated to pull universe by adding…