Press Release


Technical Article

SQL Saturday #275 - Copenhagen

SQL Saturday is coming to Denmark on March 29, 2014. This a free event of SQL Server training and networking. The full schedule is up (and it's full of great speakers) on the SQL Saturday site and make sure to say hello at the Red Gate booth while you're there.

2014-03-07

1,542 reads

Technical Article

Vote Now: Final Service Packs for 2008/2008 R2

Microsoft has continued to release Cumulative Updates, with each one specifying that customers should wait for the next service pack if they don't experience an issue. However, no Service Packs have been released for some time. Let Microsoft know we want Service Packs.

(1)

You rated this post out of 5. Change rating

2014-03-06 (first published: )

4,471 reads

Technical Article

SQLSaturday #269: SQL South West, Exeter, UK

SQL South West user group are running their second SQL Saturday on March 21st and 22nd and have another spectacular schedule of technical content from SQL Server professionals from the UK, Europe and USA including SQL Server MVPs and Microsoft staff. All the session details and how to register for the full-day pre-con sessions or the free-to-attend Saturday:

2014-03-04

1,702 reads

Technical Article

SQL Saturday # 276 - Silicon Valley, CA

March 15, SQLServerCentral's Steve Jones and many others (including Kalen Delaney, Kevin Boles, and Karen Lopez) will be presenting at SQL Saturday Silicon Valley. This is a free, one-day learning event about SQL Server, Microsoft Business Intelligence, and Big Data. Register soon while spots are available.

2014-02-24

1,672 reads

Technical Article

SQL Saturday #280 Vienna, Austria

SQL Saturday is coming to Vienna on March 6 with a full-day of technical training and networking, featuring international speakers. With over 20 sessions on SQL Server, the event is aimed at all those interested in SQL Server - from pros to beginners.
In 2014 the event is held for the first time in Austria, Vienna, organized by PASS Austria.

2014-02-21

1,646 reads

Blogs

A Cloud Dependency Failure from Amazon

By

I went to sleep while reading a Kindle book on my phone. I know...

Deploying AI in logistics (the unfiltered version)

By

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?

By

It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...

Read the latest Blogs

Forums

Bca Kcp Pembangunan Hub/Wa (08216977701)

By noumanarshad

Jl. Pembangunan I No.25A, RT.11/RW.1, Petojo Utara, Kecamatan Gambir, Kota Jakarta Pusat, Daerah Khusus...

BCA KCP Pintu Air Hub/Wa (08216977701)

By noumanarshad

Jl. Pintu Air Raya No.36 Q, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta Pusat,...

BCA KCP Gatot Subroto Hub/Wa (08216977701)

By noumanarshad

Centennial Tower, Jl. Gatot Subroto No.Kav 24-25 lantai GF unit C, Karet Semanggi, Kecamatan...

Visit the forum

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      1960
If I run this code, how many rows are returned?
SELECT TOP 2 
  json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;

See possible answers