5 Things to Know About Indexes for SQL Server
One of the first questions I got while interviewing for a potential position as a DBA was “If there is...
2014-06-25 (first published: 2014-06-19)
6,672 reads
The Smiling DBA
SQLSaturday #308 Houston, TX Saturday May 10th
This will be the second SQLSaturday in Houston I have spoken at and I am excited about talking Execution Plans...
2014-05-07
457 reads
SQLSaturday #305 Business Analytics Edition Dallas–RECAP
So, I am flying home thinking about the event Saturday and many things are running through my head. No, not...
2014-05-05
820 reads
SQLSaturday #305 Dallas Business Analytics Edition
I am excited about being selected to speak and attend the May 3rd SQLSaturday BA Edition in Dallas, TX. There...
2014-04-23
754 reads
Call for Speakers – SQLSaturday #324 Baton Rouge
Baton Rouge is now on its 6th SQLSaturday and the event grows year after year. It all started with Patrick...
2014-04-11
653 reads
5 Tools Every DBA Should Know About
After monitoring enterprise SQL Server instances for over 10 years now, there are 5 tools that are used every day...
2014-04-03 (first published: 2014-03-25)
7,356 reads
5 Things a developer should know about databases
Database Normalization
Theoretical versus real-world
There is not a strong need for developers to know the theoretical definition of 1st thru 5th...
2014-03-17 (first published: 2014-03-09)
6,579 reads
Jan PASS Data Architecture VC presents Ike Ellis on Tips & Tricks
Please join the PASS Data Architecture virtual chapter on Thursday Jan 30th at noon central for SQL Server Tips and...
2014-01-28
1,124 reads
PASS BI/DW Virtual Chapter–Analysis Services Attributes and Hierarchies
Please join the PASS BI/DW VC today January 15th at 7PM Central for a presentation on Attributes and Hierarchies in...
2014-01-15
623 reads
Jan 8th – Baton Rouge SQL Server User Group - Azure
Please join us tonight, Wednesday Jan 8th starting at 5:45PM with networking and food. The information below is from the...
2014-01-08
756 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