SQL Saturday #28 Announces: Asks The Experts
Do you have a challenging SQL Server or .Net issue that is causing you to have sleepless nights? Well, we...
2010-08-03
515 reads
Blog Posts
SQL Server Backup File Confusion - Log Shipping
I saw a post recently where a person working with SQL Server had log shipping setup. They were asking if...
2010-08-03
932 reads
TSQL Tuesday Coming Up
The next TSQL Tuesday is only 1 week away. This month the topic covers getting a little R&R. We would...
2010-08-03
442 reads
A Small Collection of DBCC Commands
There are a number of pretty useful DBCC Commands that have nothing to do with checking the consistency of a...
2010-08-02
1,989 reads
August Question: What types of continuing education do you use to keep up with being a DBA?
Post your responses to the above SQL Aloha Question of the Month in the comments section below (at www.bradmcgehee.com if...
2010-08-02
606 reads
PASS Update #40 (Elections)
Last week I made it through the first screening of candidates for this years Board of Directors election. Seven of...
2010-08-02
355 reads
SQL Saturday #28 - Two Weeks Away
It’s a little less than two weeks until SQL Saturday #52 in Baton Rouge. I attended last year, and thoroughly...
2010-08-02
359 reads
SQL Saturday 28 Baton Rouge and Ask the Experts
The second annual SQL Saturday Baton Rouge event is coming up in less than two weeks! Have you registered?
I’m honored...
2010-08-02
608 reads
SQLSaturday #40 – South Florida Recap
I had the great privilege to be able to attend and speak at SQLSaturday #40 – South Florida this past weekend...
2010-08-02
654 reads
SSWUG Ultimate Virtual Conference October 20-22, 2010
I will be presenting four sessions for the SSWUG Ultimate Virtual Conference that will be held online October 20-22, 2010....
2010-08-02
789 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
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
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,...
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