Does SQL Server 2019 run on Ubuntu 18.04 LTS?

Yes. Here’s the proof from an output of SELECT @@VERSION:

Here’s a screenshot of me running mssql-cli on the Ubuntu Server virtual machine in question. SQL Server 2019 (CTP 2.3) is running on 18.04.2 LTS. Is it supported by Microsoft? Not right now. The official documentation still requires Ubuntu 16.04, and the release channel
-> Continue reading Does SQL Server 2019 run on Ubuntu 18.04 LTS?

Canadian SQL Saturday speaking events

I am pleased to announce that I will be speaking at two separate SQL Saturdays in March and April of this year. The first event is in Victoria (the capital city of British Columbia, located on Vancouver Island), and the second is in Edmonton, the capital city of Alberta. I will be presenting the same
-> Continue reading Canadian SQL Saturday speaking events

Post image

Dates and Times in SQL Server: AT TIME ZONE

Continuing the series on dates and times in SQL Server and Azure SQL Database, this week we look at the hint AT TIME ZONE. In Azure SQL Database, the regional settings of the database are set to UTC by default. It is also advisable to store dates and times in UTC format on our on-premises
-> Continue reading Dates and Times in SQL Server: AT TIME ZONE

broken glass

Repair SQL Server on Linux after an Ubuntu distribution upgrade

SQL Server 2017 is supported on Ubuntu 16.04 LTS (Long-Term Support), however that version of Ubuntu Linux is now more than two years old, so you may be tempted to update Ubuntu to a more modern release such as Ubuntu 18.04 LTS (Bionic Beaver). Unfortunately (as of this writing), SQL Server 2017 is not supported
-> Continue reading Repair SQL Server on Linux after an Ubuntu distribution upgrade

Introducing Azure Data Studio

[Last edited on 16 February 2019] Note: This is content that was originally written for the book SQL Server 2017 Administration Inside Out, that did not meet the publishing deadline. A new cross-platform tool for SQL Server and Azure SQL Database Microsoft has released Azure Data Studio (known as SQL Operations Studio in preview), an
-> Continue reading Introducing Azure Data Studio

A trillion and one

Joe Obbish wrote an epic post a few weeks ago about loading a trillion rows into a non-partitioned table in SQL Server, using a clustered columnstore index to maximise the compression. (Short version: it’s very slow to query. Don’t do it. Bad things happen. I have an ongoing investigation with Ewald Cress about the evil
-> Continue reading A trillion and one