Plucking Wallflowers
Wallflowers Bloom
My friend Tim Mitchell wrote an awesome personal account a while back and shared it again recently. It’s a...
2011-09-02
614 reads
Blog Posts
Pragmatic Works Foundation Class Oct 2011
I am super excited to announce that there is a strong demand for the Foundation Training to be held more...
2011-09-02
554 reads
Preventing projects from deploying when debugging a SSIS package
This is a quick tip to help quickly solve a problem I run into sometimes, and now that I am...
2011-09-02
1,418 reads
Re-blog – August 26-September 1
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-09-02
652 reads
SQL Server test data generation testing tools
Question: How do I generate test data for SQL Server ? I don’t want to buy a benchmarking tool, but I...
2011-09-02
938 reads
Testing Decisions
One of the things I like to do is take some time on decisions that matter to me. That’s a...
2011-09-02
1,037 reads
Variables and Expressions with Connections in SSIS
Variables and expressions help make any SSIS package dynamic and flexible. It is always a best practice to use variables...
2011-09-02
1,498 reads
Geekbench 2.2 Released
Primate Labs has released Geekbench 2.2.0, which is a free upgrade for Geekbench 2.1.x users. The release notes are here.
Here...
2011-09-01
937 reads
It is not a blame game.
Here is a hypothetical situation. A dba works for ACME Corp. Due to what ever reason a change has to...
2011-09-01
441 reads
Job Exit Planning Strategy
I feel somehow sad today (Aug 31, 2011) to see one of my colleagues “laid-off”. I put quotation mark around...
2011-09-01
1,888 reads
Blogs
VPN + SQL Server Connections: Why Long-Working Setups Suddenly Fail with Msg 10054 and “Connection Broken”
By Tim Radney
Over the past few weeks, I’ve been contacted by multiple customers experiencing the same...
Future IT Roles – Agentic Architect and AI Boom!!
By Vinay Thakur
These days everything is changing to AI World, IT roles are getting changed and...
Free Webinar about Columnstore Indexes
I’m doing a small series on indexing basics for SQL Server, and on May...
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