SQL Agent Job failure with FTP connection
There are hundreds of post on this topic but I just ran into this problem recently so I thought I...
2009-03-04
1,530 reads
Blog Posts
A Mention on SQL Authority
I met Pinal Dave, whose blog I've followed for a year or so and just started to correspond with. A...
2009-03-03
577 reads
Book Review - Team of Rivals: The Political Genius of Abraham Lincoln
I've been reading this for a few weeks and finally finished. Team of Rivals came up during the Presidential campaign...
2009-03-03
342 reads
Branding on ESPN
I was listening to Colin Cowherd and the Herd one morning and he was talking about the Los Angeles Dodgers...
2009-03-03
589 reads
Cube Processing Error HY008
If you've ever had this error "OLE DB error: OLE DB or ODBC error: Operation canceled; HY008." appear while processing...
2009-03-02
34,675 reads
PASS Update #7
A very short update this week, the minutes of the January 2009 board meeting have been posted. Going forward we've...
2009-03-02
351 reads
Reminder: Orlando SQL Server User Group Meeting is March 11, 2009
Our next oPASS/Orlando user group meeting is coming up soon on March 11, 2009, and as usual is held at...
2009-03-02
328 reads
SQL Saturday
I’ve been pretty lucky in my career to have the opportunity to attend quite a few conferences. I’ve attended one,...
2009-03-02
1,185 reads
Red Gate Software Supports SQLSaturday
If you've read my blog over the past year and a half you know that I've been heavily involved in...
2009-03-01
283 reads
An Optimised Disaster Recovery Plan thanks to SQLBackup
The continuity of operations during a disaster is as critical to running a business as just about anything. Somewhere, within...
2009-02-28
2,298 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
Hiring: Financial SQL Systems Administrator
Fisher Phillips is looking for a Financial Systems Administrator to help support and improve our financial...
Job Opening for ERP Systems Administrator - Hybrid
Employee owned company, been around for over 50 years. Hybrid opportunity, looking folks in Pacific...
data compare between 2 tables with same structure for any changes after etl run
i have huge table with lot of data and is also wide. i took...
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;See possible answers