Rules of Holes #5: Seek Help to Get Out of the Hole
You are moving along, doing good work, maintaining a steady pace. All seems to be going well for you. Then...
2012-11-19
667 reads
SQLSequel
Rules of Holes #4: Do You Have the BIG Picture?
Some folks decry the concept of being in a 'Hole'. For them, there is no such thing as 'Technical Debt', no such thing as maintaining weak and wobbly legacy...
2012-11-16
4 reads
Rules of Holes #4: Do You Have the BIG Picture?
Some folks decry the concept of being in a 'Hole'. For them, there is no such thing as 'Technical Debt', no such thing as maintaining weak and wobbly legacy...
2012-11-16
10 reads
Rules of Holes #4: Do You Have the BIG Picture?
Some folks decry the concept of being in a 'Hole'. For them, there is no such thing as 'Technical Debt',...
2012-11-16
848 reads
Rules of Holes #3: A Better Shovel is NOT the Answer!
You stopped digging. You looked around and saw that you were still in the Hole. You needed to get out. AHA! Problem solved, you thought. You'll just get a...
2012-11-15
6 reads
Rules of Holes #3: A Better Shovel is NOT the Answer!
You stopped digging. You looked around and saw that you were still in the Hole. You needed to get out. AHA! Problem solved, you thought. You'll just get a...
2012-11-15
5 reads
Rules of Holes #3: A Better Shovel is NOT the Answer!
You stopped digging. You looked around and saw that you were still in the Hole. You needed to get out....
2012-11-14
668 reads
Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
12 reads
Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are still in a Hole. Your situation has not changed...
2012-11-14
8 reads
Rules of Holes #2: You Are Still in a Hole
OK. So you followed the First Rule of Holes -you stopped digging yourself in deeper. But now what? You are...
2012-11-13
616 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
Are luxury packages in Andaman suitable for a honeymoon?
Yes, luxury packages in Andaman are highly popular among honeymooners due to their romantic...
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...
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