Working with the SSIS, SSAS, and SSRS Business Intelligence projects along with Database projects in the same Visual Studio 2008...
2013-08-14
2,611 reads
I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...
2013-08-14
698 reads
Sometimes it’s the small things that count.
I just noticed two small enhancements to SQL Server 2014's BOL, and I can...
2013-08-14
1,532 reads
I’ve recently got a request to invoke an executable file from Powershell. Different ways of executing a executable file is given...
2013-08-14
1,143 reads
I’m setting my course for a new adventure, my mind on a new … undertaking. My apologies if you thought this...
2013-08-14
932 reads
The other day I found myself in a discussion about media – print, broadcast, and social – and having to explain why...
2013-08-14
868 reads
Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last...
2013-08-14
1,480 reads
Introduction
By now you have likely heard a little about Power Query (formally known as Data Explorer). While you may have...
2013-08-14 (first published: 2013-08-07)
5,072 reads
Through Self-Service BI, business units can personalize Business Intelligence to their needs and solve problems at a much faster rate...
2013-08-14
1,063 reads
If you missed the 24 Hours of PASS Summit 2013 Preview, you missed some excellent sessions. I watched a few,...
2013-08-13 (first published: 2013-08-07)
1,239 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...
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
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...
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