SQL Server 2005 – Failed Maintenance Job
I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those...
2017-08-27
297 reads
Vinay Thakur
Learning – Webcasts/Video
Learning for this week. http://www.pass.org/24hours/2017/security/Schedule.aspxhttp://sqlblog.com/blogs/damian_widera/archive/2017/04/20/sql-server-2017-all-sessions-from-microsoft-data-amp-are-online-complete-list-of-links.aspx http://sqlblog.com/blogs/davide_mauri/archive/2017/05/01/pass-appdev-recording-building-rest-api-with-sql-server-using-json-functions.aspx http://sqlblog.com/blogs/sergio_govoni/archive/2017/04/15/pass-business-analytics-marathon-march-2017-recordings-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/31/the-recording-for-biml-in-the-enterprise-data-integration-lifecycle-is-available.aspx http://sqlblog.com/blogs/andy_leonard/archive/2017/03/14/the-recording-for-the-ssis-catalog-compare-version-2-launch-event-is-available.aspx Free Microsoft books: https://blogs.msdn.microsoft.com/mssmallbiz/2017/07/11/largest-free-microsoft-ebook-giveaway-im-giving-away-millions-of-free-microsoft-ebooks-again-including-windows-10-office-365-office-2016-power-bi-azure-windows-8-1-office-2013-sharepo/
2017-05-21
363 reads
Azure CosmosDB SQL Server
As you know Microsoft has retrieve the data from Hadoop with by polybase and extended the R language to External...
2017-05-21
431 reads
Vnext – Its SQL Server 2017
Yes thats true, SQL Server New version will be release this year and call it “SQL Server 2017” where sql can...
2017-04-24
461 reads
vNext has AG
Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported. https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/
2017-03-23
313 reads
SQL Agent on vNext – Linux
SQL Server is running on Linux now with SQLPAL- SQL Platform Abstraction Layer(SQLPAL) -it will work as a virtual Windows server on...
2017-03-23
424 reads
SQL Server on Linux
Yes that is true, now SQL Server is on Linux. https://www.microsoft.com/en-in/sql-server/sql-server-vnext-including-Linux Download the public preview https://docs.microsoft.com/en-us/sql/linux/ I am learning it...
2017-02-04
727 reads
Future DBA – Big Data -MongoDB 2
In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a...
2016-10-04
484 reads
Future DBA – Big Data -MongoDB 1
We have discussed hadoop and its HDFS management tools for big data system, which works horizontal scaling for data distribution...
2016-10-03
485 reads
Future DBA – Hive Big Data 2
In our last blog on Future DBA, we discussed on HADOOP -HDFS system. how as we know HDFS management is...
2016-09-27
407 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