Day 16 Security
MySQL user format it as ‘User_name’@’hostname’ To create the user account use following syntax: CREATE USER ‘User_name’@’Host_name’ IDENTIFIED BY <Pwd>;...
2018-05-16
218 reads
Vinay Thakur
Day 15 Server Logs
There are 6 types of logs available for MySQL environment, Logs are important information for DBA to troubleshoot or understand...
2018-05-15
212 reads
Day 14 MySQL sys Schema
MySQL 5.7.7 and higher includes the sys schema, This has View, Stored Procedures and Functions to gather the performance related information, as...
2018-05-14
198 reads
Day 13 MySQL Performance_Schema
performace_schema is a dynamic database created when you restart the mysql, all the data from performance_schema database will be clear....
2018-05-13
250 reads
Day 12 INFORMATION_SCHEMA database
Yesterday we discuss about mysql system database, today we will see “INFORMATION_SCHEMA” database, this we cannot call as database because...
2018-05-12
283 reads
Day 11 MySQL System Database
Previous days we discuss Variables and configurations which are quite important for DBA to know. As stated earlier there are...
2018-05-11
219 reads
Day 10 Option file
So far we have discussed various mays to configure MySQL, Environmental Variables, Global Variable, Session Variables, Status Variable and Server...
2018-05-10
213 reads
Day 9 Variables
In earlier days we have discussed about providing options with environmental variable and command line, today we will be discussing...
2018-05-09
189 reads
Day 8 Configuration- Command-line
Yesterday we discuss about different ways of options and configuring with environment variable which will place MySQL locate for values...
2018-05-08
222 reads
Day 7 Configuration – Environmental Variable
On day 6 we discussed about Programs. today is very important day, we will discussing about Configuration options or parameters. All...
2018-05-07
244 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