A Good Case For Reference
Steve Jones is looking for some interesting application ideas using SQL Server that can help teach people how to take advantage of features.
2008-07-14
70 reads
Editorial - WMV
Software for Profit
Steve Jones will be attending the Business of Software conference in September and gives a few reasons why this is an interesting topic to him.
2008-07-13
58 reads
The Database Weekly Update for July 14, 2008
Steve Jones talks about data mining in the drug industry and the advantages of cheap software.
2008-07-11
183 reads
DIY
For this Friday, Steve Jones has a poll about life outside of work and how much you tinker with things.
2008-07-10
52 reads
The Value of an MBA in IT
Do you have an MBA? If so, has it helped you? Is it worth getting one for someone in IT? Ted Pin comments.
2008-07-09
64 reads
What's an MVP?
What does it mean to be an MVP for Microsoft? Steve Jones talks about what the award is and what it means to get the award.
2008-07-08
65 reads
Land Mines
Security can be a hassle, but Steve Jones talks about why we sometimes put up with the difficulties of implementing strong security.
2008-07-07
49 reads
Enough is Enough
When do you decide that enough is enough? When does it make sense to let some bugs go and fix them later? Steve Jones comments on the decisions you sometimes make.
2008-07-06
57 reads
The Database Weekly Update for July 7, 2008
Intel is moving in the direction of more and more cores on a single CPU, so what does that mean for programmers?
2008-07-03
204 reads
Happy 4th of July
A blooper collection of mistakes and errors from a variety of editorials on this holiday weekend.
2008-07-03
587 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