The Development Backup
Backing up your development environment can be important. After all, aren't your developers producing products that you use?
2014-05-20
153 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
FileTable– Using GetParent for Inserts
In a previous post, I looked at the ways in which I could insert files into a Filetable folder programmatically....
2014-05-19
1,355 reads
Patching Problems
Problems with SQL Server after applying the Windows 8.1 update have Steve Jones concerned about software updates.
2014-05-19
103 reads
Failure
This week Steve Jones has a poll to make you think based on Tim O'Reilly's look back at how he succeeded and failed with his company.
2014-05-16
137 reads
2014-05-16
1,646 reads
Powershell Tips–PSEdit
I got this from watching a session from Jeffrey Snover at TechEd. It was a neat trick, and it’s worked...
2014-05-15
1,435 reads
Why Don't We Have Better Practices?
It seems as though the quality of much software isn't very good. What is that? Couldn't we do better? Certainly some people write much better code. Why can't the rest of us imitate them?
2014-05-15
287 reads
2014-05-15
1,466 reads
2014-05-14
768 reads
Better Training
What are better ways to train people to work in the technology field? Steve Jones has a few ideas.
2014-05-13
186 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers