Time Off, Recharge, Rethink
Some of you may have noticed that I haven’t posted for a while. The 12th May was the date of...
2010-05-25
625 reads
Blog Posts
Yesterday's Vermont SQL Server User Group Presentation on Database Mirroring (Official PASS Chapter for Vermont)
To celebrate the Victoria Day Holiday in Canada I drove down to the U.S.A. with 'ol Volvo Wagon (not Smart this time, since 3k of...
2010-05-25
1,393 reads
Content Copy Followup
Last week I posted an article about plagiarism. This is a follow-up to that. After posting that blog article, Steiner...
2010-05-24
940 reads
Create Indexes from the Missing Indexes DMV
Glenn Berry (Blog) writes a lot of queries to extract information from the system DMV’s. One of them in particular...
2010-05-24
2,413 reads
East Coast PASS Event Options
After asking members about where the PASS Summit should be located and then deciding to keep it in Seattle for...
2010-05-24
795 reads
Image Testing
One of the things I heard recently from someone was that they clicked some of the links in the newsletter...
2010-05-24
686 reads
It’s Done - SQLSat35
This is a strange feeling. No frantic deadlines. No daily conference calls with the team. No hurried trips to the...
2010-05-24
639 reads
MS Airlift Event in Seattle
I have posted several entries lately about events that I’ve been attending, speaking and listening at and one of the...
2010-05-24
699 reads
PASS Update #33 (SQLSaturday Transfer)
I’ve just finished handing over the source code for all the SQLSaturday related items after finishing up a couple minor...
2010-05-24
491 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
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