SQL Server “Denali”: SQL Server Developer Tools, codename ‘Juneau”
Juneau is the code name for the new SQL Server Development Tool (SSDT), to be released along with the next...
2011-07-01
1,271 reads
Blog Posts
SQL Statistics – another Spin
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for the entire database. While reading the blog, I was...
2011-07-01
18 reads
SQL Statistics – another Spin
I was reading a blog by Pinal Dave that was about using catalog views to obtain information about stats for...
2011-07-01
670 reads
SQLDIY: Gathering A Data Dictionary
In this installment we are looking at assembling a basic data dictionary from the column level meta data stored in...
2011-07-01
995 reads
What's In A Blog? - BlogLock
Hi, ALL. Today's Blog is much ado about nothing? A totally free-form blog entry, with random thoughts on a passing scene.
Sometimes, it...
2011-07-01
700 reads
70-450 Study Guide
In my last post concerning my certification journey I said I may post a study guide. I have thought it over and a sweetened condensed version of some of...
2011-06-30
7 reads
70-450 Study Guide
In my last post concerning my certification journey I said I may post a study guide. I have thought it...
2011-06-30
4,768 reads
Arggghhhhh
I have a new tune stuck in my head now. It got stuck there this afternoon shortly after my computer was forced into a reboot. I was in the...
2011-06-30
7 reads
Arggghhhhh
I have a new tune stuck in my head now. It got stuck there this afternoon shortly after my computer...
2011-06-30
1,636 reads
Awesome Reports Webinar Tomorrow at 11AM
Here at Pragmatic Works, we enjoy putting on a show for the community. As can be seen by Training on...
2011-06-30
1,410 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