A week or so ago I posted a note about reading How to Start a Conversation and Make Friends (worth reading), and I had a comment posted to the blog by author Don Gabor. I like that kind of follow up, so I sent Don a note and a ...
2009-04-28
1,528 reads
In theory, the SQL Server Maintenance Plan Wizard is supposed to make it easier for non-DBAs or novice DBAs to create database maintenance plans that help to optimize the performance of their SQL Server databases. The problem is ...
2009-04-27
8,030 reads
In the course of giving my security presentations over the past year, I've learned that quite a few folks have never seen the C-I-A triad before. The C-I-A triad stands for...
2009-04-27
4,580 reads
I happen to notice this in a class recently that I had the rare student - one that could take notes that seemed to have value to them the next day. If you watch people take notes, I think they fall into one of these categories: The Highlighter. They have...
2009-04-24
1,989 reads
When defining the attribute, we always specify the surrogate key as the key column for any attribute. I was just thinking if we could make use of the natural key instead of the surrogate key. i.e., in case of a product attribute, the surrogate key say...
2009-04-23
2,629 reads
I read SQLBatman's post about his first week as an MVP , and it really resonated well with me. I think that he really hit it when he said that he wasn't going to sit around, he was going to go look for information and take things back from the...
2009-04-22
1,226 reads
I’ve often described SQL Server to people new to databases as a data pump. Just like a water pump, you have limited capacity to move water in or out of a system usually measured in gallons per hour. If you want to upgrade your pumping systems it can be...
2009-04-21
6,824 reads
Time has flown by since my last update, busy time at work and struggling to get that done and find a few hours for PASS too. Here's a short version of what I've been working on lately: Added the Top 10 List page and have some starter lists from...
2009-04-20
1,208 reads
I've been writing a lot about networking lately and my efforts to learn/leverage LinkedIn, and along the way taken a few hits for opening up my Linked In network to include those of you who read my blog regularly and want to connect. The essence ...
2009-04-17
1,523 reads
Fully qualified domain name that is. One of the little gotchas I encountered when rewriting my database mirroring automation scripts in powershell was that there is no simple way to get the SQL Server's fully qualified domain name. I didn't want to...
2009-04-16
3,677 reads
It's time for T-SQL Tuesday #198! This month's topic is change detection. The post T-SQL...
By James Serra
Model Context Protocol, or MCP, is one of those technical ideas that sounds more...
When starting with AWS RDS Aurora for managing relational databases in the cloud, many...
Jl. Soekarno-Hatta No.240, Kb. Lega, Kec. Bojongloa Kidul, Kota Bandung, Jawa Barat 40227
Jl. Dulatip No.26 & 26A, Kb. Jeruk, Kec. Andir, Kota Bandung, Jawa Barat 40181
Jl. Asia Afrika No.122-124, Paledang, Kec. Lengkong, Kota Bandung, Jawa Barat 40261
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