NetFlix and Null
There are some progressive companies out there, and I think they are doing some very interesting things with how they...
2010-08-30
1,568 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
Project Phoenix
A great new project kicked off by MVP Arnie Rowland is available to people out there struggling with their careers, but looking to continue to grow them.
2010-08-30
235 reads
Connectify
It’s a wired world. You’d think by this point, most major hotels, at least those costing upwards of $100/night, would...
2010-08-27
1,045 reads
Individual Contributions
Each person on a team, or even in a company, can contribute something. Steve Jones reminds us not to assume we are better than others because of our job.
2010-08-26
178 reads
SQL Saturday #28 - Keynote
I was honored to be asked to do the keynote for SQL Saturday #28 in Baton Rouge recently. It’s taken...
2010-08-26
871 reads
SQL Saturday #28 - Slides and Impressions
I’m late, I suck, but here’s some things I started in Baton Rouge and am just now getting out.
First, I’ll...
2010-08-26
954 reads
The DBA Financial Analyst
Will DBAs need to perform more complex financial analysis of the options they consider when building and tuning software systems? Steve Jones thinks it might be a skill needed in cloud computing.
2010-08-25
233 reads
You Don’t Need Log Backups
You don’t need log backups. You don’t. They aren’t required for SQL Server to function.
The place when you don’t need...
2010-08-25
745 reads
When To Touch
When can you modify a database that supports some third party product? Steve Jones has a few thoughts and warns you to be careful.
2010-08-24
145 reads
Rating Bugs
How do you triage and rate the bugs that come in for software? How should Microsoft do this for SQL Server. Steve Jones has a few comments.
2010-08-23
109 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