How to build a shiny new SQL server with PowerShell 5.1 and Visual Studio 2017

On the eve of Windows 10’s general availability, Microsoft has announced its latest version of its shiny new sql server tool for the Windows platform, SQL Server 2017.

SQL Server 2018 is the first release that Microsoft is offering for free, but there are still some caveats to this release.

The new SQL Server will be a completely new SQL language and SQL Server can’t run natively on Windows 10 Mobile devices.

The next release, SQL 2017, will have the ability to run native apps.

But these caveats don’t apply to the shiny new version of SQL Server.

For those that are already running Windows 10, these caveats are less important than the fact that you can now install the shiny version of the SQL Server on Windows Server 2016 and 2016 R2 machines without requiring a SQL Server 2016 license.

This is a welcome addition to the Microsoft SQL Server ecosystem and will hopefully help you get started building your next big project. 

Here’s how to install SQL Server, and the full list of new features. 

Download the Windows Server 2018 download, unpack the files, and run the following command to install the new SQL Engine.

Get-CimInstance -Identity $id -Name SQL Server -ConnectionUri https://s3.amazonaws.com/sqlserver/SQLEngine-1.0.5-Win32-en-US.x86.rpm Get-SqlServer -Identifier $id Install-SqrtFileServer -File $file.sql Server.exe Start-Service SQLEngineServerService Start SQLEngineServerServerService on your server