MCITP: 4 Down 0 To Go
Yay. I finally took the plunge and decided to take Exam 70-451. This is the MCITP exam for the SQL...
2011-12-07
599 reads
Jason Brimhall
MCITP: 4 Down 0 To Go
Yay. I finally took the plunge and decided to take Exam 70-451. This is the MCITP exam for the SQL 2008 Dev track. Frankly, I had taken my time with...
2011-12-07
6 reads
December Event Reminder
We are now only two days away from the biggest event of the week!!
More accurately though, it is the BIGGEST...
2011-12-06
655 reads
December Event Reminder
We are now only two days away from the biggest event of the week!! More accurately though, it is the BIGGEST event for the Las Vegas chapter of...
2011-12-06
3 reads
All I want for Christmas…Meme Monday
This is a good way to start monday, with a meme. This month Thomas LaRock has provided us with the...
2011-12-05
677 reads
All I want for Christmas…Meme Monday
This is a good way to start monday, with a meme. This month Thomas LaRock has provided us with the theme and his entry here. I thought of following...
2011-12-05
7 reads
Database Data and Log Size Info
Have you ever wanted or needed to get the data and log file size for all of the databases in...
2011-12-05
2,415 reads
Database Data and Log Size Info
Have you ever wanted or needed to get the data and log file size for all of the databases in your server? I have seen scripts that would get...
2011-12-05
19 reads
December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out...
2011-11-30
1,628 reads
December 2011 LV UG Meeting
The Holidays are upon us. It is time to take a break from the hustle and bustle and come out to participate in the local User Group for SQL...
2011-11-30
9 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