Reminder: MSDN Tiki Hut Roadshow Coming to Pensacola, Tallahassee, and More
Forwarding on a note from my local MS Developer Evangelist Joe Healy about his next series of free presentations coming...
2009-02-08
772 reads
SQLAndy
SQLSaturday #13 in Atlanta on April 25, 2009
I've been busy with other projects and haven't had time to focus as much as I'd like on my SQLSaturday...
2009-02-05
487 reads
PASS Update #4
Last week I posted Update #3 that discussed my first board meeting, but I didn't have time to cover my...
2009-02-05
402 reads
Reminder: South Florida Code Camp is February 7, 2009
The fifth annual South Florida Code Camp is coming up this Saturday, Feb 7, 2009, at Devry University, 2300 SW...
2009-02-04
282 reads
Business Budgets at the Department Level
If you're thinking about taking a job as a manager there are two questions that will help you quickly understand...
2009-02-04
946 reads
Making Ginger Ale
Probably further off topic than usual, but you may find interesting anyway. I'm a fan of Alton Brown on Good...
2009-02-03
433 reads
Speaking at Community Events - Time to Raise the Bar?
If you're organizing a first time community event like SQLSaturday finding speakers is one of about a hundred tasks, so...
2009-02-01
1,091 reads
Event Reminder - South Florida Code Camp is February 7, 2009
The fifth annual South Florida Code Camp is being held on Feb 7th. They've got a huge schedule of sessions,...
2009-01-29
1,285 reads
Ruthless Focus - An Addendum
Forgot I had this, a friend had sent it to a while back as something I might blog about. Mike...
2009-01-28
1,359 reads
PASS Update #3
It's been busy since my last update, lots of stuff to work on! I probably won't get it all in...
2009-01-28
1,436 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
The Dangers of Dependencies
Comments posted to this topic are about the item The Dangers of Dependencies
Creating a JSON Document III
Comments posted to this topic are about the item Creating a JSON Document III
Stairway to Reliable Database Deployments Level 2 - Defining the Deployment Contract
Comments posted to this topic are about the item Stairway to Reliable Database Deployments...
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