Tag Archives: sql server

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

Pro SQL Server on Linux–Install

Posted on January 9, 2019 by way0utwest

As part of my learning goals for 2018, I wanted to work through various books. This is part of my series on Pro SQL Server on Linux from Bob Ward. I had an Ubuntu VM setup at home, but it … Continue reading →

Posted in Blog | Tagged , , , , , | 2 Comments

Get Patched If Not Supported

Posted on December 19, 2018 by way0utwest

There are plenty of reasons not to upgrade your SQL Servers to a new version. Perhaps you know the system is working and don’t want to disrupt activity. Often we don’t want to take a chance that some change in … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Get Patched If Not Supported