PASS Report Part 2
This was my 5th year at PASS and every year I enjoy catching up with old friends and meeting many...
2007-09-23
1,357 reads
Blog Posts
SSC Site Upgrade
I see they finally rolled out the new site. Lots of annoying quirks so far, the biggest for me is...
2007-09-23
1,351 reads
Wayne Synder Elected President of PASS
Congratulations to Wayne on becoming President! I've known him for years and you couldn't ask for a guy with more...
2007-09-23
1,422 reads
SQLServerCentral.com - V3!
It's done, it's out, and check it out!!!
I guess if you got here, you've probably noticed 🙂
This was a fairly...
2007-09-22
1,402 reads
Notes from PASS - Part 3
Today was interesting. I headed for breakfast and after a few stops to chat with friends, wound up sitting with...
2007-09-21
1,469 reads
Tips for Presenters
I haven't seen a lot of sessions at the 2007 Summit, but I did go through 4 or 5 across...
2007-09-21
1,396 reads
Day 1 at the Summit
I was late, not getting up quick enough and then fighting traffic into the city. From there I did a...
2007-09-19
630 reads
Notes from PASS 2007 - Part 2
Denver is a great location for a conference. The convention center is two blocks from the 16th street mall - must...
2007-09-19
530 reads
Technical Speaking - Again
One of the points mentioned in the volunteer meeting on Tuesday was that it makes a lot of sense to...
2007-09-19
543 reads
THE Reception
After the PASS opening, which I dropped in long enough to get a beer, we had the SQLServerCentral.com party.
It seemed...
2007-09-19
604 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