2009-01-28
16 reads
Press Release
Sample Chapter from Murach's SQL Server 2008 for Developers
Chapter 3 from Murach’s SQL Server 2008 for Developers shows you how to retrieve data from a database table. In the process, you’ll master the basic skills that you’ll use in coding almost any SELECT statement, no matter how complex. At that point, you’ll be ready to learn how to code joins, summary queries, subqueries, and action queries, and then move on to working with server-side features like cursors and stored procedures.
2009-01-28
1,904 reads
SQL Bits IV - Call for Presentations
SQL Bits IV, in Manchester, UK next year on March 28th, is now looking for speakers. Please submit a session if you are interested.
2008-12-30
925 reads
2008-12-15
587 reads
The SQLServerCentral Party at PASS
Details for those of you coming to PASS and looking to attend the SQLServerCentral.com party on Tuesday night.
2008-11-13
852 reads
Get SQL Server Training in the UK
Kalen Delaney has a series on internals and performance taking place in Hertfordshire soon. If you register today, you can still save 20%
2008-10-20
1,121 reads
PASS 2008 - August
The 2008 PASS Summit is in Seattle in November 2008. Come join SQLServerCentral.com and learn more about SQL Server.
2008-10-15 (first published: 2008-08-19)
911 reads
The South African SQL Server Usergroup is Back
MVP Gail Shaw has restarted the South African Usergroup. Read on if you are interested in participating.
2008-10-07
666 reads
PASS - September
The PASS Summit is coming this November and SQLServerCentral.com is looking to throw another great party.
2008-09-18 (first published: 2008-09-02)
1,308 reads
An interview with the Exceptional DBA of the Year
Dan McClain was voted the Exceptional DBA of 2008 by the SQLServerCentral.com community. Learn a bit more about this talented professional in his own words.
2008-09-17
5,896 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
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
SQL Password enforcing
Hi to all We have situation at a client where someone is illegally changing...
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