Management Studio Database Diagram Owners
If you're working in an environment as a developer without sysadmin privileges, and you are creating database diagrams using Management Studio...
2012-12-10 (first published: 2012-12-03)
3,283 reads
If you're working in an environment as a developer without sysadmin privileges, and you are creating database diagrams using Management Studio...
2012-12-10 (first published: 2012-12-03)
3,283 reads
Error when trying to enable the PowerPivot for Excel add-in for Office 2010 reads:
"Not loaded. The Managed Add-in Loader failed...
2012-11-30
6,442 reads
Had a great Friday in Lafayette, LA on the campus of the University of Louisiana-Lafayette. 31 different teams submitted database...
2012-10-14
976 reads
Thanks to the 15+ folks who attended the Baton Rouge SQL Server User Group meeting last night! I hope everyone...
2012-10-11
757 reads
This is a old and simple one, but an important subtlety that TSQL developers must be aware of.
Using the BETWEEN...
2012-09-26
2,754 reads
It is a pleasure meeting everyone today at Houston Tech Fest! The new facility is miles away - literally and figuratively...
2012-09-08
943 reads
I ran into some bad training that had convinced a client sys admin that the SQL Agent Alerts had the...
2012-08-20
2,269 reads
Got this question in an email. I'll paraphrase.
William Hoping you can advise me on best way to handle this. My client doesn’t...
2012-08-16
685 reads
Baton Rouge SQL Saturday is Saturday, August 4!
We expect ~400 attendees at the brand new LSU Business Education Centre of...
2012-07-27
783 reads
Right next to my batarang and bat-zip-line-hook-shooter-gun on my utility belt is my SQL Server DBA Tool Kit, full of...
2012-07-12
1,077 reads
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...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
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