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...
2011-08-29
7,075 reads
Blog Posts
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
Notes From The 2011 Jacksonville Code Camp
In a departure from my usual plan, this year I drove up to Jacksonville mid-morning in time to have a...
2011-08-29
831 reads
SQL Saturday #90 OKC
This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first...
2011-08-29
919 reads
SQL Saturday #90 OKC
This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first...
2011-08-29
829 reads
SQL Saturday #90–Oklahoma City recap as chauffeur and speaker
I’d never been to Oklahoma City, and when Kristin Ferrier asked me to come to SQL Saturday #90 and do...
2011-08-29
922 reads
SQL Server Hardware Choices Made Easy
Redgate has released a free eBook that I wrote called SQL Server Hardware Choices Made Easy. This is basically a...
2011-08-29
1,967 reads
SSIS For Each Loop over files with Date in Name
A common request I have received over the years is to move or copy files from one directory to another...
2011-08-29
10,507 reads
The Basic Security Model in SQL Server – Skill #3
This series of blog posts are related to my presentation, The Top Ten Skills You Need, which is scheduled for...
2011-08-29
3,457 reads
Time Flies When You're Having Fun
I've done it; I've violated one of the rules I give to people who are interested in blogging: I went...
2011-08-29
767 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