Tag Archives: sql server

Getting Close

Posted on April 27, 2019 by way0utwest

Last week we saw the release of SQL Server 2019 CTP 2.5, with enhancements for Big data clusterrs and a Java language SDK for SQL Server. This is the 6th public release of the next version, and one that’s coming … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Getting Close

Enable a Named Instance to Connect on 1433

Posted on April 22, 2019 by way0utwest

My default setup for a few years is to only use named instances, usually with a standard SQL2014 or SQL 2016 as the name of the instance. Recently, I set up a new instance and needed to connect from another … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

Customizing Statistics Histogram in SQL Server 2019

Posted on March 31, 2019 by way0utwest

The use of statistics in SQL Server is tightly embedded in the query optimizer and query processor. The creation and maintenance of statistics is usually handled by the SQL Server engine, though many DBAs and developers know that periodically we … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Customizing Statistics Histogram in SQL Server 2019

Thinking about Setup and Installation

Posted on March 22, 2019 by way0utwest

I’m working the first section of a basic administration course, and the first part of this is installing SQL Server 2019. I built a similar course a few years back for SQL Server 2016, but the world has changed. As … Continue reading →

Posted in Blog | Tagged , | Comments Off on Thinking about Setup and Installation