SQL Server SP2 released
Today, Microsoft released Service Pack 2 for SQL Server 2005. Though mostly a series of fixes for minor issues, there...
2007-02-19
1,427 reads
Blog Posts
Microsoft SQL Server certification
A few weeks ago I was engaged in a useful discussion about the merits of getting certified on Microsoft SQL...
2007-02-18
1,906 reads
Daylight Saving Time and SQL Server
If you're in the United States, chances are you've already heard about Daylight Saving Time (DST) occurring 3 weeks early...
2007-02-13
2,665 reads
Midlands PASS Site Online
I have put the Midlands PASS site online temporarily at Truth Solutions. You can reach it here:
http://www.truthsolutions.com/MidlandsPASS/
The slides from Paul...
2007-02-12
1,614 reads
Guest Editorial Week
I've been writing the editorials for over two years now and it's become an almost daily part of my life....
2007-02-11
1,446 reads
Midlands PASS February Meeting Postponed
We are postponing
due to the weather. Training Concepts has shut down for the day due to the wintry
mix....
2007-02-01
1,289 reads
Tools: ApexSQL Edit wins SQL Server Editor's Choice award
I meant to blog on this last month but work has been just a touch short of insane. I like...
2007-01-31
1,504 reads
For those just starting out with SSIS
Having cut my teeth on SQL Server 2000, I had some (but not a lot) of DTS experience. Recently I...
2007-01-30
1,380 reads
Jim Gray Missing
Jim Gray is missing at sea. A sad day for database professionals and Mr. Gray's family. He is reporting missing...
2007-01-30
1,479 reads
Midlands PASS February Meeting
Our next meeting will be on
Thursday, February 1, 2007, at 6:30 PM.
It'll be at the Training Concepts facility once...
2007-01-30
1,518 reads
Blogs
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...
Understanding Fabric MCP
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
AWS RDS Aurora - our first approach
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Forums
BCA KCU PANTAI INDAH KAPUK TLP/WA 08216977749
Jl. Pantai Indah Kapuk Utara I Blok F, Kamal Muara, Kecamatan Penjaringan, Jkt Utara,...
BCA KCP Gading Bukit Indah TLP/Hub 08216977701
Jl. Raya Gading Kirana Blok D/1, Klp. Gading Bar., Kec. Klp. Gading, Jkt Utara,...
BCA KCP Kelapa Gading Hibrida TLP/WA 08216977749
Jl. Boulevard Raya No.14 Blok RA-1, RW.15, Klp. Gading Tim., Kec. Klp. Gading, Jkt...
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