Creating Icons Files
While working on a PowerPack for PowerGUI I needed to create a bunch of icon files from bitmaps files so...
2011-07-03
676 reads
Blog Posts
Non-Convergence of Replicated Data
Brad McGehee over at SQL Aloha posted his July Question: What Do You Think are the Most Common DBA Pain...
2011-07-02
866 reads
Bloopers
An early peak at the bloopers going out on Monday. Feel free to enjoy today. I’ve included the editorial and...
2011-07-01
1,366 reads
Book Review: Hour of the Horde
Hour of the Horde by Gordon R. Dickson ($1-5 @ Amazon) is an interesting story. The basic plot is that one...
2011-07-01
428 reads
FileLinking Using SSIS
A user recently asked how to generate a file link using SSIS so that it could be inserted into the...
2011-07-01
1,012 reads
July Question: What Do You Think are the Most Common DBA Pain Points?
While being a DBA is challenging and often rewarding, we often experience a lot of pain points that we wish...
2011-07-01
688 reads
MVP Award
Today on July 1st 2011, I was pleasantly surprised to be recoginzed as a Microsoft Most Valuable Professional for contributions to the PowerShell technical...
2011-07-01
587 reads
Planning a SQL Saturday
On June 8th we announced SQL Saturday 89. The call for speakers went out to all those who had submitted...
2011-07-01
424 reads
Re-blog – June 24-June 30
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-01
519 reads
School Data Move Done!
A brief mention that we are done with the school year flip process for transitioning to the new school year.
I...
2011-07-01
807 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