SQL Server 2008 SP1 CU14 and SQL Server 2008 SP2 CU4 Released
Microsoft has released two new Cumulative Updates for SQL Server 2008 SP1 and SQL Server 2008 SP2. The first one...
2011-05-17
1,525 reads
Glenn Berry
May 2011 SQL Server 2008 Diagnostic Information Queries
Since we are in the middle of May 2011, I thought was was time to update my SQL Server 2008...
2011-05-16
640 reads
PASS Summit 2011 Session Preference Survey
PASS has added a new feature to the session selection process for the PASS Summit 2011, which they are calling...
2011-05-11
607 reads
Speaking at Colorado Springs SQL Server User’s Group on June 15
I will be speaking at the Colorado Springs SQL Server User’s Group, live and in person, on Wednesday, June 15,...
2011-05-09
516 reads
PASS 2011 Summit Abstract Submissions
Today is the last day to submit session abstracts for the PASS 2011 Summit. I was lucky enough to speak...
2011-05-04
478 reads
A SQL Server Hardware Nugget A Day – Day 30
For Day 30 of this series, (which is the last day), I am going to talk a little about RAID,...
2011-05-01
938 reads
A SQL Server Hardware Nugget A Day – Series Recap
Writing a month long series is always a lot more work than you initially expect. You would think that I...
2011-05-01
638 reads
A SQL Server Hardware Nugget A Day – Day 29
For Day 29 of this series, I am going to talk about some of the basic things that you should...
2011-04-30
1,397 reads
A SQL Server Hardware Nugget A Day – Day 28
For Day 28 of this series, I am going to talk a little bit about some upcoming developments in Intel...
2011-04-28
1,643 reads
A SQL Server Hardware Nugget A Day – Day 27
For Day 27 of this series, I am going to talk a little bit about disk performance and one easy...
2011-04-27
1,319 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