2008-09-01
796 reads
Editorial - WMV
Labor Day Bloopers
With the Labor Day holiday in the US, Steve Jones takes a break from writing and brings you a compilation of mistakes from the past few months.
2008-08-30
61 reads
One Milly-yon IOPS - Database Weekly (Sept 1, 2008)
IBM is testing a new hardware disk array that vastly outperforms any current arrays. What does this mean for the database world?
2008-08-30
484 reads
Un-Wired
This Friday's poll looks at vacation and how you prepare to be unwired. Steve Jones talks about some of the things you can do.
2008-08-28
51 reads
The August 2008 Energy Update
This bi-monthly update on energy news covers quite a bit of wind-related power generation happening around the world.
2008-08-27
521 reads
The Million Message System
Sun Microsystems built a database application that processes a million messages a second. Steve Jones talks about the achievement.
2008-08-26
57 reads
Working Under Pressure
A time of crisis means a lot of things to people in technology, but Steve Jones talks about something that's often forgotten.
2008-08-25
61 reads
Believe in Your Data - Database Weekly (Aug 25, 2008)
As DBAs we must secure and protect data, but what can we do when there are fundamental issues with the way the systems are designed. Steve Jones comments on problems with voting machines.
2008-08-22
238 reads
Managing Security
This Friday Steve Jones comments on the practice of using Active Directory to help manage your SQL Server and what the best practice should be.
2008-08-21
50 reads
The Brainstorm Zone
There are times we all struggle finding solutions to the issues at work. Steve Jones talks about how to make that breakthrough in solving problems when you are stuck.
2008-08-20
63 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