Backup/Restore–What’s My Status?
The day begins and you find yourself going through a list in your mind of things that need to be...
2017-02-02 (first published: 2017-01-26)
1,889 reads
The SQL Professor
5 Characteristics Every Leader Should Practice
The word leadership has many synonyms attributed to it. Something that can be learned early on in one’s career is that...
2017-01-24
729 reads
Why Use Red Gate’s SQL Multi Script?
Someone once told me at the shop that we have plenty of software utilities laying around that could be very...
2017-01-18
522 reads
Hold The Fort
Have you ever heard the phrase “Hold The Fort”? Long ago in battle supply routes were targeted by enemy regiments...
2017-01-12 (first published: 2017-01-05)
1,303 reads
Looking Back At 2016
When this blog started back in 2011 I had no idea that it would continue to grow to where it...
2016-12-29
680 reads
The New PASS Logo and More
Change is not always easy. In fact, change is hard.
“Change” is a word from which some people shy away, and...
2016-12-20
340 reads
A Data Professional’s Story – PASS Summit 2016
This year is different. Why? I’m not sure yet. There is a lot of reflection going on since my return...
2016-11-11 (first published: 2016-11-02)
1,232 reads
PASS Summit Keynote 2 – Release 2
Dr. David DeWitt is getting ready to take the stage to a huge ovation and is thrilled to be back...
2016-10-27
586 reads
PASS Summit Keynote 2 – Release 1
Grant Fritchey taking the stage to talk about the financial health of PASS.
250k members , 170 countries, and 87% global representation...
2016-10-27
562 reads
PASS Keynote Part 2 – Live Coverage
Good morning from PASS Summit in Seattle, Washington. Like yesterday I will be live blogging the event. The same format...
2016-10-27
530 reads
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Stan Phone Number Australia +61-1800868603 Quick Help Guide
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Question of the Day
Detecting Characters
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