Microsoft ships Windows Server 2019 Insider build 17744

Windows Server 2019 testers can have their practical a fresh new build today. Microsoft has shipped out build 17744, taking along several Hyper-V improvements and latest features. But as you move the new features and fixes may grab your primary attention, just healthy december known issues to make note of.

What’s new

Installation will no longer be prompts to have a product key. Microsoft Hyper-V Server is unquestionably an enterprise hypervisor that is provided at no additional cost.
Administrators at this moment properly prompted to switch their passwords when initially logging into websites.
Updated installation branding.
Failover Clustering hardening. Failover Clustering not any more requires the utilization of NTLM.
Server Message Block (SMB) hardening. SMB 1.0 is disabled by default.
Windows Subsystem for Linux is created in.
Windows Defender Advanced Threat Protection is made in.
.NET Framework 4.7 is built-in. (Microsoft Hyper-V Server 2016 included .NET Framework 4.6).
Finally, Microsoft Hyper-V Server is often fully managed by Windows Admin Center to supply a modern, remote management solution that integrates with Azure Backup, disaster recovery, and.

Known issues

[NEW] Subsequent a system running Server Core is transitioned (transmogrified) to Server Datacenter-for example, by running the command dism /online /setedition:ServerDatacenterCor /ProductKey:product-key/AcceptEula-the os in this handset is not licensed. Making use of an affected system, the administrator has not been instructed to restart this, and the software indicates that it’s a retail channel version instead of a Generic Volume License Key (GVLK) version, whether the product secret’s a GVLK key. To earn an affected system licensed, run in this article command: cscript c:\Windows\System32\slmgr.vbs /ipkproduct-key.
[NEW] The Italian language (it-IT) text of a End-User License Agreement (EULA) for Hyper-V Server is formatted incorrectly.
The system has an unnecessary utility provider for Windows Defender Application Guard.
Authentication that makes use of Public Key Cryptography User-to-User (PKU2U) to access an SMB volume may end up in an error, STATUS_LOGON_FAILURE, because an invalid private insert the certificate to obtain cluster-created user account (CSUSR) on each cluster node. This disorder can cause cross-cluster migration in cluster sets to fail, plus possibly cause global namespace mappings to fail, meaning virtual machines being unable to access storage.
The Base Filtering Engine service may consume an inordinate capacity of memory after starting and stopping a large number containers.
The Virtual Disk drive Miniport Driver (Vhdmp.sys) can experience a bug check, SYSTEM_THREAD_EXCEPTION_NOT_HANDLED (7e).
When a Windows Defender Application Guard container crashes, the resulting type of dump may be unexpected.
On recent preview builds, database applications is probably not able to initialize a database and fail utilizing a stack overflow or insufficient privileges when your database located on an SMB volume.
Shielded VMs running Linux you should not boot. The loader (LSVMLoad) waits for one passphrase for the boot partition.
Creating or modifying environment variables through the use of setx fails for a system running in the Nano Container (that will be, Nano Server to provide a container image). On a affected system, setx uses a specific path within a registry, HKCU\Environment\, to exist by default. You can work around this issue by changing where variable is kept in the registry, with the help of add the expected registry path before executing setx commands. To specify where the variable be trying to find system-wide use in HKLM as compared with in HKCU, the default, add some /M switch to a setx command. To instead add some expected registry path, run reg add HKCU\Environment before executing setx commands.

Windows Server preview build 17744 is out there to download now via Microsoft. The build is placed to expire on December 14, 2018.

Windows 10 tip: Turn your paid Wi-Fi connection towards a shared hotspot

If you’ve flown with an airline or stayed at the hotel which gives paid Wi-Fi access, you no doubt know the unpleasant decision care for when you first connect: Must enter my credit cards details for this particular exorbitantly priced, excruciatingly slow connection little laptop or with my mobile phone?

Accompanied by a PC running Windows 10, contend with getting lost have to make that choice. Given that your device includes a network connection, you could share that connection securely with as much as eight other devices.

There are all the options you would like by going to Settings > Network & Internet > Mobile Hotspot. One can find four settings to concentrate on here.

To begin sharing your network connection, flip the Mobile Hotspot plunge to the On position.
Choose which connection you will need to share. Throughout the screenshot shown here, Wi-Fi will likely be the only option, nonetheless, you might find yourself in a location where you have multiple connections: wired, Wi-Fi, or mobile data.
Choose learn how to share your connection: over Wi-Fi or Bluetooth.
Change the marriage name, switch the default random password and among your own choosing, and change up the type of connection.

With those steps aside, you can url to your Windows 10 PC as if it were any kind of access point.

Microsoft begins killing there are numerous Windows 8 app store

Microsoft HAS ANNOUNCED that it won’t take any new apps for the Windows 8.x type of the Microsoft Store from 31 October.

Although Windows 8.1 doesn’t reach its end of life date until 10 January 2023, it’s clear that Microsoft should make sure it could actually get away regularly and has already, seemingly, decided to lock the doors, place the blinds down and funds up the tills.

Windows 8.0 has already reached EoL and if you’re still using that, as 1.19 percent of desktop users are, then find the Microsoft Store and upgrade for flip’s sake.

Updates to existing apps will continue supported until 1 July 2023. This is not like we weren’t warned.

The Windows 8 Store never has had all the feature set from the newer Windows 10 equivalent, ; however it has never really mattered because relating to the happy few still toting, the ’tiled’ or ‘metro’ or ‘UWP’ apps were an enforced nice to possess anyway, simply because they are part of a practical system that gave people Vista flashbacks.

On one side, we could consider and say ‘there’s ol’ Microsoft, strangling the different parts of an operating system so that they can encourage upgrades to happen quicker’ but in truth? It’s unlikely many individuals will give a flying fig.

Having the total number of Windows 8.x users ranking at only 6.78 percent right now, just because they did, the bank a tiny, perhaps vocal minority – Windows 7 and Windows 10 have 75.93 % of the market nailed up bewteen barefoot and shoes.

In with the desktop announcement, there exists a second EoL which may affect elsewhere . smaller number of individuals. Windows Phone 8, one of the few last outposts of Windows Mobile, is also winding up its app store – new submissions close on the day that, but app updates would also cease in under a year’s time – July 1st 2019.

Praoclaiming that the only person almost certainly going to care remotely is Kevin, not to put it too finely, when it comes to we know, he’s dead.

Microsoft Rolls Out New Intel Microcode for Windows 10, Server 2016

Microsoft has released multiple microcode updates that mitigate additional variants of these speculative code execution vulnerabilities affecting Intel processors. The patches cover the recently disclosed CPU flaws generically termed Foreshadow or L1 Terminal Fault.

All security gaps paid by these patches are different the Spectre vulnerability revealed on your first times the year. It affects all microprocessors employ branch prediction and speculative code execution to include in performance. In plain terms, the CPU attempts to guess the destination among the code and runs it in memory.

Foreshadow attacks look extract sensitive information from Intel’s Software Guard Extensions (SGX) enclaves, whereas in the the CPU’s L1 cache. It has got two variations that allow an attacker to concentrate on information of this System Management Mode (SMM) or operating platform kernel.

Additionally, they are able to help get data which may be regularly shielded from virtual machines running about the host OS’ Virtual Machine Monitor (VMM).

Patches cover all Window 10 versions

The CPU maker finished validating the microcode revisions and delivered these individuals to industry partners further around the chain to ensure that protection against security exploits targeting its processors.

As a consequence, there are now four new updates offered by Microsoft (KB4346084, KB4346086, KB4346087 and KB4346088) that apply mainly to Windows 10 versions: Creators Update, Anniversary Update, April 2018 Update and RTM.

2 of them, KB4346087 and KB4346084, may also be intended for Windows Server 2016 and Windows Server Version 1803 (Server Core).

Employing patches, Microsoft covers Spectre variant 3a (CVE-2018-3640 a.k.a. Rogue System Register Read), and variant 4 (CVE-2018-3639 a.k.a. Speculative Store Bypass); and L1 Terminal Fault (CVE-2018-3615, CVE-2018-3620, CVE-2018-3646).

Before installing the microcode patches users have got to make sure that the console benefits from mitigation against Spectre Variant 2.

Many of these updates complement the warning to determine websites for Intel and then your device manufacturer for recommendations before installing the microcode from Microsoft.

Although undertake and don’t have known issues, possibly that certain hardware configurations require additional steps absolutely solve the illness.

Microsoft releases new Windows 10 preview with 8 bug fixes in front of October 2018 Update

Microsoft today released a fresh preview for PCs with eight bug fixes. This build comes from the RS5 branch, which represents the Windows 10 update the lender plans to release later this halloween (likely in October 2018). The corporation is also releasing builds from the 19H1 branch, which, becasue it is name indicates, will get to the first part of next year.

Windows 10 will be developed becoming service, meaning it receives new features on a regular basis. Microsoft has released five major updates all ready: November Update, Anniversary Update, Creators Update, Fall Creators Update, and April 2018 Update.

We still don’t comprehend what the next update might be called, though the rumor does it include will be “Windows 10 October 2018 Update.” We perform know the version number – Windows 10 version 1809 – which implies Windows Insiders will likewise see RS5 finalized in September. Assuming this update follows its predecessors, the islands will get it 1 month later.

This desktop build includes the foregoing general bug fixes and enhancements:

Fixed the issue causing PCs to bugcheck (GSOD) when deleting a place folder which is synced to OneDrive from Build 17741.
Fixed an issue that resulted in certain apps crashing when sending Timeline activities.
Fixed an impactful race symptom in recent flights ultimately causing Cortana crashing when launching tips and doing web searches.
Fixed problems resulting in the nearby sharing perhaps the Share UI not visible for a little users despite being enabled.
Fixed an issue that could result in the belongings in the Microsoft Edge window becoming offset looking at the window frame.
Fixed one factor resulting in the spellchecking menu appearing in the wrong place once you right-clicked on a misspelled word in Microsoft Edge.
Fixed a major issue for Insiders using Windows 10 in S Mode recently resulting opening Word from the local Word Online document deteriorating.
Fixed an issue in Narrator so whenever toggling a checkbox making use of braille display and Narrator, the displayed state is becoming updated additionally, the control facts are maintained in the display.

Today’s update bumps the Windows 10 build number for RS5 branch from 17741 (made available to testers on August 17) to create 17744.

This build has four known issues:

You can experience a bugcheck (GSOD) when logging from your user profile or shutting down your PC.
When you apply the Ease of Access Make Text bigger setting, you might consider see text clipping issues, or discover that text rrsn’t increasing in size everywhere.
Narrator sometimes will not read contained in the Settings app as soon as you navigate using Tab and arrow keys. Try switching to Narrator Scan mode temporarily. Just as soon as you turn Scan mode off again, Narrator will read when you navigate using Tab and arrows key. Alternatively, yourrrre able to restart Narrator for you to work around this issue.
After establishing a Windows Mixed Reality headset somebody in charge of on this build with motion controllers, the controllers may wish to be re-paired again before appearing throughout the headset.

Remember, don’t install this on top of your production machine.

Microsoft Specifies End Dates for Windows 8 and 8.1 Apps in Microsoft Store

Microsoft wants developers of Windows 8/8.1 applications from your Microsoft Store to port their apps to Windows 10, additionally it described some coming app deadlines, perhaps for being an incentive.

Specifically, Microsoft titans end alcohol developers to distribute new application submissions in to the Microsoft Store for Windows 8/8.1 or Windows Phone 8.x systems. New app submissions with regard to OSes will end, starting on Oct. 31, 2018, as per a Monday Microsoft announcement

This restriction won’t sign up for existing apps around the Microsoft Store. Developers with existing apps for Windows 8/8.1 or Windows Phone 8.x it is always able to submit application updates after a Oct. 31 date. However, these developers still will undoubtedly be facing some future time limits.

In the case of Windows 8/8.1 apps, the chance to provide application updates in the Microsoft Store will likely to be ending on July 1, 2023, Microsoft’s announcement indicated.

App update support belonging to the Microsoft Store is even shorter for Windows Phone app developers. Microsoft wants to “stop distributing app updates to Windows Phone 8.x or earlier devices” through the Microsoft Store on July 1, 2019.

You could think that Microsoft is punishing Windows Phone app developers prematurely, however, the July 1, 2019 end date actually could be thought of as extra time of sorts. Windows Phone 8.1 actually fell from Microsoft’s support policy on July 11, 2017, consequently Microsoft no longer issues security and quality updates to barefoot. It’s a potentially an unsafe OS that can be used.

In contrast, the Windows 8.1 OS is scheduled to drop out of support on Jan. 10, 2023. Microsoft will permit developers to distribute app updates through the Microsoft Store for around seven months now particular OS’ end date.

In the western world Windows 8, it lost support on Jan. 12, 2016. Windows 8 is often a dead OS, it is therefore surprising that Microsoft continues allowing Microsoft Store app updates to keep on for it till July 1, 2023.

As stated by Microsoft’s App Developer Agreement document, Microsoft can end its agreement with developers at all after giving “at least sixty (60) days’ written notice.” There doesn’t is very much much language from the agreement about Microsoft’s role meant for Microsoft Store app update support, apart from Microsoft tests and certifies the updates. Developers are known as being answerable for submitting app updates and should be not allowed to add new functionality inside their apps except after providing written notice for your customer.

Microsoft’s announcement didn’t describe Microsoft Store support for Windows 10 apps. However, each Windows 10 release is supported with regard to 18 months under Microsoft’s “Windows as being a service” scheme. Developer apps possibly could possibly get removed from the video store if they don’t keep current. However, Microsoft seems not to have crafted a formal policy yet, depending on Rob Sanfilippo, an analyst with independent consultancy Directions on Microsoft, located within Kirkland, Wash.

“There might well be some challenges down the road if Microsoft starts removing applications from Store if she or he don’t aid the latest versions of Windows 10,” commented Sanfilippo via e-mail. “This signifies developers need to regularly make certain you update their applications considering the frequently arriving Windows 10 builds so they can remain published. However, you can find no indication of such a policy yet.”

SQLCLR vs SQL Server 2017, Part 8: Is SQLCLR Deprecated to opt for Python or R (sp_execute_external_script)?

Because of the additional (and annoying) configuration step was required to get SQLCLR Assemblies to load starting in SQL Server 2017, some people were wondering what’s going on with SQLCLR. You are searching for this new restriction stands out as the only real alteration to SQLCLR since SQL Server 2012 (three versions ago), then with (limited) support for languages most notably R (beginning in SQL Server 2016) and Python (starting in SQL Server 2017) being added, it may possibly even mimic SQLCLR is being deprecated (i.e. phased-out) for the sake of these new languages.

Could this be true? There isn’t an official indication, but they can it be unofficially / ” effectively” deprecated? Well, let’s look over.
Investigation

How do you know / determine your feature or technique is deprecated?
Officially Deprecated

Acccording in to the Deprecated Database Engine Features in SQL Server 2017 documentation:
When a feature is marked deprecated, this in essence means:

The feature is inside maintenance mode only. No new changes will be performed, including those affiliated with inter-operability with latest features.
We strive by no means to remove a deprecated feature from future releases to make upgrades easier. However, under rare situations, we might choose to permanently remove feature from SQL Server no matter whether limits future innovations.
For new development work, we don’t recommend using deprecated features.

Just like, in that same documentation, within Features deprecated in some future version of SQL Server section, you can see that ” Extended stored procedure programming” is officially deprecated. And, oddly enough, the Replacement is:
Use CLR Integration instead.

And, inside Database Engine Extended Stored Procedures – Reference documentation, it provides notice start stating:
Important
This feature will be removed within a future type of Microsoft SQL Server. Do not use this selection in new development work, and modify applications that currently of one’s feature as quickly as possible. Use CLR integration instead.

So, ” officially deprecated” retail environment significantly it is marked the result in the documentation, and where applicable, can have up in a performance counter, that include SQLServer:Deprecated Features.
Effectively Deprecated

Remember, there are features which are not marked as deprecated around the documentation (within the ” Deprecated Features” list) and won’t show up in the SQLServer:Deprecated Features performance counter, whilst still being do meet one, or both, of an criteria noted above, namely:

The feature set in maintenance mode only.
The official recommendation is always not operate using the feature in new development.

Take, just like, the OLE Automation Stored Procedures (i.e. the sp_OA* procs, which include sp_OACreate, sp_OAMethod, etc). These aren’t in the ” Deprecated Features” list, nor does the documentation in order recommend not with their company (though, hopefully, begin watching find someone who recommends with them). However, functional indeed being updated (they won’t support data types included in SQL Server 2005 or newer: MAX types, XML, etc), they increment the SQLServer:Deprecated Features performance counter (for instance_name = ‘XP_API’ , no less as of SQL Server 2017). In lieu of using OLE Automation stored procedures, i suggest you either use SQLCLR, or handle the functionality over and above SQL Server.

Another style of an ” effectively” deprecated feature are considered the SQL Server Collations (i.e. Collations having names begining with SQL_ ). These are hold-overs to make available compatibility with pre-SQL Server 2000 (which introduced the Windows Collations: names not starting with SQL_ ). These are also not inside the ” Deprecated Features” list, nor would they increment the SQLServer:Deprecated Features performance counter. However, yet they can be being updated, as well as documentation for SQL Server Collation Name recommends against with them:

SQL Server collations are still supported for backward compatibility, but won’t be used for new development work.

Buyers ., if at all possible, avoid using Collations with names you start with SQL_ 1.
Not Deprecated

Beside each keyword . that does not fit the desciption of ” deprecated” is SQLCLR:

SQLCLR are still being used internally to many newer built-in functions, which follow (both starting in SQL Server 2016):
COMPRESS (but aren’t UNCOMPRESS)
AT TIME ZONE

The sp_execute_external_script stored procedure, previously used to execute R and Python scripts, shouldn’t be a replacement for SQLCLR since it cannot do the examples below:
Use the data types:
XML
DATETIME2
DATETIMEOFFSET
TIME
SQL_VARIANT
HierarchyID
Geometry
Geography
custom SQLCLR UDTs
Create User-Defined Aggregates (UDA)
Create User-Defined Types (UDT)
Create Scalar Functions / UDF
Create Table-Valued Functions (TVF)
Create Triggers (as being a stored procedure, sp_execute_external_script can be executed within a Trigger, but it surely most likely doesn’t have access around the inserted and deleted tables, while a SQLCLR Trigger does)
Return results with named columns (results set columns from sp_execute_external_script each are unnamed, making more food . need the result set columns to experience names, you might use the WITH RESULT SETS clause, which cannot dynamic in case you put the entire call into Dynamic SQL, limiting your ability to return named columns once the columns also datatypes are not known early on)
Access the current SPID and transaction via the in-process connection (i.e. access to local temporary objects, CONTEXT_INFO, SESSION_CONTEXT, etc ; context connection = true; )
Impersonate the caller’s Windows Account (when accessing external resources ; around it is highly unlikely that it would be possible)
Restrict access to particular methods / code (SQLCLR methods are subjected through T-SQL objects which all have their own permissions, whereas sp_execute_external_script is usually xp_cmdshell and the OLE Automation stored levels in that you cannot restrict what code people pass into them).

Finally, if we saw inside ” Officially Deprecated” section above, SQLCLR is considered the recommended option the Extended Stored Procedure API. Additionally, it’s the unofficially recommended replacement for the OLE Automation stored procedures (i.e. sp_OA* ).

Conclusion

Microsoft may be a company like others. Almost always there is more you can do than you have resources there for accomplish everything. You’ll discover budgets, time contraints, priorities, for example. SQLCLR is a feature a good number of others. Some like it, a number of people don’t, and some haven’t ever even noticed it. It is always great for some scenarios, not too great for others. Because of used to solve complex problems rather efficiently, and also in other cases experts agree it is horribly misused to put together slow, convoluted technical debt that is used by anti-SQLCLR curmudgeons as validation inside their opinion.

Sure, you’ll find features that just survive for your version or two (e.g. vardecimal, introduced in SQL Server 2005, and then also deprecated in the following version, 2008). But, there are many of features (even entire products, Phoning assume) that can be valid and useful yet were not improved nearly as much as some need. While this is certainly frustrating, it won’t indicate / imply the death on the feature (or product).

Also, wish company is developed with a new product / feature that might do some of the exact same things being a existing product / feature does not always mean that something is to be replaced. This is also true if the awesome product / feature wouldn’t do all (or most) in the things. I remember back in 2011 or 2012 Microsoft either brought out something in order to do JavaScript on the server, or there was clearly at least talk of this a thing (perhaps TypeScript?). And affirmed, there were individuals were predicting the end of C# / .NET, completely ignoring reality along with implications of replacing it.

So, while you’ll discover things that can typically be improved with SQLCLR, and even though it is frustrating that no resources are increasingly devoted to it, there is not a evidence to suggest that SQLCLR has deprecated, even unofficially.

Installing Ubuntu in Level 1 for this Stairway to SQL Server on Linux

SQL Server 2017 is a first SQL Server version which could be installed on Windows, Linux together with a Docker container. This stairway series serves as a guide for ones experienced SQL Server DBA to own skills info on this platform.

Basically the first article in a very new stairway series that would explore SQL Server on Linux utilizing the most common suggestions and comparing each versions for Windows and Linux.

This series enshrouds the following topics:

Linux installation
Linux commands for DBA
SQL Server installation
Using the brand SQL Server instance
Installing as well as using SQL Server Agent on Linux
HA/DR basics: Log Shipping
Monitoring SQL Server on Linux
Troubleshooting
Advanced HA/DR: AlwaysOn Availability Groups

For this first installment of such a stairway series, let’s experience the first step: the Linux server installation.
Which Linux distribution to get?

SQL Server 2017 is currently supported only on these Linux distributions:

RedHat Enterprise Linux 7.3 o 7.4
Ubuntu 16.04
Suse Linux Enterprise Server v12 SP2

SQL Server 2017 also is supported for a Docker image, which might run on Docker Engine on Linux or Docker for Windows/Mac. The docker image is centered on Ubuntu 16.04.

But, the best idea Linux distribution any type of those supported by SQL Server 2017 ? Well, all depends on what you needs as well as confidence level you may already have with the supported Linux distros.

Today, Linux isn’t necessarily a free OS, but a platform for running business applications. When comparing the best Linux distros, corporate Linux users usually be aware not only about the feature matrix based on that distro, furthermore about support and lifelong of the product.

Red Hat has become the market leaders of Linux distributions. Red Hat Enterprise Linux, or RHEL, entered many data centers via support mainly deals with hardware and software vendors. Today is regarded as a stable, proven foundation that’s versatile enough for rolling out new applications, virtualizing environments, and coming up with a secure hybrid cloud. RHEL 7.x deliver Several of support, with 5 and a half years of Full support, 1 year of so-called Maintenance Support 1 and additional 3 years and half for any Maintenance Support 2.

Ubuntu serves as a free and open source operating system and Linux distribution influenced by Debian. Canonical, the company behind Ubuntu, is known for a mission to make free available to people everywhere, generates revenue out from the sale of professional services for the distribution. New releases of Ubuntu occur each, while long-term support (LTS) releases occur every a couple of years.

Suse Linux Enterprise Server (SLES) works as a Linux-based operating system developed by SUSE. Major versions are released at an interval of 3-4 years, while minor versions (called “Service Packs”) are let go about every 1 . 5 years. From a technical perspective, SUSE Linux a lot more accessible as opposed to the other supported Linux distributions. SUSE is also the most administrator-friendly, through its integrated YaST platform. SUSE is just about the main developers for Pacemaker High Availability, the standard tool for high-availability clusters with all current Linux distributions, used also by SQL Server 2017 to apply AlwaysOn or Failover clustering. Continual support towards the supported version (v12 with SP2) is 31 March 2021.

Out of the SQL Server DBA point of view, you don’t see any significant differences one of many three os and choosing one example of these could be according to your internal knowledge, should your company have definitely a Linux-based machine, and also the list of component . you want to implement with each of your SQL Server.

For this series I decided on to install an Ubuntu server 16.04. Essential, this distribution is well-know for most of the included services like OpenStack cloud services, Ceph scalable distributed file system as well as Metal-as-a-Service (MAAS) tool, which are often used to easily deploy OpenStack or any other server types on bare-metal, all programmatically. We don’t need almost all these services for your purposes, but readily use Ubuntu Server even if it’s easy to setup, well-documented and supported on the list of Linux communities.
Installing Ubuntu

Prepare Ubuntu alone machine, either physical or virtual, work with to the past releases download page: http://releases.ubuntu.com/16.04.4/ simply because that the current release certainly is the 18.04 LTS, is not supported by Microsoft.

I’d like to point out that may be very important to buy a server to choose the long-term support (LTS) release of the Linux distribution, because it’s more stable and supported relating to the years to come by its vendor, with further security or feature updates.

Before commencing the installation, let’s study the prerequisites: Ubuntu needs a minimum of 512MB of RAM and 5GB of disk space, while SQL Server itself requires in any case 3.25GB of RAM and extra 3GB of disk for binaries. Considering that much more have more than space for them to save OS and SQL Server logs, system databases plus some other things, I would not create a server with under 4GB of RAM and 20GB of disk space.

Within later degree of this series we’ll see which guidelines we should attempt to find our new SQL Server on Linux, including a multiple disk configuration to spread our documents, transaction logs and TempDB files. For right now, we are assuming what a very basic server configuration.

Let’s start off with the installation: boot the product from the media containing the ISO file (including an USB key an excellent a physical server) or connect the ISO onto the virtual machine everyone who is creating a virtual server.

During the boot prompt you should be asked to go for a language for your setup.

Via the main boot menu you will choose further choices to install Ubuntu in relation to your system, carry out some check or rescue a broken system. We’ll cover only the basic setting up a fresh Ubuntu server.

The installer asks which language is should use along with keyboard layout (by auto-detecting customized for specific cultures or simply by entering manually).

The installer then discovers the hardware configuration and configures the network settings creating a DHCP server or provide you with the option to configure it manually by for the past and selecting the alternative “Configure the network manually”.

Next, the installer requests the system’s name and puts a new user which will have root access over the sudo utility. You are required to choose and ensure username and password.

For Windows users: allow me to explain some concepts before you go further. Inside a Linux operating system root would be the user name that automatically has access to all the commands and files, prefer the Administrator user during a Windows operating system.

Now of the installation, we are going to providing the system the naming of a new unprivileged user to use for everyday tasks. When folks need superpowers, we’re able still managed a command using the sudo utility, which elevates the privileges onto the root user level and runs site command. It may be like the “RunAs Administrator” command in Windows.

You’ll certainly be asked then to encrypt your home directory, or perhaps something stored files commonly are not readable generally if the computer is stolen.

Fresh articles daily:

Buy the SQL Server Central newsletter and grab a new SQL Server article day by day. Get Database Weekly for just about any roundup of all the biggest SQL news from around the web.
No thanks
Spruce up your SQL Server knowledge daily to comprehend articles by email.

Thank this author by sharing:
1

(not necessarily rated) Rate this Join the discussion Incorporate into briefcase

Installing Ubuntu in Level 1 for this Stairway to SQL Server on Linux

By Danilo Dominici, 2018/08/15
The Series

This information is part of the Stairway Series: Stairway to SQL Server on Linux

It’s an introductory series to installing Linux and SQL Server on Linux.

SQL Server 2017 can be the first SQL Server version that usually can be installed on Windows, Linux as well as Docker container. This stairway series operates as a guide in your experienced SQL Server DBA to accumulate skills information on this platform.

Is actually the first article in a new stairway series that would explore SQL Server on Linux making use of the most common recommendations and comparing their versions for Windows and Linux.

This series will pay for the following topics:

Linux installation
Linux commands for DBA
SQL Server installation
Using the brand new SQL Server instance
Installing and ultizing SQL Server Agent on Linux
HA/DR basics: Log Shipping
Monitoring SQL Server on Linux
Troubleshooting
Advanced HA/DR: AlwaysOn Availability Groups

In the first installment of it stairway series, let’s brows through the first step: the Linux server installation.
Which Linux distribution to buy?

SQL Server 2017 is currently supported only on these Linux distributions:

RedHat Enterprise Linux 7.3 o 7.4
Ubuntu 16.04
Suse Linux Enterprise Server v12 SP2

SQL Server 2017 just happens to be supported just like a Docker image, that will run on Docker Engine on Linux or Docker for Windows/Mac. The docker image will be based upon Ubuntu 16.04.

But, the best Linux distribution a kind of supported by SQL Server 2017 ? Well, the treatment depends on what you needs together with the confidence level you can show with the supported Linux distros.

Today, Linux is not only just a free OS, but a platform to operate business applications. Comparing the best Linux distros, corporate Linux users usually be cautious not only about the feature matrix backed up by that distro, but additionally about support and lifetime of the product.

Red Hat has become market leaders of Linux distributions. Red Hat Enterprise Linux, or RHEL, entered many data centers via support discusses hardware and software vendors. Today may be a stable, proven foundation that’s versatile enough for rolling out new applications, virtualizing environments, and preparing a secure hybrid cloud. RHEL 7.x deliver 5 years of support, with 5 and a half years of Full support, 1 year of so-called Maintenance Support 1 and further 3 years and half for your Maintenance Support 2.

Ubuntu is seen as a free and open source operating system and Linux distribution dependant upon Debian. Canonical, the company behind Ubuntu, is known for a mission to make open source available to people everywhere, generates revenue out of your sale of professional services near the distribution. New releases of Ubuntu occur each, while long-term support (LTS) releases occur every two yearsrrr time.

Suse Linux Enterprise Server (SLES) serves as a Linux-based operating system produced by SUSE. Major versions are freed at an interval of 3¡§C4 years, while minor versions (called “Service Packs”) are let go about every Eighteen months. From a technical perspective, SUSE Linux is more accessible when compared with the other supported Linux distributions. SUSE is always the most administrator-friendly, as a result of its integrated YaST platform. SUSE is regarded as the main developers for Pacemaker High Availability, the standard tool for high-availability clusters in a variety of current Linux distributions, used also by SQL Server 2017 to apply AlwaysOn or Failover clustering. Lasting support to your supported version (v12 with SP2) is 31 March 2021.

Belonging to the SQL Server DBA point of view, there’s no significant differences among the three operating-system and choosing one particular could be dependant on your internal knowledge, when the company already a Linux-based machine, as well as list of a pleasant feature is you want to implement along with your SQL Server.

For this series I made the decision to install an Ubuntu server 16.04. Essentially, this distribution is well-know for some of the included services like OpenStack cloud services, Ceph scalable distributed file system as well as Metal-as-a-Service (MAAS) tool, that is used to easily deploy OpenStack or any other server types on bare-metal, all programmatically. We don’t need a lot of these services for the purposes, but you are able to use Ubuntu Server since it’s easy to setup, well-documented and supported one of several Linux communities.
Installing Ubuntu

To place Ubuntu with your machine, either physical or virtual, you must use to the past releases download page: http://releases.ubuntu.com/16.04.4/ considering that that the current release is most likely the 18.04 LTS, is not supported by Microsoft.

Let me point out that is very important to get a server to choose the long-term support (LTS) details the Linux distribution, because it’s more stable and supported for this years to come by its vendor, with further security or feature updates.

Before you begin the installation, let’s take a look at the prerequisites: Ubuntu swallows a minimum of 512MB of RAM and 5GB of disk space, while SQL Server itself requires at the least 3.25GB of RAM and other 3GB of disk in the binaries. Considering that much more have perhaps space in OS and SQL Server logs, system databases and certain other things, I wouldn’t create a server with only 4GB of RAM and 20GB of disk space.

For a later quantity of this series we’ll see which tips we should cover our new SQL Server on Linux, along with a multiple disk configuration to spread our information, transaction logs and TempDB files. In the meantime, we are assuming this is a very basic server configuration.

Let’s begin the installation: boot the gps device from the media containing the ISO file (as an example an USB key if you use a physical server) or connect the ISO towards virtual machine everyone who is creating a virtual server.

About the boot prompt you should be asked to purchase a language for those setup.

Belonging to the main boot menu you can easily choose further options to install Ubuntu with your system, complete a few check or rescue a damaged system. We’ll only cover the basic installation of a fresh Ubuntu server.

The installer asks which language is should use additionally, the keyboard layout (by auto-detecting design or by entering manually).

The installer then discovers the hardware configuration and configures the network settings by having a DHCP server or supplies you the option to configure it manually by moving back and selecting the opportunity “Configure the network manually”.

Next, the installer requests for the system’s name and installations a new user that could have root access through your sudo utility. You need to choose and ensure username and password.

For Windows users: okay explain some concepts beneficial . further. For a Linux os root will be the user name that automagically has access for all commands and files, which includes Administrator user for a Windows operating system.

By now of the installation, we are going to providing the system the naming of a new unprivileged user useful for everyday tasks. Whenever you need superpowers, we are able to still manage a command utilizing the sudo utility, which elevates the privileges about the root user level and runs specific command. Chose to like the “RunAs Administrator” command in Windows.

That you are asked then if you wish to encrypt your home directory, or perhaps something stored files usually aren’t readable in cases where the computer is stolen.

After being required to choose the timezone, you really are entered into the disk layout configuration. We all have four choices, which also has a guided partitioning method as well as manual one. I decided they would use the entire disk too up a Logical Volume Manager (LVM). Logical Volume Management serves as a storage device management technology delivers users the to pool and abstract the physical layout of component storage devices for easier and flexible administration. This is now like gathering existing storage devices into groups and allocate logical units out of your combined space when needed.

Logical volumes will offer meaningful names like “databases” or “backups”. Volumes could be resized dynamically as space requirements change and migrated between physical devices during the pool within a running system or exported easily. LVM has also advanced features like snapshotting, striping, and mirroring.

The Ubuntu base system installation then starts. Tough phase from the installation process, you may be given the possiblity to select additional software to setup, by selecting predefined collections of software (one example is DNS server or OpenSSH server) to quickly developed your computer to carry out various tasks. You’ll be able to simply “continue” and skip an expert, as we just have to have a base system.

A final step requires us place in the GRUB loader, and we all are ready to use our new server.

GRUB or GRand Unified Bootloader, is usually a multiboot boot loader. A boot loader certainly is the first software program that runs each time a computer starts. It is responsible for loading and transferring control on the operating system kernel software (including Windows or Linux). This could possibly add the flexibility, as one example, to run different operating-system from the same physical (or virtual) disk and even to run specialized Linux distributions (for example to troubleshoot an unsuccessful system so they can run diagnostic tools).

Right after the installation process, excellent asked to reboot the gps device to start within the new Ubuntu server.

Perhaps you have realized, this process is really straightforward and doesn’t require particular skills. There are a variety of options you can change by selecting the advanced installation, and we’ll examine some of them when we’ll be expounding on the best practices along with perfomance tuning.

Now, let’s log in and analyze our new Linux machine.

After rebooting the server, when prompted type sqladmin because username we have been using to go into the system and so the password you provided all through setup to input the machine.

Quite possibly the most evident differences moving from Windows to Linux is case sensitivity, specially creating or navigating a folder structure. The directory “Data” is not the equal to “data” !

Once logged in, you can easliy use a substantial amount of commands, which is available from the command-line interpreter, named shell), our company is using. The Bash shell is considered the most commonly used (yet you can obviously change it whenever you want).

Let’s wait and watch some example. Using the command pwd, short for print working directory, you are able to show where we are going to located in the directory tree and then suddenly moving, here is an example, to another directory utilize the cd command (change directory), like we all do in a Windows command prompt.

You can easlily create or edit written documents from the command shell by utilizing the program vi (visual editor), which will be included in Linux/UNIX os in this handset since its beginning, or switch to a “modern” editor like nano or vim.

We’ll converse about Linux commands within a future article: this brief introduction was intended simply show you the right way to log in the newly installed system and appearance if it works.

To be able to know more over the Ubuntu Server Linux and the do a particular task, use the official documentation site at help.ubuntu.com and then click 16.04 LTS version, which is supported edition at the time we are offering this article.
Summary

We learned techniques to setup a Linux machine with Ubuntu Server 16.04, taking into account which prerequisites we do need to shift to the next step: the SQL Server 2017 installation.

Microsoft’s new Xbox avatars available right now on Windows 10 PCs

Microsoft first commenced testing its new and various Xbox Live avatars with Xbox owners during June. The software maker is making these in shops to all Windows 10 users today in advance of their official release in October. A whole new Xbox Avatar Editor is downloadable with the Microsoft Store, granting Windows 10 gamers access in to the new avatars.

As you move the new avatars are rather basic at this time, can you fully customize your internet character with frame options, clothing, and props. Microsoft is interested to add accessories, props, moods, clothing, look categories in the foreseeable future, alongside more content post avatars are broadly available in October. Microsoft’s Xbox Avatar Editor for Windows 10 helps you to customize body, face, hair, and various options. Most of the customizations include color pickers to personalize things further.

Microsoft is displaying the fresh avatars on gamertag profiles and infrequently using them within the main Xbox One dashboard to celebrate friend activity. It’s uncertain how avatars will likely be displayed for Windows 10 users throughout the Xbox app, but PC gamers get the chance to use them for their profile images.

AMD’s New Threadripper 2990WX Considerably faster On Linux Than Windows 10

AMD’s monster 32-core Threadripper 2990WX CPU released this past week to mostly positive reviews alongside a bit of criticism. When pitted against its closest Intel rival — the Core i9 7980 XE — it offers a superior mostly superior performance along with a clear value proposition, especially if tapping software that thrives on high core and thread counts. Gifted it stands while the world’s fastest CPU.

But several use-cases it’s even faster when you’re using it with Linux.

Phoronix has published a compelling suite of benchmark results for AMD’s Threadripper 2990WX that pit Windows 10 Pro against a small number of Linux distributions like Ubuntu and openSUSE. In almost every single test, Linux emerges for the winner. Almost all their CPU-intensive tests are compatible across Windows, Linux and MacOS and same system was utilized with identical hardware settings.

More extreme case shows all four flavors of Linux downright embarrassing Windows within 7-Zip compression test (above), performing the job about two times as fast when compared to Windows 10 Pro.

Ok, so creative professionals probably doesn’t base their $1800 CPU purchase (or their OS choice) over a merits of file compression speed. Big event to say it isn’t really a damning result. Let’s consider something more important, for instance 3D graphics pipelines with Blender.

Again, every Linux flavor bests Windows 10 by a healthy margin. This is only one of four separate Blender benchmarks which yielded roughly the very same results.

Times also measured FLAC audio encoding (Linux won, but barely), H.264 video encoding (Linux won with large margin) with a healthy number of other benchmarks.

Not tested: Adobe products. . .

However, this isn’t articles encouraging a person to maximize your investment by switching to Linux and potentially your own workflow. However, professionals who can aquire the job done on Linux will be receiving it done significantly faster.

That is because Windows has poor support for Non-Uniform Memory Access setups. The advantages NUMA, however, are available for certain workloads. In discussing the Phoronix results, NotebookCheck observes the foregoing:

“In all Blender tests, the performance on Linux was clearly better by definitely 15% compared to Windows 10. However, in single-threaded tests for example FLAC Audio Encoding and BLAKE2, the Threadripper 2990WX performed almost equally across Windows 10 Pro and Linux. FFmpeg also favored performance under Windows 10 versus most other Linux distros. Therefore, these results find a way to indicate a scalability issue of Windows 10 Pro round the many CPU cores in heavily multi-threaded workflows.”

We’ll obviously take this moment to point out that the feature of Threadripper is its capability to chew up a workload your extreme thread count. At this stage in the rooms, it’s beyond clear that Linux extracts the most impressive performance with regard to types of workloads. That’s doubtful news for your Linux community, yet it’s an eye-opener in my closet.

If each of this piqued your interest, definitely look into the entire feature over at Phoronix, and stay tuned for his follow-up results as he’s currently running another battery of tests.