Event Reminder - South Florida Code Camp is February 7, 2009
The fifth annual South Florida Code Camp is being held on Feb 7th. They've got a huge schedule of sessions,...
2009-01-29
1,285 reads
Blog Posts
New Business Cards
I ordered new business cards recently after I gave one to someone that needed to send me something and realized...
2009-01-29
1,570 reads
All the Aggregate Data you Crave with Grouping Sets in SQL Server 2008
As reporting requirements increase, it seems that aggregate functions have thankfully risen to the occasion concurrently. To maintain its competitive edge...
2009-01-28
2,680 reads
Do You Want to Help Provide Feedback on a New Book I Am Writing?
Normally when I write a book, I create a book outline, give it to my editor for feedback, make some...
2009-01-28
4,077 reads
PASS Update #3
It's been busy since my last update, lots of stuff to work on! I probably won't get it all in...
2009-01-28
1,434 reads
Ruthless Focus - An Addendum
Forgot I had this, a friend had sent it to a while back as something I might blog about. Mike...
2009-01-28
1,359 reads
Who Do We Choose to Follow?
Think about your career and the managers, and potentially leaders, that you’ve had in your life. Think about life in...
2009-01-28
2,034 reads
Comulative Update package 3 for SQL Server 2008
Just to announced that we have now available the comulative update package 3 for SQL Server 2008!
This Update package...
2009-01-27
1,464 reads
DBA Education
I always consider taking seminars and technical conferences as a key component in my DBA education framework
Last week (Jan 21...
2009-01-27
1,740 reads
It's Your Ship
I saw this book (It's Your Ship) in a Barnes and Noble and the title and cover attracted me. So...
2009-01-27
1,779 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