đ What Is TempDB and Why It Matters TempDB is a shared system database in SQL Server used for: Because itâs used by every session and process, TempDB is often a performance bottleneckâespecially...
2025-07-24
1,417 reads
Will adding generative AI to your data project improve the outcomes? It might, but itâs not guaranteed. It can be harmful and costly to add generative AI in the...
2025-07-23
1,081 reads
In the fast-paced world of IT, Database Administrators (DBAs) are the unsung heroes who ensure that data flows securely, efficiently, and reliably. But what if we viewed database environments not just...
2025-07-23
17 reads
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
6 reads
A new feature has just been released in Microsoft Fabric that I was so impressed with that I decided to blog about it. Available in public preview is the...
2025-07-23
27 reads
Boost Your Azure Fabric Pipelines: Donât Overlook This Crucial Spark Setting Are your Azure Fabric pipelines with multiple notebooks running slower than youâd like? Are you paying for more...
2025-07-23
193 reads
The SQL Server installer has gotten better: tempdb configuration, MAXDOP, and even max memory can now be configured during setup. But donât be fooled: thereâs still a post-install checklist...
2025-07-23
71 reads
In todayâs enterprise landscape, agility and reliability go hand-in-hand. As organizations modernize legacy infrastructure and scale operations across borders, the challenge is no longer just about moving fast â...
2025-07-22
85 reads
Iâm honored to be speaking at the PASS Data Community Summit in Seattle this fall. Iâll be delivering a Professional Development session (Blogging for the Tech Professional), which might...
2025-07-22
55 reads
herefore, from Northwind and pubs to WideWorldImporters, I've compiled where to get those databases and what you need to know in order to use them yourselves.
2025-07-21
353 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