People I Can’t PASS on Meeting
One week from today I will be in Seattle for my first ever PASS Summit. One of the things I...
2009-10-26
600 reads
Blog Posts
Special Events at PASS Summit
Besides giving two Community Session presentations (here and here), next week, I will be involved in the Birds of a...
2009-10-26
608 reads
SQL Saturday #21 (Orlando) Presentation Downloads
Here are the slide decks and code samples from my sessions at SQL Saturday #21 Orlando on 10\17. I've also...
2009-10-26
407 reads
SQL Saturday #21 (Orlando) Recap
Saturday, 10\17, marked the third year for SQL Saturday here in Orlando and each year it gets bigger and better....
2009-10-26
790 reads
SQLSaturday Sensation in NJ
Well, it's a wrap! Saturday has come and gone, but memories will go on. It was great to see so...
2009-10-26
752 reads
Business Cards – Again
I posted some thoughts on business cards awhile back, had used up the ones I had and was time to...
2009-10-25
678 reads
My Eval Results from SQLSaturday #21
I presented Social and Not So Social Networking for the DBA. Of the attendees, 16 submitted an eval. Here are...
2009-10-25
554 reads
Phil Factor SQL Speed Phreak Competition
If you have a database application that is running slowly, or is straining the server, what do you do? After...
2009-10-25
3,144 reads
SQL University: Authentication and Authorization
Welcome back to class, folks, here at SQL University. This week we're going to take a look at the basics...
2009-10-25
10,872 reads
Red Gate Has 10th Birthday
I first met Simon Galbraith, one of the co-owners of Red Gate Software at PASS in 2002, when they had...
2009-10-24
408 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