Day 6: MySQL Programs
On day 5 we understand how to install MySQL or upgrade to latest version. Today we will discuss once installation...
2018-05-06
208 reads
Vinay Thakur
Day 5: Install MySQL and Upgrade
There are multiple ways you can install MySQL, MySQL is compatible for almost all the Operating System. it would be...
2018-05-05
285 reads
Day 4: MySQL Architecture Continue…
MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL...
2018-05-04
276 reads
Day 3: MySQL Architecture
Like other RDBMS MySQL also has similar architecture: Connection Layer/Application Layer Logical Layer (Processing) Storage Engine Layer (Physical) – special Connection...
2018-05-03
307 reads
Day 2: Introduction to MySQL
Story of MySQL is very interesting and involved emotions in it. This is my understanding and my though on Journey...
2018-05-02
304 reads
Day 1: MySQL History
Swedish Company: MySQL AB by – Michael Widenius (Monty), David Axmark and Allan Larsson Name Combination: Michael’s Daughter name –“My” and...
2018-05-01
220 reads
HA between Windows and Linux
If you ask before couple of years about Microsoft and Linux can be compatible was a dream. now Microsoft has...
2018-02-02
256 reads
Count_Big() function
Learned new function for count while going through the channel 9 video for salva. where for a very big table...
2018-01-22
609 reads
Happy New Year… Late:)
Yeah I know its new year and i am back from quite some time. during these days i was learning...
2018-01-13
316 reads
Azure support MySQL & PostgreSQL
After SQL Server support on Linux Microsoft is not have another great enhancement where now Azure supports MySQL and PostgreSQL...
2017-08-27
495 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
BCA KCU THAMRIN TLP/WA 08216977701
Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, Menteng, Kec. Menteng, Kota Jakarta Pusat,...
BCA KCP Mall Grand Indonesia TLP/WA 08216977701
Gedung Grand Indonesia Mall A, Lower Ground No. 20-21, Jl. M.H. Thamrin No.1, Daerah...
BCA KCP Sentral Cikini TLP/WA 08216977701
Jl. Pegangsaan Timur No.1, Cikini, Kec. Menteng, Kota Jakarta Pusat, Daerah Khusus Ibukota Jakarta...
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