Microsoft SQL Server has the feature to use “Included columns” for the creation of non-clustered indexes. This feature and its benefits and disadvantages will be explained in the following article. Included columns can be used to create a covering indexes without including all the data into the key columns. This covering index has the advantage […]
2019-09-17
3,762 reads
There are multiple ways to interact with the Docker daemon, as command line client API or GUI based tools like Kitematic. Docker also provides a SDK for Go and Python, this SDK can be used to create and manage Docker containers the same way it works with the Docker engine API.
2019-09-16 (first published: 2019-09-10)
1,088 reads
With origins from the world of “Submarine ‘Dolphin’ Qualification” questions, an “Oolie” is a difficult question to answer, or the knowledge or fact needed to answer such a question, that may or may not pertain to one's duties but tests one's knowledge of a system or process to the limit. Introduction Contrary to what many […]
2019-08-08
4,481 reads
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
11,497 reads
Availability databases hosted on SQL Server Always On Availability Groups (AG) can be connected using a unique Virtual Network Name (VNN), called the Availability Group Listener. When an Availability Group is enabled, clients can connect to databases in both primary and secondary replicas without explicitly specifying the SQL Server instance name. You don’t even need […]
2019-07-02
3,856 reads
There are multiple ways to interact with the Docke...
2019-06-13
2,926 reads
In this article you will learn how to create and use alias commands for Docker, to make Docker's command line experience easier and more productive.
2019-05-20
1,352 reads
When studying Azure one of the things you’ll be asked to learn is the...
I’ve written about statistics in SQL Server a few times now. Through conversations I...
Recently I noticed that Microsoft uploaded a new dockerfile to the mssql-docker repository on...
Comments posted to this topic are about the item Is Data the Future of...
I'm using AlwaysOn synchronous replica. User issues an update on primary via SSMS. In...
hi, i'm creating a view and need some help. i have the column "valorTotal"...
Ask SSC