A Better Database Engine
How much different can a database engine make to a platform? MySpace was recently mentioned along with database technology from Sun Microsystems that might make them more profitable.
2008-10-06
73 reads
Editorial - WMV
Social Hacks
We try to keep control of the data in our databases, but as the world becomes more connected, it's harder to ensure integrity. Steve Jones talks about some of the issues in this new Web 2.0 world.
2008-10-05
70 reads
The Weekly News for Oct 6, 2008 (Database Weekly)
Steve Jones looks back at some of the news from the week ending Oct 6, 2008.
2008-10-04
491 reads
Speed or Value?
Everyone wants extreme performance from their systems, but is that always the way to look at things? This Friday Steve Jones asks about how you consider performance in your purchasing decisions.
2008-10-02
61 reads
Jumping the Gun
How quickly should security issues be reported? Steve Jones isn't sure, but he talks a bit about what we might want to do.
2008-10-01
254 reads
Managerial Relations
Steve Jones talks a bit more about the employee manager relationship in this turbulent times.
2008-09-30
63 reads
The Relational Manager
Managing DBAs can be a challenge for both sides. Steve Jones talks a bit about some of his relationships with managers and the trouble that sometimes occurs.
2008-09-29
76 reads
The September 2008 Car Update
This month's car update focuses mainly on the Prius and changes that might coming in the car industry.
2008-09-28
503 reads
The New Leader - Database Weekly (Sept 29, 2008)
A new SQL Server system has claimed the top spots in the TPC-E benchmark, but Steve Jones doesn't think it's that impressive.
2008-09-26
481 reads
Should He Stay or Should He Go?
Read the first page of the linked article and then cast your vote in this Friday's poll.
2008-09-25
74 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
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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