PASS Regional Mentor
Wow, how time flies by. It seems like just a month ago I was made the PASS Regional Mentor for...
2011-08-30
1,401 reads
Blog Posts
Strong Manager or Weak Manager?
Here’s the link to my editorial on SSC last week. I was pleasantly surprised by the discussion, and was interested...
2011-08-30
1,722 reads
Tribes: We Need You to Lead Us
I’ve finished my 3rd book as part of my year long commitment to read and review professional/personal development books. I...
2011-08-30
763 reads
TRUNCATE_ONLY is not a recognized BACKUP option
Executing the code below in SQL Server 2008 will throw an error message:
BACKUP LOG ‘MyDatabase’ WITH TRUNCATE_ONLY
Msg 155, Level 15,...
2011-08-30
9,123 reads
T-SQL Enhancements: FIRST_VALUE() and LAST_VALUE()
A couple a weeks ago I blogged about a few of the enhancements in the OVER clause, and now I...
2011-08-30
4,630 reads
Using PowerShell to Monitor SQL Server
By Ian Treasure
Over the past few years, I have used a number of approaches to monitor SQL Server. For example,...
2011-08-30
7,316 reads
Applied SQL: Server Side Traces
It’s time to get your server side trace on, with a little practical application!
I introduce this whole concept in Applied...
2011-08-29
767 reads
Code Camp New Zealand 2011
I was unable to go to TechEd this year but I did get a chance to hit up Code Camp. It...
2011-08-29
924 reads
Creating Facebook page for blog
Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm...
2011-08-29
841 reads
Inserting Records AND Getting The Identity in SSIS - Part 2
Since I posted a ways back on retrieving the identity value for inserts in SQL Server Integration Services, I've learned many things - one of which is an inline solution for...
2011-08-29
56 reads
Blogs
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...
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
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