Pass Summit 2017
It’s about that time of year again when there is a buzz in Seattle in regards to PASS Summit. Many...
2017-10-26
415 reads
The SQL Professor
Thank You–#PASSElections
This week has been a whirlwind; as the results came in earlier this week on the election I wanted to...
2017-09-28
537 reads
Four PASS Questions–My Take #PASSElections
As part of the campaign material for this years election for Board of Directors; the candidates were asked to answer...
2017-09-19
412 reads
Running for the PASS Board of Directors #PASSelections
This year I decided to take “someday” to heart and do something that has been on my mind for awhile...
2017-09-21 (first published: 2017-09-14)
1,674 reads
SQL Saturday Louisville Re-Cap
And like the wind another SQL Saturday Louisville has come and gone. This past weekend seemed to be a huge...
2017-08-09
484 reads
SQL Summer Vacation–SentryOne
We are having an extra Louisville SQL Server and Power BI User Group meeting this month due to the SQL...
2017-07-24
411 reads
PAC Community Ambassador – SQL Sentry
Last week Aaron Bertrand (b|t) published a post regarding five new PAC Community Ambassadors for SentryOne. I am privileged and...
2017-07-17
333 reads
T-SQL Tuesday #92, Lessons Learned The Hard Way
Wow, hard for me to believe it has been a little bit since the last T-SQL Tuesday block party. This...
2017-07-11
486 reads
Built My Presentation, Now What?
Over the course of several years, I have given many technical and non-technical presentations. It is fun for me to...
2017-06-07
447 reads
QA, Utility Databases, and Job Executions
Sometimes we, as data professionals, have to think outside the box. I know, crazy idea right? Each shop and situation...
2017-04-26
434 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
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
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