Containerization
Docker has containers to work on processes or application. now docker containers has some limitations as it uses resources from...
2019-01-19
124 reads
Vinay Thakur
MongoDB Replica-Set
The most important feature of MongoDB is its easy setup and use of Replica set. in mongo db you can...
2019-01-13
171 reads
MongoDB – Storage
MongoDB has a Storage Wired Tiger by default MongoDB generated some standard wt (WiredTiger extension) files, WiredTiger uses MultiVersion Concurrency Control...
2019-01-12
175 reads
MongoDB – DBs and Configurations
Continue to our last discussion , today we will be discussing on MongoDB default databases and more… When you install mongoDB...
2018-12-21
217 reads
MongoDB – Basic Commands
We discussed about MongoDb installation and startup. I highly recommend to go though the training session which will provide a detail...
2018-12-19
206 reads
MongoDB – Docker Install
Docker and Container making my life great. these days I can explore every thing using this. I have installed MongoDB...
2018-12-18
303 reads
MongoDB – Basic
MongoDB is a great Database NOSQL and easy to use and learn. if you know java scripting and database concept...
2018-12-17
821 reads
SSMS – Docker SQL Server
once we install SQL Server on Docker which we discussed in our last blog, we can connect Docker SQL Server...
2018-12-13
249 reads
SQL Server on Docker
Started working on Docker and contains Install Docker on the system – please make a note that for windows 10 Home...
2018-12-08
313 reads
SQL Server 2019
I have written about 2017 here, Last month at Microsoft Ignite FL on September 2018, Microsoft announce they are going to...
2018-10-20
276 reads
Blogs
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
T-SQL Tuesday #198 Invitation: How Do You Detect Data Changes?
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
Forums
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers