Summer, Summer, Summertime
This Friday Steve Jones has a poll about your summertime activities. What have you done away from work that was memorable?
2014-07-25
109 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
Quick Tips–SQL Prompt Aliases for Every Table
I love SQL Prompt, and think it’s a great productivity tool. Even before I worked at Red Gate, I love...
2014-07-24 (first published: 2014-07-17)
9,805 reads
T-SQL–Converting Seconds to Time
I was working on a small piece of code the other day that was calculating the seconds for an event....
2014-07-23
1,490 reads
2014-07-22
260 reads
2014-07-21
163 reads
Powershell Tips–Showwindow
Looking for help is a pain in Powershell. I type something like
help get-process
execute this and I’m scrolling up and down....
2014-07-21
1,162 reads
2014-07-21
2,175 reads
2014-07-04
91 reads
2014-07-04
1,880 reads
Lockdown or Let Them Free
Do we take security too far? Are we creating unnecessary rules for those that need to use the resources we support? Steve Jones talks today about security and how we might want to approach it when handling rights for developers.
2014-06-27 (first published: 2009-09-21)
244 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