Common SQL Server – Not Indexing FKs
This series looks at Common SQL Server mistakes that I see many people making in SQL Server.
Foreign Keys
It’s way too...
2010-10-20
1,312 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
Plan for Capacity
It is important that you are monitoring your system to handle the capacity increases as it grows. Steve Jones notes that FourSquare recently had to deal with this.
2010-10-20
366 reads
Database Mirroring Connection Strings - Automatic Failover
I saw a post recently from Hugo Shebbeare that reminded me of something that I’ve seen asked often on the...
2010-10-19
7,613 reads
Living Moore's Law
eBay has quite a new data center in Utah, replacing all their hardware on a two year cycle. Steve Jones thinks that would be a challenge, and an exciting one at that.
2010-10-19
129 reads
Copyright
This is actually amazing. A talk on what YouTube does with copyright and how they view it, from TED. It’s...
2010-10-18
1,123 reads
Software Assurance Cuts Back
Software Assurance from Microsoft is losing a benefit and Steve Jones comments.
2010-10-18
134 reads
Kindle v iPad
I don’t have either, but I ran across this comparison on the devices. It says get both, if you’re a...
2010-10-15
896 reads
Risk Analysis
This Friday Steve Jones asks about your spending on Disaster Recovery and is it in line with the risks involved.
2010-10-15
120 reads
SQL Saturday Advice – Speaker Communication
Recently I was at an event and a speaker wasn’t able to make a session. There was a minor scramble,...
2010-10-14
754 reads
T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
2010-10-14
2,273 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
ALAMAT BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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