Midlands PASS October Meeting
Taya Blanchard to speak on A
Practical Guide to Making Sense of Your SQL Server Application
Performance
Midlands PASS Chapter - October...
2007-10-03
576 reads
Blog Posts
Estimates - Part 1
I saw a very interesting post about estimating software from Steve McConnell, of Code Complete fame. He compared his estimate...
2007-10-02
1,011 reads
Paperwork Day
Doing payments for articles, expenses, and a few articles. This is definitely a paperwork day. As much as I like...
2007-10-01
645 reads
Clustered Indexes
I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports...
2007-09-30
1,293 reads
The Quickest Podcast in the Business
I almost forgot to record the podcast for tomorrow's editorial. In case you're a glutton for punishment, it's here. I'd...
2007-09-30
1,606 reads
I Don't Have a Black Eye
Though it kind of looks like that. Here's the first video podcast.
Halo 3
Actually it's probably the 20th, but it's close...
2007-09-29
1,444 reads
Monitoring and Alerting
I responded in an interesting thread this morning where someone was looking for advice on what to monitor on their...
2007-09-28
1,563 reads
Points or Posts
It's an interesting question that we had come up, and honestly I'm not completely sure what I want. I'll describe...
2007-09-27
1,414 reads
I Am Not In Charge
That is for sure.
We had a development meeting today with my publishing team (meaning I'm on the team, not leading...
2007-09-26
1,460 reads
Development at High Speed
As with any project, despite being fairly pleased with the final product, there were bugs. In fact, quite a few...
2007-09-25
1,380 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
SPAM Issues May 2026
We suffered a SPAM attack from May 1-6, which unfortunately corresponded with time off...
BCA KCP RADEN SALEH TLP/WA 083800119009
Jl. Raden Saleh No. 13, 15, 17A, Daerah Khusus Ibukota Jakarta 10430
BCA KCU WAHID HASYIM TLP/WA 083800119009
Jl. K.H. Wahid Hasyim No.183 A-B, Kb. Kacang, Kecamatan Tanah Abang, Kota Jakarta Pusat,...
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