SQL Server 2019 CTP 3.0 is Moving Right Along

I don't know how close, but SQL Server 2019 must be almost done. If you have been paying attention, you will notice that CTP 3.0 was released this past week. There are a few changes, but this note is the big one for me: "For customers in the Early Adoption Program, CTP 3.0 is the first release where you’re able to run SQL Server 2019 in production." This is reflected in the release notes as well. The notes also reflect that in-place upgrades of SQL Server 2012-207 are now supported. No upgrades from other CTPs, but that's expected.

It seems a lot of work has been done, and some problems have been fixed. Notably, a new compiler was used with CTP 2.1 that had some issues with conversion scenarios. Those appear to have been cleaned up. There are limitations with UTF-8, as well as some issues with Secure Enclaves. I can't imagine the platform will RTM without Secure Enclaves, but what do I know. SQL Server 2005 was released without Database Mirroring working, with the issues ironed out in SP1 shortly after release.

There are some other enhancements that are a bit surprising for me. I expect that Big Data Clusters are evolving, and I see some people testing them. One item that caught my eye in the blog was this: "Database administrators can register new external language extensions on any OS platform supported by SQL Server." Apparently dotnet core, Go, and other languages are somehow being supported. I haven't dug into what this means, and it provides some flexibility, but it also worries me people will try and get things like JavaScript or Ruby modules running inside SQL Server. Perhaps that's just an unnecessary fear, as I've seen relatively little use of the CLR in SQL Server since it was released in 2005.

The relatively few items mentioned as changes would indicate to me that much of the feature work is done and now tuning and bug fixes are under way. I wouldn't be surprised to see another CTP or two, but I do think that we may see a final RTM sometime this summer. I've seen a lot of guesses in the forum about the release date and some of them seem better today than they did last month. My own guess, with no inside information, is that we will get 3.1 and 3.2 as CTPs before an RTM in August.

Steve Jones - SSC Editor

Join the debate, and respond to the editorial on the forums

In this blog we would learn how to fix Msg 4353 - ...

Friends, CTP 3.0 dropped today, and it includes so...

4x14 vcpus, 1472 total GB vRAM (368 GB per vNUMA n...

Just a short note – in SQL Server 2019, the setu...

How does one consistently find the correct path to...

Comprehensive Database Performance Health Check Cl...

Question: When Was SQL Server Last Restarted? First appeared on When Was SQL Server Last Restarted? – Interview Question of the Week #225

Open source NAS isn’t appropriate for every use case, but it can be ideal for lab deployments, smaller workgroups or active archive data.

I recently had a very simple and interesting error received while I was working with Docker and Persistence Storage for my upcoming SQL Server Performance Tuning Practical Workshop. The...

Jim Harris shares three more examples of how data ...

Industry group urges EU policymakers not to draw "red lines" around specific uses of AI.

Do you want to ensure your Azure users don't have ...

Jovan Popovic has some pieces of advice for backin...

SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like Power BI, SSRS is still a popular tool for paginated reports. In this article, Kathi Kellenberger explains the architecture of SSRS and walks you through installing an SSRS development environment on your workstation or laptop.

Hey there! I’m Jeff, the latest apprentice at Da...

Edwin M Sarmiento is a Filipino Microsoft Data Pla...

I was interviewed yesterday by Stephen Wynkoop (tw...

I just noticed today that there is a new blade in ...

While architecting cloud native applications, you need to ensure that your system is highly available, performant, scalable, fault tolerant, and has the capability to recover from a disaster scenario. In this article, Samir Behara discusses the options available when designing the database architecture to achieve scalability.

Establishing coding standards can help remove blockers to understanding code, improving quality and reducing maintenance. Faris Hilmi explains how having consistently formatted code plays a larger role in database development and how Redgate tools can best equip you for the task.

Pre-conference Workshop at SQLSaturday Baton Roug...

Today I was looped in on an email thread about the...

The next free webinar from Enterprise Data & A...

Redgate are inviting senior data professionals to attend one of the upcoming SQL in the City Summit events taking place in May and June. If you’re interested in learning how your business can benefit from implementing Compliant Database DevOps this event is for you. Find out who’s presenting and register for a Summit near you today.

Please read https://wriju.wordpress.com/2019/05/20/build-2019-ai-sessions-and-recordings/

This law review article by Noam Kolt, titled "...

The latest edition of The American Statistician is...

When I decided to rip off of Brent Ozar’s (b/t) Bad Idea Jeans series (yes I asked) I decided that ... Continue reading The post Bad Idea Cowboy Hat: Using...

Monica Rathbun fills us in on filtered indexes: Wh...

Batch Cussidy In the last post, we looked at how S...

Watch this week’s episode on YouTube. SQL Server...

Let’s Run A Cruddy Query We’ve got no supporti...

Footnote I have two queries. They return the same number of rows. The only difference is one column in the…

(2019-May-24) Data Flow as a data transformation ...

This post is part of a series, Short Cuts to Biml ...

Quite simply the objective as follows: Move data f...

We’re excited to announce the monthly release of SQL Server 2019 community technology preview (CTP) 3.0. For customers in the Early Adoption Program, CTP 3.0 is the first release where you’re able to run SQL Server 2019 in production.

Personal data leaks, poor protection of logins and...

I am Andreas Schubert and I am working as a Princi...

Silicon Power has introduced its new external SSD ...

QNAP has introduced its USB 3.0 to 5 GbE network a...

In the 1980s, data storage took a big leap forward...

Kingston's latest flagship client/consumer SSD is launching today: the KC2000, which is set to replace the two year old KC1000. The KC2000 was previewed early this year at CES,...

Building on the introduction to the SQL used by Cosmos DB in the first article in the series, here you will learn how to handle some of the more classic challenges that you may face when querying JSON documents. Adam Aspin shows you some of the workarounds that are useful in practice when finding and shaping output data ready for further analysis.

The SQL Server team continues to make my day. The ...

Need to work with hours and minutes in your Power ...

Now that you know about the dimension and fact tab...

I’ve talked before about the difference between ...

Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html https://blog.gbrueckl.at/base64/ Since they wrote those posts, however,...

Today marks the 30 day countdown to dbatools 1.0, which we will be debuting at Data Grillen in Lingen, Germany! These next 30 days are important and I’m writing...

NEWS ANALYSIS: SixFifty Privacy, provided by Palo ...

Give it a try, as the beta is out. I’ve been wat...

Microsoft today announced the general availability...

Phil Factor demonstrates the bare essentials of SC...

Are you interested in guest posting? Publish at Da...

Colin Gillespie shows off an R package for benchma...

Are you interested in guest posting? Publish at Da...

Interested in guest posting? We would love to share your codes and ideas with our community. Category Basic Statistics Tags Data Visualisation Maps This is the fourth part of our post series about the exploratory...

Quickly and easily explore your data set in R with the Inspectdf function!

Problem Recently, when I tried to install SQL Server 2017 (mssql-server package) in Ubuntu 18.04, I encountered the error below: The command that I used to install the mssql-server... The...

Der Spiegel is reporting that the German Ministry ...

Google automatically suspended accounts after dete...

I’ve seen this more and more over the last year:...

SandboxEscaper has published 7 such exploits to da...

Researchers warn dangerous BlueKeep vulnerability ...

Houses can't be sold, bills can't be paid while ci...

A dive into vulnerability data shows even big dist...

Here’s my round-up for this month’s T-SQL Tues...

This has come up a few times recently, I find it r...

Hunt down this stuff before stuff starts to break!

"This time when we go to the Moon, we're actually ...

My most of the Comprehensive Database Performance ...

There is a constant pressure in software delivery to release at speed and often. However, there is no sense in delivering fast if what you deliver contains errors or is of no value to the customer. Our latest blog explains how database unit testing can set your team up for valued software delivery.

Phil Factor provides a PowerShell script to disconnect your laptop without risking error 21, if you're working with SQL Clone and need to go offline. The same script will then bring the clone database back online smoothly, once you're reconnected.

Many production databases have failed embarrassingly as a result of INSERT code that omits a column list, usually in mysterious ways and often without generating errors. Phil Factor demonstrates the problem, and advocates a 'defense-in-depth' approach to writing SQL, in order to avoid it.

Creating a custom container is where things get tr...

In the previous two posts on containers I showed h...

I’m working with Docker running on Windows or Li...

In yesterday’s blog post we pulled SQL Server im...

I find that I’m using containers more and more to get things done with SQL Server. They’re so easy to set up for testing, spin ’em up, do stuff,... The...

Monday June 17 16.00-17.00 / 10.00-11.00 Central - Discover how adopting 4 steps will lay your foundations for automation and Compliant Database DevOps.

Wednesday June 12, 16.00-17.00 / 10.00-11.00 Central - Find out how Compliant Database DevOps enables agility while safeguarding your organisation in the event of a data breach or regulatory audit.

In this independent review of SQL Provision, the Bloor analyst finds that SQL Provision’s combination of database cloning and data masking stands out with “clear advantages over competing approaches, such as data subsetting or synthetic data generation.”

Development and IT departments face increasing demands to deliver changes faster, often with increasing complexity and less tolerance for downtime, and without a corresponding growth in team size to...

There is constant pressure in software delivery to release at speed and often. To take an idea or fix and deliver it into the hands of customers in as...