First Blog Since the PASS Summit
The time following the PASS Summit has been absolutely crazy for me. Upon returning home I spent some much needed...
2011-12-08
544 reads
Tim Radney
When training is just that good!
I have the privilege of attending SQL Skills Immersion Event week one in Atlanta GA this week. My expectations were...
2011-12-08
505 reads
Summit Sessions Day 2
Day two of sessions only had me attending three sessions. One of them was 3 hours. I started out after...
2011-10-15
606 reads
Summit Sessions Day Three
I started out day three after the keynote by attending Adam Machanic session on Query Tuning. I must say that...
2011-10-15
613 reads
Final Summit Keynote – NoSQL = Not Only SQL
The keynote started out with Rob Farley and Buck Woody singing an awesome song about a slow running query. What...
2011-10-14
1,624 reads
Day four of Summit – Keynote 2 #sqlpass
The keynote started out with Bill Graziano taking to the stage in a kilt and declaring that the second day...
2011-10-13
1,111 reads
Summit Sessions Day 1 #sqlpass
Today was our first day to attend regular sessions. With over 189 sessions being offered over 3 days there are...
2011-10-13
697 reads
Day three of Summit Keynote
Last year we set out some very high goals. 1 million technical training hours, 250k members in the community, and...
2011-10-12
975 reads
Second Day of Summit
The second day of the Summit was full of even more pre-con’s. Word on the street last night is that...
2011-10-12
945 reads
First Day of Summit
My first day in Seattle has ended. My flight arrived around 12:30 and I was in good company with John Lang and Julie Smith on the same flight. We rode the light rail...
2011-10-12
642 reads
Blogs
How to Connect to SQL Server When Nothing Else Works – DAC
By gbargsley
It's 2 AM. Your phone is going off. Users can't connect to the application,...
Get a Range of Sequence Values: #SQLNewBlogger
By Steve Jones
I discovered a procedure recently that I wasn’t aware of: sp_sequence_get_range. This post looks...
The Agent Era: When “How do I…?” Replaces “Where do I click?”
By Arun Sirpal
After a year away getting to grips with AI and its application across the...
Forums
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers