Should I Run for the PASS Board of Directors?
I saw the recent Call for Nominations for the election this year, so the title of this post is only...
2008-10-13
521 reads
Blog Posts
SQL Server MVP
Can't say I ever expected to say this, but as of October 1st I'm a SQL Server MVP. A nice...
2008-10-13
874 reads
SQL Saturday in Olympia , WA Pulls in Crowd of over 130 DBAs and Developers
A SQL Saturday event was held Saturday, October 11, 2008 in Olympia, WA. Sponsored by the Olympia Area SQL Server...
2008-10-11
562 reads
Database Health - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-10
617 reads
One File Per Core?
For a long time in my career I heard various advice on how many files you should create for a...
2008-10-10
955 reads
Do You Understand Microsoft Licenses?
I had an email from a friend recently asking about a licensing question pertaining to Microsoft. It reminded me of...
2008-10-09
540 reads
Meeting My Goal
Last year I was talking about goals and changes for the site as I was negotiating my continued employment with...
2008-10-09
838 reads
Project Management Management - Why Did I Write This?
Why did I write this? I got challenged by Andy Warren
to write a bit about why I wrote something. I...
2008-10-09
931 reads
Tulsa TechFest Draws a Crowd of Over 500
The annual Tulsa TechFest (Tulsa, OK) had over 500 attendees today (Thursday), and is expecting another 500+ attendees on Friday....
2008-10-09
441 reads
Validating text data. A few techniques.
/*datafile used in the SQL */
DECLARE @String VARCHAR(MAX)
SELECT @String = 'When you are starting out to validate text input, perhaps to clean...
2008-10-09
1,094 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