Problem
Sometimes users may have numerous of databases in their SQL Server. However, while managing their database sometimes by mistake their records are deleted due to which they face a...
2017-08-08
8 reads
I previously blogged about Microsoft certification changes, and since then there have been some new Microsoft Big Data certifications exams released:
Already...
2017-08-08
682 reads
There is a video that walks you through the solution in depth, please find the video at the end of...
2017-08-08
669 reads
In this module you will learn how to use the Power KPI Custom Visual. The Power KPI displays your KPI...
2017-08-08 (first published: 2017-07-25)
2,164 reads
My previous post on interviews and a number of conversations this year inspired me to write this post. I am...
2017-08-08
445 reads
File this under “soft skills.” Let me start with a recent experience.
Last week I was leading a team of youth...
2017-08-08 (first published: 2017-07-20)
1,694 reads
One of the challenges with any SQL Server business continuity strategy is backing up your databases and logs on a...
2017-08-08
570 reads
Continuing my series on SQL Server and Oracle, I thought I’d highlight a function that has been in Oracle from...
2017-08-08
303 reads
A quick blog post about an issue I encountered today. I tried deploying a simple SSIS project to my local...
2017-08-08
3,508 reads
In my previous post I answer the first of the regular questions I usually get in regards of the MCSA certification, if you haven't seen it I encourage you to...
2017-08-08
5 reads
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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