Daily Coping 25 Jan 2023
Today’s coping tip is to be gentle with yourself when you make mistakes. I forgot about a commitment. I had agreed to do a webinar and prepare some content....
2023-01-25
9 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
Losing Track of Data
Facebook isn't sure where all your personal data is stored. Are you sure your organization is any different?
2023-01-25
106 reads
Daily Coping 24 Jan 2023
Today’s coping tip is to get outside and notice five beautiful things. I decided to do this on a snowy, stormy day in Denver. I was up early with...
2023-01-24
11 reads
Daily Coping 23 Jan 2022
Today’s coping tip is to eat healthy today with some nourishing food. A few days before think I was getting ready for my daughter to leave for university. I...
2023-01-23
15 reads
The Challenge of Deleting Data
Removing data from your systems isn't as easy as you might think. It is especially important to be aware when you are doing this for compliance.
2023-01-23
210 reads
Creating a PostgreSQL Docker Container with a Volume on Windows
This post looks at how to set up a PostgreSQL container on Windows using Docker for Windows. I’ve seen a few posts, but I had to cobble together some...
2023-01-20 (first published: 2023-01-09)
325 reads
Daily Coping 20 Jan 2023
Today’s coping tip is to take a different route today and see what you notice. I’ve had this tip come up a few times and each time I’ve enjoyed...
2023-01-20
16 reads
2023-01-20
168 reads
The Cost of Employee Turnover
Culture is important retaining employers. Companies are finding this more valuable every day.
2023-01-20 (first published: 2023-01-07)
222 reads
Daily Coping 19 Jan 2023
Today’s coping tip is to switch off tech an hour before bedtime. I read at night often, so this is a challenging one. However, I decided to give this...
2023-01-19
22 reads
Blogs
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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