Tag Archives: sql server

Initialize-HgsServiceName Fails in VMWare

Posted on May 1, 2019 by way0utwest

A short one, but one that took some digging and debugging and help from others. Saving here, so I remember, as do others. I had a VMWare Workstation v12.x VM of SQL Server 2016 and was working with this tutorial … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Initialize-HgsServiceName Fails in VMWare

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