Jean Joseph

Persist SQL Server Container Data-Part1

By default docker container does not persist data however there are ways available to us to bypass that limitation. In this post, I will explain the basic way to persist data within SQL Server containers. Volumes(-v, –volumes) and Mount (–mount) will allow us to persist data within a docker container however Docker volumes are theContinue reading “Persist SQL Server Container Data-Part1”

SQL Server container does not persist data

In this post, I will demonstrate how by default docker container packages did not design to persist data when using SQL Server data Docker Container packages. Be default data will never persist when using SQL Server docker containers. For instance all data, and customized SQL Server configuration setting will be lost when issued docker stopContinue reading “SQL Server container does not persist data”

Intro To SQL Server Containers

This article is a basic introduction to SQL Server Docker Container. I will define and demo how to deploy SQL Server docker containers locally and also provide link to configure it on windows server environments. The purpose of this article is to demonstrate how easy it is to start using SQL Server docker containers withinContinue reading “Intro To SQL Server Containers”

SQL Server Statistics Are Not Free

Statistics are vital for Query Performance however In this post, I want to show you how query performance changes when the automatic create or update statistics does occur during the query execution time. Remember, the optimizer in SQL Server is driven by statistical analysis of query behavior and by default, SQL Server maintain create andContinue reading “SQL Server Statistics Are Not Free”

Troubleshooting SQL Server Statistics

Statistics contain statistical information about the distribution of values in one or more columns. SQL Server Query Optimizer uses statistics to create an optimized and cost-effective execution plan that improve query performance. statistics help SQL server to estimate the number of rows (also known as cardinality).By default, SQL Server maintain create and update statistics automaticallyContinue reading “Troubleshooting SQL Server Statistics”