PASS Summit Birds of a Feather Lunch
The absolute biggest part of the PASS Summit is the one thing that most people don’t take advantage of, networking....
2010-10-13
593 reads
The Scary DBA
SQL Saturday New England: The New Date
The real world can get in the way of important things like SQL Saturday. In the case of SQL Saturday...
2010-10-12
564 reads
SQL Saturday New England: The Date
Mark your calendars. Make your travel arrangements. Plan on being in the Boston area on April 16th, 2011. Three of...
2010-10-05
543 reads
SQL Saturday in New England
Adam Machanic (blog|twitter) has put on a SQL Saturday/Data camp event in New England for the last two years. I’ve...
2010-10-04
396 reads
How to Tell if Execution Plans are Reused
I try to watch the search phrases that point people to the blog because sometimes, you get a sense of...
2010-10-04
446 reads
Parameter Name Size And Performance
I saw an odd statement the other day, “The size of the name of the parameter does not affect performance.”...
2010-09-27
1,029 reads
SQL Saturday 46 (#sqlsat46) Recap
I was privileged to be able to attend and present at SQL Saturday 46 in Raleigh, NC, this last weekend....
2010-09-20
826 reads
Links From Twitter
Normally, I try to stick to posting technical info or community stuff on the blog, but there were a couple...
2010-09-07
569 reads
Recursive Hiearchies in Reporting Services
I am not a Reporting Services guru and nor do I play one on TV. I am however forced to...
2010-09-03
2,654 reads
Upcoming Presentations: #24HOP & #SQLSAT46
Blogging has been a bit quiet of late. That’s because I’ve been spending a lot my spare time getting ready...
2010-08-30
765 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