I’m a Pain
Or maybe I’m misreading that I’m supposed to be helping to alleviate pain. Either way, next Thursday, June 17, I’ll be...
2010-06-10
555 reads
The Scary DBA
PASS 2010 Submissions
Since all the cool kids seem to be posting the sessions that they submitted to the PASS Summit, nerd that...
2010-06-09
805 reads
Buy vs. Build
It’s the classic question faced by everyone in Information Services. I know how to do this and I could build...
2010-05-28
1,598 reads
Slick New Software
I’m lazy. And frankly, I’m not ashamed to admit it. When a software comes along that can do the work...
2010-05-24
1,281 reads
Recompiles and Constant Learning
When faced with a procedure that looks like this:
CREATE PROCEDURE dbo.TestProc (@TestValue INT)
AS
BEGIN
IF @TestValue = 1
BEGIN
SELECT *
FROM Sales.SalesOrderHeader AS soh
JOIN Sales.SalesOrderDetail...
2010-05-11
773 reads
PASS Summit, Kilt Wednesday
Last year at the PASS Summit we held a silly little event called Kilt Wednesday. Only three people took part,...
2010-04-27
1,402 reads
PASS Summit Content Survey Results
The results of a survey conducted by the PASS organization have been posted (thanks to the Board for all their...
2010-04-22
634 reads
SQL Server Standard: Volume 7, Issue 3
FINALLY!
It’s not like Don Gabor had the article done in January or anything…oh wait. He did have the article done...
2010-04-21
690 reads
SQL Saturday #39, New York, New York
A town so big they named it twice.
If you’re not excited about SQL Saturday in NYC this weekend… why not?...
2010-04-20
511 reads
Powershell Script for Verifying Space
First let me say, I know my Powershell skills are sub-par. I’m working on it. Slowly but surely. That said,...
2010-04-19
1,205 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