Covert It Live
I watch the Geekbrief update a few times a week, partially to see new gadgets and partially to see how...
2008-01-15
736 reads
Blog Posts
SQL Server 2005 Replication bug?
Last week, in our production, we noticed some records are missing in the subscriber side while existing on the publisher...
2008-01-15
920 reads
E-Readers, Will They Ever Take Off?
I was discussing the Kindle recently with business partner Steve Jones and while we both like the idea of having...
2008-01-14
485 reads
Hot Subtract
Over the last few weeks I've seen a few posts about the new Hot-Add CPU feature in SQL Server 2008....
2008-01-14
795 reads
Evaluating Speakers at Events
Speakers tend to live for the evals. Hopefully it's a validation of work done well after a lot of time...
2008-01-09
913 reads
On the Importance of Documentation...
It seems that I keep inheriting old systems that provide a singular, albeit mission critical, function to their owners. In...
2008-01-09
539 reads
Sometimes You Need an Analog Solution, Sorta - Earth Class Mail
Spotted this on the Webware feed, Earth Class Mail is a service that opens and scans your regular mail so...
2008-01-09
499 reads
SQL Injection, Again!
Many posts including this one about as many as 70,000 sites being hacked using SQL injection and a vulnerability in...
2008-01-09
630 reads
Partitioning Part 3 Posted on SSC
Part looks at using views for partitioning, still a valid technique even in the SQL 2005 world. I added in...
2008-01-08
259 reads
ACM Queue Article about One Laptop Per Child
If you happen to read ACM Queue there is a great article in the Nov/Dec 2007 issue called 'A Conversation...
2008-01-07
280 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