The Energizer Bunny
Energizer, one of the world's leading battery manufacturers, is looking to have Microsoft host much of their infrastructure.
2008-12-02
538 reads
Editorial - WMV
2008-12-01
980 reads
The Ebb and Flow of Community
Phil Factor talks a bit about the SQLServerCentral community and how we all get something different from it.
2008-11-26
531 reads
2008-11-26
617 reads
2008-11-25
501 reads
Budgeting
A bit of a rant today from Steve Jones after running into a situation that seems to make no sense these days.
2008-11-24
488 reads
Mini-Me
This Friday Steve Jones asks if you build your own mini-me's to help you manage your database systems.
2008-11-19
883 reads
E-Discovery and Data Retention
While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.
2008-11-19
912 reads
Trust But Verify
As data professionals we need to be sure that we can present back the data we receive. Perhaps other people should embrace this mantra in other lines of work.
2008-11-18
678 reads
Go Open
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
2008-11-17
569 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