2011-01-17
3,043 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
Multi-tenant Architecture
When you design a database, or at least when I do, I think it’s important to build a database schema...
2011-01-14
4,475 reads
Scaling Up
Would you want to manage a VLDB? Or write the code for an application that uses one? This Friday Steve Jones asks the question of you.
2011-01-14
148 reads
2011-01-14
2,072 reads
Operating in Failure
Today we have an editorial from Sept 25, 2005 being republished as Steve is on vacation. This one talks about the need to expect failure in our systems and code for it.
2011-01-13
80 reads
The Importance of My Cloud Data
Steve Jones likes the cloud, but doesn't necessarily trust it. After a recent Hotmail outage, he outlines a potential issue that he sees with cloud computing.
2011-01-12
181 reads
2011-01-12
2,704 reads
CTRL Scroll and Getting Old
The handiest thing that I’ve used lately for a computer is the Ctrl button and the scroll wheel on my...
2011-01-11
969 reads
NoSQL Basics
Today Steve Jones talks about NOSQL and why it might be important for SQL Server DBAs to understand more about it and be able to talk about when it is appropriate to use.
2011-01-11
709 reads
Thinking about goals for 2011
The SQL community is inspiring, and there are a lot of people that work hard to contribute to it. With...
2011-01-10
1,033 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 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...
BCA KCP Pasar Minggu Center | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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