In this article we look at the first public CTP release of SQL Server 2019 and some of the great new features that will be part of SQL Server 2019.

An Open Thank You to the Microsoft SQL Server Team

by Steve Jones

SQLServerCentral.com

Editorial

Thanks for improving the string or binary data truncated error message.

SQL Server From .Net: Using SQL Server Schema to Build a Data Set

by Tim Wellman

SQLServerCentral.com

.Net

A basic introduction for developers (or anyone) to using the metadata for a SQL Server database to build a DataSet in ADO.Net that represent objects in any SQL Server database.

Security, Compliance, Data Ethics, and Breaking the “Not My Job” Mindset

by Additional Articles

SimpleTalk

Security

Security, compliance, and data ethics are related concepts that everyone who works with software should know about, from the help desk to the C-level office… but almost everyone thinks that worrying about these things is someone else’s problem.

The Uninteresting But Necessary Work

by Steve Jones

SQLServerCentral.com

Editorial

Data classification may not be fun or even interesting, but it is necessary.

SQL Server MERGE statement usage and examples

by Additional Articles

MSSQLTips.com

MERGE

In this tip we look at how to use MERGE compared to running separate INSERT and UPDATE statements.

Renaming a Schema in SQL Server

by Steve Jones

SQLServerCentral.com

Schema

If you have a schema you want to retire, here's a method for moving all objects inside that schema to a new one.

SQL Server v.Next is Coming in 2019

by Steve Jones

SQLServerCentral.com

SQL Server 2019

The announcement of the next version of SQL Server excites Steve.

Adaptive Query Processing in SQL Server

by Additional Articles

SQLServerCentral

Adaptive Query Processing

Adaptive query processing is the latest query processing feature introduced in the SQL Server database engine, available in SQL Server (starting with SQL Server 2017 (14.x)) and Azure SQL Database. Read on to learn more.