Better Technical Interviews
Technical interviews don't work great, but are they dead? Is there a better way? Steve Jones comments today.
2013-06-27
356 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
SQLServerCentral Runs sp_Blitz - Informational Items
The sixth article in our series that looks at the results of the sp_Blitz™ script run against the SQLServerCentral servers.
2013-06-27
4,674 reads
Great Engineering Culture
Building great culture in a company is hard, and it takes work. Building great engineering culture can be more challenging, given the strong ideas and opinions people have in technology. Steve Jones has a few thoughts today.
2013-06-26
152 reads
More Data Security Issues
The state of data security is getting better in the US, according to the 2013 survey from Symmatec. However we still have issues.
2013-06-25
121 reads
Don’t Use MD5
“The hashing alone being MD5 tells me that they really don’t care about their passwords too much, so it’s probably...
2013-06-24
930 reads
When Is Work, Work?
Where is the dividing line between work time and personal time? As more and more employees get new phones, such as the Blackberry and iPhone, is the line becoming too blurred? Are there legal implications?
2013-06-24 (first published: 2008-09-09)
304 reads
A Release from Data
What do you do when work is too frustrating. Steve Jones talks about finding a way to release stress and frustration.
2013-06-21 (first published: 2008-08-14)
210 reads
Lost in Space
It seems a tremendous amount of data is lost every year on laptops in airports. Steve Jones talks about some of the issues with physical security and your portable computers.
2013-06-20 (first published: 2008-09-03)
186 reads
SQL Server Should Work for Us
SQL Server is a great platform, but there are problems in places. Steve Jones thinks that fixing some issues might be a good investment for Microsoft.
2013-06-19
203 reads
Speakers: Rehearsals Help
Today was a rehearsal day. Actually the last 2-3 days of work have been split between rehearsing talks that I’m...
2013-06-18
837 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