Redoing Work
I hate redoing work. I really try to make sure that I pay attention to what I'm doing, slow down...
2008-11-12
673 reads
Blog Posts
SQLSaturday #6 - Canceled
Just heard back from Allen White, due to his schedule and minimal success creating a true team effort plans for...
2008-11-12
544 reads
SQL Quiz - Mistakes You've Made?
I'd seen Jason Massie's post on Facebook of this SQL Quiz, but when I found Brian Kelley's post, I decided...
2008-11-11
791 reads
Two Mistakes
I don't typically do Internet chain mail, but Brian Kelley mentioned me in his post on his two mistakes and...
2008-11-11
738 reads
If You are Attending PASS, Please Say Hello
I will be attending the PASS Community Summit in Seattle, November 18-21, and will be making two presentations:
DBA 101: Best...
2008-11-10
399 reads
Member of PASS? Don’t Forget to Vote for PASS’s Board of Directors
As most of you know, PASS (the Professional Association for SQL Server) is an independent, not-for-profit association, dedicated to supporting,...
2008-11-10
560 reads
PASS Board of Directors Part 4
I'm going to share what I can from the interview, but I'm going to have to be a little less...
2008-11-10
378 reads
The Security of You - Why Did I Write This?
When I first got my new laptop, I thought it was very cool. It included a fingerprint reader below the...
2008-11-10
366 reads
What’s So Great About User Groups
User groups provide so many benefits for those looking to get ahead in their career. User Groups share a common...
2008-11-10
505 reads
Beyond Managing To Middle Management
It's funny that many employees see moving into management as a way to stop actually doing work. In practice - if...
2008-11-09
244 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
setting an ssis param dynamicaly when the sql agent job runs
hi i was hoping for a more elegant way of setting a pkg level...
Query compile/runtime issue
I have a plan which in sys.query_store_plan shows: Last_compile_start_time of 2026-04-23 00:13:00.7670000 +00:00 Last_execution_time...
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
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 n;See possible answers