A new series of courses is available from SQLskills to help you better learn to manage and tune your SQL Server instances. These classes are designed to help you complete the MCM certification, but are also valuable for anyone that wants to become a better SQL Server DBA.
2011-01-27 (first published: 2011-01-10)
2,061 reads
The next webinar from SQLServerCentral will look at backups and how you can create faster, smaller, and verified backups. Join Steve Jones and Rodney Landrum for this presentation on SQL Backup Pro and SQL Virtual Restore
2011-01-27 (first published: 2011-01-18)
1,923 reads
2011-01-25 (first published: 2010-12-02)
3,658 reads
A free day of training in Louisville, KY. Come and learn more about SQL Server from a variety of experts.
2011-01-17 (first published: 2010-11-30)
3,202 reads
The 14th annual DevWeek conference takes place from 14-18 March 2011, at the Barbican Centre in central London, and once again incorporates two dedicated tracks on SQL Server, alongside seven concurrent tracks aimed at software developers.
2011-01-11
476 reads
2011-01-11 (first published: 2010-12-01)
3,109 reads
SQLServerCentral has a mobile site to enable you to access the question of the day from your cell phone.
2011-01-05
989 reads
Red Gate has released SQL Scripts Manager, a free tool containing over 25 scripts written by SQL Server experts, to help you automate common troubleshooting, diagnostic, and maintenance tasks.
2010-12-23
5,955 reads
Microsoft completed SQL Server 2005 Service Pack 4 recently and made it available at the end of last week.
2010-12-20
4,684 reads
In this webinar, MVP and noted author, Grant Fritchey shows you how to better keep track of what is happening on your instances by gathering information on performance from SQL Monitor and then using that to interpret the impact on your databases. Dec 14, 2010.
2010-12-14 (first published: 2010-12-07)
2,225 reads
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Melawai Raya No.3, RT.3/RW.1, Melawai, Kec. Kby. Baru, Kota Jakarta Selatan, Daerah...
Jl. HZ. Mustofa No.300, Tuguraja, Kec. Cihideung, Kab. Tasikmalaya, Jawa Barat 46124
BCA KCP Gandaria City Telpon/wa:0813.7887.595.Gedung Mal Gandaria City Mainstreet-Upper Ground M-U25, Jl. Sultan Iskandar...
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