A SQL Server Hardware Nugget A Day – Day 2
For Day 2 of this blog series, I am going to talk a little about the upcoming Intel Westmere-EX processor...
2011-04-02
544 reads
Glenn Berry
Intel Sandy Bridge Mobile Processors Explained
The long wait for the new, mobile Sandy Bridge processor equipped laptops is nearly over. Most of the large system...
2011-03-24
1,123 reads
Presenting To Columbus SQL Server User’s Group on April 14
I will be doing a live, virtual presentation for the Columbus, Ohio SQL Server User’s Group on Thursday, April 14....
2011-03-23
788 reads
Microsoft System Center Advisor (Release Candidate)
Microsoft’s Brad Anderson announced the availability of the Release Candidate of Microsoft System Center Advisor today in his keynote presentation...
2011-03-22
1,498 reads
SQL Server 2005 SP3 Cumulative Update #15
Microsoft has released SQL Server 2005 SP3 Cumulative Update 15, which is Build 9.0.4325. There are only six fixes included...
2011-03-22
682 reads
SQL Server 2005 SP4 Cumulative Update 3
Microsoft has released SQL Server 2005 SP4 Cumulative Update 3, which is Build 9.0.5266. There are only five fixes listed...
2011-03-22
1,360 reads
SQL Server 2008 SP1 Cumulative Update 13
Microsoft has released SQL Server 2008 SP1 Cumulative Update 13, which is Build 10.00.2816.00. I count twelve fixes listed in...
2011-03-22
552 reads
SQL Server 2008 SP2 Cumulative Update 3
Microsoft has released SQL Server 2008 SP2 Cumulative Update 3, which is Build 10.00.4279.00. I count 25 fixes listed in...
2011-03-22
1,234 reads
Are You Taking Advantage of Twitter for SQL Server?
One thing I always do lately, whenever I give a presentation is ask the audience how many of them use...
2011-03-18
885 reads
Teaching Two Classes at University College–University of Denver
I will be teaching two classes for the Spring 2011 Quarter at University College – University of Denver. One will be...
2011-03-18
502 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