SQL Standard Update
Andy Warren in the latest PASS Connector has posted an update on where we’re at with the SQL Server Standard....
2009-12-02
648 reads
Blog Posts
Under Repair
I’m glad I called Toshiba last night. When my laptop died on Sunday, and never came back Monday, I wasn’t...
2009-12-02
341 reads
What It Means To Be A Production DBA
Remember that scene from Office Space where the Bobs ask, "What would you say you do here?" I've been a...
2009-12-02
538 reads
a simple joint that makes you think twice
I was reading Two Minute SQL Server Stumpers a few weeks ago and this qustion still sticks in my head. ...
2009-12-01
576 reads
Baton Rouge SQL Server User Group - Overview of Business Intelligence
Topic
An Overview of Business Intelligence
Location: At Lamar Advertising
Wednesday, December 2, 2009
6:00 PM - 8:00 PM
Sponsored by: EMCPresenter
Brandon McMillon
Brandon McMillon...
2009-12-01
564 reads
BIDN.com Launch Today
For those interested in the SQL Server BI space, there is a new online resource launching today. Brian Knight and...
2009-12-01
1,061 reads
Congratulations to Christopher Graham for Taking Companies to Task About Protecting Data Privacy
The New Information Commissioner for the United Kingdom is Mr. Christopher Graham, he's working from Wilmslow, near Manchester, with a...
2009-12-01
1,349 reads
December 2009 – Baton Rouge SQL Server User Group
December SQL Server User Group Meeting
Location: At Lamar Advertising
Wednesday, December 2, 2009
6:00 PM - 8:00 PM
Sponsored by: EMCTopic
An Overview of...
2009-12-01
501 reads
Google Dashboard
Recently announced, Google Dashboard shows some but not quite all of the data that Google has accrued about you – a...
2009-12-01
1,124 reads
How do -You- use SQL Server
I’ve been tagged by a misplaced yankee, uh, New Englander, whatever. The question is, how do I/we use SQL Server...
2009-12-01
773 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