I like this
Not everything that can be counted counts, and not everything that counts can be counted. - Albert Einstein
from 37 signals blog.
2009-09-11
937 reads
Blog Posts
LaRock on Monitoring
Since I just spent a bit more than half of my 24 Hours of PASSpresentation on tuning queries talking about...
2009-09-11
654 reads
Memories Of PanzerBlitz
Back when I was a small tyke, I vividly remember playing an Avalon Hill board game called PanzerBlitz, which was...
2009-09-11
1,083 reads
Running a Server Side Trace
This is part two of three part series on creating, running, and scheduling Server Side Traces in SQL Server. Part...
2009-09-11
2,802 reads
Thanks Space Coast SQL User Group
I want to thank the Space Coast User Group for having me over to speak on the Default Trace last...
2009-09-11
366 reads
What I’ve Read and Recommend to Others – Joe Celko Edition
I’ve known Joe for a number of years and have a lot of respect for his experience and knowledge around...
2009-09-11
857 reads
Building a Chair – Part 1
I glance at Make (magazine and web site) from time to time, and recently have been recording and watching their...
2009-09-10
808 reads
Columbus User Group webcast on SQL Server locking
Later this afternoon, I’m presenting at the Columbus, Ohio, SQL Server User Group meeting. The topic: SQL Server Locking and...
2009-09-10
356 reads
Denver SQL Server User Group Board Meeting Notes from 20090901
To address a few questions on what does the board actually do and to bring more visibility to all of...
2009-09-10
698 reads
Don't Make Me Work, VIA Rail
I got an email the other day from Canada's VIA Rail, advertising "Discover Canada by Train" and the chance to...
2009-09-10
884 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
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...
How do I explain that SQL Server should not be used as a code repository?
This week my BI Developer colleague proudly showed me a new Power BI report...
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