Configuring SQL Agent Operators - SQL School Video
Operators in SQL Server work hand in hand to ensure that alerts are sent to the proper person. MVP Andy Warren shows how to set these up in this SQL School video.
2009-07-02
3,278 reads
Operators in SQL Server work hand in hand to ensure that alerts are sent to the proper person. MVP Andy Warren shows how to set these up in this SQL School video.
2009-07-02
3,278 reads
Steve Jones sent me a link to a presentation Joel Spolsky did at Google about Stack Overflow (SO) and it’s...
2009-07-01
768 reads
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-06-30
1,517 reads
An indexed view is materialized and exists with actual data. Andy Warren shows how to create one in this SQL School video.
2009-06-30
7,495 reads
Getting a job is hard. If you’ve been lucky enough not to struggle for a job, don’t make the mistake of thinking it will always be easy. Equally, finding a good job is harder still. Some more tips for you to consider: Leverage your recruiter. They know..
2009-06-30
2,683 reads
I met Jeremiah at the PASS Summit last year and since then I’ve looked in on his blog from time...
2009-06-29
1,697 reads
I’ve written a few posts now about LinkedIn, and for now still find it be the best fit for me...
2009-06-28
1,556 reads
Part 2 of how to add a computed column to a table. MVP Andy Warren narrates this SQL School video.
2009-06-25
4,292 reads
My favorite bad movie is The Master Gunfighter starring Tom Laughlin of Billy Jack fame. It’s a Western, and he’s...
2009-06-25
1,501 reads
Ran across the Levenger site while researching laptop bags and it’s branded as ‘tools for serious readers’. Some of it...
2009-06-25
1,449 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...
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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