Book Review: The Art of Making Money
In this case making money is about counterfeiting. The Art of Making Money: The Story of a Master Counterfeiter ($18)...
2009-10-01
391 reads
Blog Posts
Perth .NET Users Group First Stop of Down Under Tour
As the first stop of my five city speaking tour of Australia, I spoke at the Perth .NET Users Group...
2009-10-01
591 reads
Reverse Image Search
I try not to post too many links without some thoughtful commentary, but I ran across this and thought it...
2009-10-01
273 reads
Speaking at SQLSaturday #21 – Orlando
Well, I guess this isn’t a surprise since I put together the schedule, but I’m still excited to be speaking...
2009-10-01
313 reads
Tips for Networking at PASS
This year will be my third trip to the PASS conference. If you have met me or had any conversation...
2009-10-01
827 reads
Eliminating Empty Output Files in SSIS
So you’ve got some packages that regularly extract data to one or more text files, but you know that from...
2009-09-30
13,965 reads
Heading Down to the Basement
I'm taking the next two days off, heading down into the basement for a four day weekend. Nothing particular going...
2009-09-30
1,476 reads
Idea for PASS Summit 2010 – Share Your Other Passions
I’ve had the glimmer of this idea since I posted about the idea of bringing my chair to the 2009...
2009-09-30
1,386 reads
Minor Celebration
A little cheap thrill for me. I passed 50,000 views on the blog yesterday. Thanks to everyone who has stopped...
2009-09-30
1,385 reads
On vs. Where
Does it matter if you put your criteria in the ON clause or the WHERE clause? Well, as with most...
2009-09-30
1,771 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