Find out in this webinar how easy it is with Red Gate's SQL Virtual Restore to mount live, fully functional databases direct from backups – without performing a physical restore. Learn how you can use SQL Virtual Restore to save storage space and time across a wide range of database administration activities.
2010-09-09
1,093 reads
This challenge involves parsing a delimited string and applying some logic to perform some calculations based on the position of tokens within the string.
2010-09-06
1,475 reads
A free virtual chapter presentation by Andy Warren on Sept 7, 2010 at 12:00EDT. This beginner to intermediate level session will introduce you to statistics, including how to create, manage, troubleshoot, and more!
2010-09-03
4,089 reads
Last day for early bird registration for the next SQLBits conference on Sept 30th-Oct 2, 2010 at York University. SQLServerCentral has a discount code if you'd like to attend.
2010-09-03 (first published: 2010-07-29)
4,121 reads
Come to a SQL Saturday in Iowa City on Sept 18, 2010 and get a free day of training from the SQL community.
2010-09-03
954 reads
An interview with the Exceptional DBA of 2010, Tracy Hamlin.
2010-08-24
2,712 reads
Congratulations to Tracy Hamlin, voted to be the Exceptional DBA of 2010.
2010-08-23
1,543 reads
This is a challenge to identify the downtime of servers from the log data generated by a monitoring application.
2010-08-23
1,518 reads
A webinar sponsored by Red Gate Software showing you how easy it can be to source control your database code. Thursday, August 19, 2010 12:00 PM EDT
2010-08-17 (first published: 2010-08-05)
4,658 reads
On Aug 18, 2010 there is a SQL Social meeting in Kent, UK. Read about the details and attend if you are in the area.
2010-08-10
1,683 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...
BCA KCP Tebet Barat 2 Telpon/WA:085355042311 Jl. Tebet Raya No.25 B Blok CI, Tebet...
Telp/wa 085169998765 Jl. Pemuda No.28-32, Panggang III, Panggang, Kec. Jepara, Kabupaten Jepara, Jawa Tengah...
Rukan Pusat Bisnis, Jl. Daan Mogot Baru No.9 & 10 Blok KJF, Kalideres, Kec....
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