Problems displaying this newsletter? View online.
Database Weekly
The Complete Weekly Roundup of SQL Server News
Hand-picked content to sharpen your professional edge

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

The Weekly News
All the headlines and interesting SQL Server information that we've collected over the past week, and sometimes even a few repeats if we think they fit.

SQL SERVER – FIX: Msg 4353 – Conflicting File Relocations Have Been Specified for File. Only a Single WITH MOVE Clause Should be Specified for Any Logical File Name

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

Query Store in SQL Server 2019 (CTP 3.0)

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

SQL Server 2016: Here a NUMA, there a NUMA... Part 2

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

Setting MAXDOP During SQL Server 2019 Setup

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

Event Log File Paths

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

SQL SERVER – Script to Enable PAGE and ROW Level Compression – Disable Compression

Comprehensive Database Performance Health Check Cl...

When Was SQL Server Last Restarted? – Interview Question of the Week #225

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

DIY Open Source NAS: How to Install FreeNAS

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

SQL SERVER – Fix Error – Login failed for user. Reason: Server is in script upgrade mode. Only administrator can connect at this time. (Microsoft SQL Server, Error: 18401)

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...

Artificial Intelligence (AI)

How data quality improves artificial intelligence – Part 2

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

How tech companies are shaping the rules governing AI

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


Getting Started with Role-based Access Control in Azure

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

Azure SQL Managed Instance

Quick Hits on Managed Instance Backup / Restore

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


Reporting Services Basics: Overview and Installation

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.


The Ironic DBA—Starting a New and Unexpected Career?

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

Successfully Managing Upwards and Getting Your Boss on Your Side Part 1

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

Building Your Brand Right

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

Cloud Computing

New Azure “SQL Server settings” blade in the Azure Portal

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

Designing Highly Scalable Database Architectures

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.

Coding Standards

Enhance your database development by using coding standards

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.

Redgate SQL Provision
Conferences, Classes, Events, and Webinars

Workshop – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment

Pre-conference Workshop at SQLSaturday Baton Roug...

What’s Unique About SQL Saturdays: Nearly Everyone Interacts with Other People

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

Free Webinar: Build and Load a Staging Database with Biml

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

SQL in the City Summits Down Under

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.

Build 2019 AI sessions and recordings

Please read

Data Privacy and Protection

The Concept of "Return on Data"

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

Data Science

Pondering statistical significance in a world without .05

The latest edition of The American Statistician is...

Database Design

Bad Idea Cowboy Hat: Using a foreign key to prevent updates

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...

Database Performance

Using Filtered Indexes

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

Bad Guesses and Bad Choices: Better Living Through Indexes

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

Predicate Execution Order on Mixed Data Type Columns

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

Bad Guesses and Bad Choices

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

Distinct Rows, And The Columns You Choose

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

ETL/SSIS/Azure Data Factory

Using Azure Data Factory Mapping Data Flows to populate Data Vault

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

Simplifying Imported Biml

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

Using Azure Data Factory to Migrate Data

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


SQL Server 2019 community technology preview 3.0 is now available

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.

US political parties are better at security, but still have problems

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

HA/DR/AG/FCI/Clustering/Business Continuity

Keeping Availability Group Logins in sync automatically

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


Silicon Power’s Bolt B75 Pro: An External SSD up to 2 TB, USB 3.1 Gen 2 Type-C

Silicon Power has introduced its new external SSD ...

QNAP Launches QNA-UC5G1T: A USB 3.0 to 5 GbE Network Adapter

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

The Promise Of NVMe

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

Kingston Launches Client-Focused KC2000 M.2 NVMe SSD: 96L TLC On SM2262EN

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,...


SQL For Cosmos DB – Tips and Tricks

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.


PolyBase on Linux with CTP 2.5

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


Working with time in Power BI Desktop

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

Power BI Basics of Modeling: Star Schema and How to Build it

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

Power Query Is No Longer DAX’s Little Brother

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

Storing Large Images In Power BI Datasets

Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: Since they wrote those posts, however,...


Working with SQLSaturday SpeedPASSes – revamped!


30 day countdown to 1.0 starts today!

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...

Product News, Releases, and Upgrades

Law Firm Releases New Data Privacy App for CCPA

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

The SQL Change Automation in SSMS Beta

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

Windows Server Version 1903 is Now Generally Available

Microsoft today announced the general availability...

Product and Book Reviews

Simple Steps in SQL Change Automation Scripting

Phil Factor demonstrates the bare essentials of SC...


Linear regression in Python

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

R Language

Timing R Function Calls

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

Converting data from long to wide and from wide to long simplified: tidyverse package

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

Automated data report storytelling in R


Earthquake Analysis (4/4): Cluster Analysis

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...

Part 2: Simple EDA in R with inspectdf

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

SQL Server on Linux

Quick Tip – How to fix SQL Server 2017 install error on Ubuntu 18.04: E: Could not get lock /var/lib/dpkg/lock-frontend – open (11: Resource temporarily unavailable)

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...


Germany Talking about Banning End-to-End Encryption

Der Spiegel is reporting that the German Ministry ...

Google bots shut down Baltimore officials’ ransomware workaround Gmail accounts

Google automatically suspended accounts after dete...

Mini-Rant: Spoofed Phone Numbers and Trust

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

Serial publisher of Windows 0-days drops exploits for 3 more unfixed flaws

SandboxEscaper has published 7 such exploits to da...

Why a Windows flaw patched nine days ago is still spooking the Internet

Researchers warn dangerous BlueKeep vulnerability ...

Baltimore ransomware nightmare could last weeks more, with big consequences

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

WannaCry? Hundreds of US schools still haven’t patched servers

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


T-SQL Tuesday #114 Puzzle Party – Roundup

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

Using VALUES to construct an in-line table.

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

Find Occurrences of Three and Four-Part Names on a SQL Server Instance

Hunt down this stuff before stuff starts to break!

The Lighter Side

NASA officially orders its first segment of a lunar space station

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


SQL SERVER – Maximizing Query Execution Plans On Screen – A Quick Tip

My most of the Comprehensive Database Performance ...

Unit Testing

Set your team up for valued software delivery with Unit Testing

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.

Vendors/3rd-party Products

SQL Clone on your Laptop

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.

Insert Statement Without Column List (BP004)

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.

Virtualization, containers, and k8s

Containers: Create a Custom Container

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

Containers: Working With Volumes

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

Containers: Getting an Image

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

Containers: Creating a Container

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

Learning Containers

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...


Standardize Database Development Across your Organization in 4 Key Steps

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.

Data privacy next steps: 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.


Bloor scores SQL Provision 4.5 out of 5 for test data provisioning

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.”

software development

Enhancing your database development using coding standards

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...

software testing

Database unit testing: Setting your team up for valued software delivery

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...

RSS FeedTwitter
This email has been sent to {email}. To be removed from this list, please click here. If you have any problems leaving the list, please contact the This newsletter was sent to you because you signed up at Note: This is not the daily newsletter list, and unsubscribing to this newsletter will not stop you receiving the SQL Server Central daily newsletters. If you want to be removed from that list, you can follow the instructions on the daily newsletter.
©2019 Redgate Software Ltd, Newnham House, Cambridge Business Park, Cambridge, CB4 0WZ, United Kingdom. All rights reserved.


- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -