Future DBA – Hadoop Big Data 1
In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on...
2016-09-26
595 reads
Vinay Thakur
Future DBA – Hadoop Big Data
As we discussed on earlier blog that in future its more than SQL-(R)DBMS, as data is growing we have to...
2016-09-21
429 reads
Operational Analytics -SQL Server 2016
What is Operational Analytics:- Operational Analytics is a combination of two words “Operational” and “Analytics”. so your OLTP system is...
2016-09-20
402 reads
Distributed AG
going though Allan Hirt’s 24 SQLPASS recording, he has explained the new feature of SQL Server Availability group you can get...
2016-09-19
380 reads
Future DBA part 2
I do not say you should be expert in other technologies but you should be aware of what it is...
2016-09-15
385 reads
Future DBA Part 1
As I stated in my earlier blog on future DBA, we should learn many things as we can to be...
2016-09-14
465 reads
World is changing so DBA should
I was going through SQLPASS recording and on first time I could see a session as “MongoDB for the SQL...
2016-09-13
376 reads
24 Hours of SQLPASS
Like every years before PASS summit, this years also SQLpass has 24 hrs sessions… it has great sessions every time,...
2016-09-12
373 reads
SQL 2016-Always Encrypted
As you know this has been introduced in sql server 2016, I am not going in details on it but...
2016-05-07
457 reads
SQL Server 2016 …whats new…WOW!!!
Hey there…. I wrote on SQL Server 2016 in my earlier blog Lets See and Whats new, during that time I knew that SQL...
2016-04-01
681 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 KCP Kas Cikini Gold Center Hub/Wa 08216977701
Jl. Pegangsaan Timur, Menteng Gedung Cikini Gold Center LGF/A/AKS032, RT.1/RW.1, Pegangsaan, Menteng, Central Jakarta...
BCA KCP KEM Tower TLP/WA (0821)6977701
Kem Tower, Gedung, Jl. Landas Pacu Barat No.Blok B Kav. 2, Daerah Khusus Ibukota...
BCA KCP Plaza Sentral Hub/Wa (08216977701)
Jl. Jend. Sudirman No.Kav.47, Karet Semanggi, Kecamatan Setiabudi, Kota Jakarta Selatan, Daerah Khusus Ibukota...
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