Introduction Developing predefined reports in addition to all the ad-hoc queries have been a part of my daily activities. Often I find my stakeholders asking me to prepare reports in which they want to know something that has never happened. It might sound strange, but yeah, that's what their point of concern is all about. […]
2019-11-04
4,712 reads
2019-10-28
4,684 reads
Learn how you can create a SQL Server instance in the Google Cloud Platform.
2019-09-26
2,301 reads
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
5,189 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,395 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,625 reads
The the basics of SQL and T-SQL in this short course of videos that explain some of the concepts.
2019-07-16
12,316 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
6,930 reads
There are multiple ways to interact with the Docke...
2019-06-13
3,169 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,731 reads
By Vinay Thakur
SQL Server Management studio is now can be installed separately not part of SQL...
By James-Serra
Almost lost in all the announcements from Ignite was a bunch of amazing new...
For those who don’t know, last week was the PASS Summit. It’s an amazing...
EvoElite Keto Another thing the best diet for Weight Loss needs is to make...
Hi Friends, I'm using SQL 2014, Everything works fine I gave the following error...
Hi, I configured the Basic Alwayson setup in two of the test SQL standard...
Ask SSC