Can Wives Shorten Work Hours?
This editorial was originally published on Jun 23, 2005. It is being reprinted today as Steve is on vacation. It talks about the impact of long hours on families.
2010-09-27
258 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
People are talking about you
I was listening to a friend give a presentation on getting a job recently. In the presentation, Chris Shaw, the...
2010-09-27
967 reads
A day of rest
Not quite a day of rest, likely some chores in advance of another busy weekend at the ranch.
I’m taking today...
2010-09-24
718 reads
Food Drive
Don’t forget the food drive tomorrow for SQL Saturday #52 in Colorado. Please bring food, or even clothing/blankets, that can...
2010-09-24
627 reads
Common SQL Server Mistakes – Multi Row DML Triggers
How often have you seen someone write a DML trigger like this:
createtrigger mytrigger on Mytable forinsertas
declare @id int
select @id = id...
2010-09-23
15,412 reads
Community Direction
Steve Jones wishes that Microsoft had a way for the community to give better feedback about what we see as a priority in the next version of SQL Server.
2010-09-23
66 reads
Braindumps and Certification
I saw a post recently that said that braindumps were the best way to prepare for certifications. It was posted...
2010-09-22
1,887 reads
What Do We Need in SQL Server?
Steve Jones asks us today about what we might like to see in the next few versions of SQL Server.
2010-09-22
283 reads
Five Things I Learned at the PASS Summit
Steve Jones has attended the PASS Summit almost every year, and in that time he's learned a few things. He shares a few today that might convince you or your boss that it's worth funding the trip this year.
2010-09-21 (first published: 2010-05-17)
5,232 reads
NoSQL Is Not Everywhere
NoSQL has been getting a lot of press in the last year, but it's not necessarily the best platform or solution for you. Steve Jones comments on NoSQL and alternative platforms.
2010-09-21
381 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