The Wise Old Man Part 1
During one of the sessions that I attended during SQL Saturday in Orlando I had the privilege of listening to...
2008-10-29
1,691 reads
Blog Posts
Thoughts on .Net Reflector Being Acquired by Red Gate
This is an unpaid/unsolicited comment about a product now owned by Red Gate Software. Purely my opinions, and I'll try...
2008-10-29
1,602 reads
A Break
Only a small one, but I appreciate every one I get. Not often that I get to leave the site...
2008-10-28
1,472 reads
Effecting Change
Over the years Andy Warren, Brian Knight, and I have talked about PASS quite a bit. It hasn't always been...
2008-10-28
1,433 reads
Free/Cheap/Good HTML Editor, Is There Such a Thing?
For the past few years I've been using Frontpage 2003 for basic HTML work, usually to write content for SQLServerCentral....
2008-10-28
1,351 reads
Miramar User Group and SQL Saturday Presentations
Here are the two presentations from last week. On Thursday I went to Miramar, Florida and presented Fortress SQL Server....
2008-10-27
1,565 reads
Post Event Notes - SQLSaturday #8
Yesterday I posted an overview of the event, today I want to go over some areas where we excelled, and...
2008-10-27
1,330 reads
Post Event SQL Saturday #8 Orlando
This weekend I spoke at Seminole Community College with a session on Reporting Services 2008. If your interested you can...
2008-10-27
1,418 reads
Absolutely (Not?) - Why Did I Write This?
I've always been a little bit of a strong DBA. I try to get along and work with people, being...
2008-10-26
1,600 reads
SQLSaturday #8 - Orlando
The whole idea of having free events, bringing learning to people locally wasn't something that I was thrilled with. It's...
2008-10-26
1,436 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