Knowing how to use ATTRIB
ATTRIB is one of those commands back from the days of DOS which most folks don't even realize it's there....
2010-02-03
2,224 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Why You Should Volunteer for a Code Camp / SQL Saturday
This past weekend I was at the Columbia Code Camp, which was a rousing success with 6 tracks, a number...
2010-02-01
1,101 reads
Columbia Code Camp 2010
We're making a final push to let everyone know about the Columbia Code Camp 2010, which happens tomorrow, January 30....
2010-01-29
1,495 reads
Three Life-Changing Events
Paul Randal started a meme about three life changing events that brought him to where he is today. Brent Ozar...
2010-01-18
3,124 reads
Admitting When You're Wrong
As a father of two head-strong boys (inherited trait), I struggle with getting them to admit they are wrong when they...
2010-01-15
1,020 reads
Be Security Smart on Haiti Earthquake
Not surprisingly, there are already vultures looking to take advantage of the tragic earthquake in Haiti for their own financial...
2010-01-13
898 reads
The Right Attitude to be a Mentor
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
2010-01-08
2,756 reads
Bad Default Database Leads to a Failed Login Attempt
Yesterday we had a user receiving the infamous failed login attempt error (no, that's not a valid IP):
Login failed for...
2010-01-07
1,715 reads
The Right Attitude to be a Mentor
When I first reported to my duty assignment with the US Air Force, there were 3 sergeants in my shop....
2010-01-06
2,201 reads
What Matters Is What They Want
In September 1986 my family returned to Beaufort, SC, from a three year tour stationed at MCAS Iwakuni, Japan. My father was...
2010-01-05
660 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