A Fine Slice Of SQL Server
Rob Sewell confirms that Test-DbaLastBackup in the dbatools kit works for Linux:
I have written about Test-DbaLastBackup in posts here, here and here. They have been Windows only posts.
With SQL Server vNext CTP 1.4 now available and providing SQL Agent capability on Linux, I wrote here about using Ola Hallengrens scripts on Linux SQL Servers so can Test-DbaLastBackup work with Linux?
It’s a short post but good to know.
Comments closedFrom this point we will work directly with SQL Server.In order to establish connection you have to run following script.The most important are 2nd and third lines:– In second line you have to provide your SQL Server Instance address, by replacing “<your_server_instance>” by something like “192.168.58.11” or “192.168.58.11\MSSQLSERVER,1433”– When second line runs it will ask you for SQL Server credentials !!! So, you have to enter SQL user name and it’s password.
Slava does note some limitations at present, but a lot of the functionality seems to be there.
Comments closedNow the jobs are not going to run as they are as they have CmdExec steps and this is not supported in SQL on Linux so we have to make some changes to the steps. As I blogged previously, this is really easy using PowerShell
First we need to grab the jobs into a variable. We will use Get-SQLAgentJobHistory from the sqlserver module which you need to download SSMS 2016 or later to get. You can get it from https://sqlps.io/dl As we are targeting a Linux SQL Server we will use SQL authentication which we will provide via Get-Credential and then take a look at the jobs
It’s not “point, click, done,” but Rob shows you certainly can do it.
Comments closedFinally, the fix we all been waiting for has arrived with the newest release of PowerShell version v6.0.0-alpha.17. Now, when you installed the Ubuntu 16.04.1 version of PowerShell 6 in Bash on Windows 10, it works this time.
Thanks God! No more crazy cursor screen issues going on when you type commands and/or display results.
Max also shows how to install the latest version of Powershell in Bash on Ubuntu in Windows 10.
Comments closedRob Sewell has an interesting post on cross-platform configuration using dbatools in Powershell:
This weekend I set up some SQL vNext virtual machines, two on Windows and one on Linux so that I could test some scenarios and build an availability group.
IMPORTANT NOTE :- The names of dbatools commands with a Sql prefix WILL CHANGE in a later release of dbatools. dbatools will use Dba throughout in the future as the sqlserver PowerShell module uses the Sql prefix
I used PowerShell version 5.1.14393.693 and SQL Server vNext CTP 1.3 running on Windows Server 2016 and Ubuntu 16.04 in this blog post
There’s some fancy footwork in this post; if you’re looking for ways to compare instance configurations (specifically, sp_configure settings), check it out.
Comments closedSteve Jones shows how to upgrade SQL Server on Linux to the latest version:
I saw this week that there was a new CTP (v1.3) of SQL Server v.Next. I haven’t had a lot of time to work on the Linux version lately, but I thought I’d try and see how well the upgrade went.
There’s an install and upgrade page at Microsoft you can use, but on Ubuntu, things are easy. First, connect to your system and run this:
sudo apt-get updateThat will download updated packages and get the system ready. you can see that I have a lot of stuff to update on this particular system.
One small change I’d make to that script in the snippet is sudo apt-get update && sudo apt-get upgrade. They do different things, both of which are useful. I do hope that Microsoft keeps with the Linux-friendly upgrade process when it comes to CUs and SPs.
Comments closedThe SQL Server team has announced a new CTP:
Key CTP 1.3 enhancement: Always On Availability Groups on Linux
In SQL Server v.Next, we continue to add new enhancements for greater availability and higher uptime. A key design principle has been to provide customers with the same HA and DR solutions on all platforms supported by SQL Server. On Windows, Always On depends on Windows Server Failover Clustering (WSFC). On Linux, you can now create Always On Availability Groups, which integrate with Linux-based cluster resource managers to enable automatic monitoring, failure detection and automatic failover during unplanned outages. We started with the popular clustering technology, Pacemaker.
In addition, Availability Groups can now work across Windows and Linux as part of the same Distributed Availability Group. This configuration can accomplish cross-platform migrations without downtime. To learn more, you can read our blog titled “SQL Server on Linux: Mission Critical HADR with Always On Availability Groups”.
That’s a big headline. In the Other Enhancements section, I like resumable online index rebuilds as well.
Comments closedMeet Bhagdev announces a new version of the SQL Server ODBC driver for Linux:
Added
BCP API support
- You can use functions through the ODBC driver as described here on Linux.
Support for user-defined KeyStoreProvider for Always Encrypted
- You can now user-defined/created AE Column Master Key keystore providers. Check out code samples and more information here.
Ubuntu 16.10 support
- Developed a package Ubuntu 16.10 for an apt-get experience.
Dependency on the platform unixODBC Driver Manager instead of the custom unixODBC-utf16 Driver Manager
This avoids conflicts with applications/software that depends on the platform unixODBC Driver Manager.
No groundbreaking additions, but there are a couple nice fixes in the update.
Comments closedSlava Murygin troubleshoots connectivity issues with SQL Server on Linux:
After you enter SA password you have to get “vNext” version of your SQL Server.
If you did not get the correct response you might have following problems:
I) Wrong SA password. To fix it, just re-configure SQL Server.
II) SQL Server Tools are not installed.
III) Typo. Check your syntax.
The troubleshooting process is a bit different from SQL Server on Windows, but it’s still pretty straightforward.
Comments closedMax Trinidad goes all the way with installing an Ubuntu environment on Windows:
It’s a known fact, if you install PowerShell Open Source in Windows 10 Bash subsystem, that it won’t work correctly. As soon as start typing $PSVersionTable and press enter, the cursor goes to the top of the screen. And, you keep typing and it gets very ugly.
Now, what if I tell you, I found the way to run PowerShell Open Source without any of these issues. Just like running it like it was installed in a Linux environment. No issues with the cursor going crazy and able to page up and down.
There are quite a few steps here, but Max lays them out clearly.
Comments closed