Becoming a DBA
Steve Jones was recently asked how he knows someone is ready to be a DBA. It's an interesting question and he shares some thoughts on this today.
2009-06-22
590 reads
Editorial - WMV
Grown Up Software
We all want to write better software, but do we really want to write grown up software? Steve Jones talks about one of the most successful software groups ever.
2009-06-21
434 reads
Going Native
This Friday Steve Jones asks about advice for other DBAs. What's the best way for those intermediate and accidental DBAs to handle maintenance on their servers?
2009-06-18
678 reads
The Best Minds
What do you want when you go to a conference? Great speakers or great information? Steve Jones talks a little about how we get both in the future.
2009-06-17
528 reads
The Simple Estimate
Why can't it be easy for someone to tackle small projects? It is in some areas, and Steve Jones talks a little about some of the issues.
2009-06-15
447 reads
Are You an Exceptional DBA?
The Exceptional DBA award is back again in 2009. Steve Jones comments a little on his experience last year.
2009-06-12
1,024 reads
Back to the Future
Steve Jones asks this Friday if there is anything you wish you might have done differently.
2009-06-11
732 reads
Who's At Fault
Who do you blame when software fails? Hopefully you don't hire a lawyer before you do. Steve Jones talks about liability and software.
2009-06-10
493 reads
Mining for Quitters
Google is trying to figure out who might quit the company, using their own custom application. Steve Jones thinks this is a great idea and wishes more companies would do it.
2009-06-09
932 reads
Software Giants
Microsoft is the largest software company in the world. What does this mean for SQL Server? Steve Jones thinks it's good.
2009-06-07
608 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