March Madness – SQL Server style
Bodypaint not required
It seems that March is another great month for getting your geek on without having to leave the...
2012-03-08
642 reads
Colleen M. Morrow
RYO Maintenance Plan – Index Maintenance
It’s been a couple of weeks since my last post, but I swear I have a good excuse. I’ve been...
2012-03-05
1,251 reads
RYO Maintenance Plan – Update Statistics
Another key component of any good maintenance plan is updating statistics. Statistics are what help the SQL Server optimizer choose...
2012-02-27 (first published: 2012-02-21)
2,552 reads
RYO Maintenance Plan – Enhancement Request
In response to my last post, I got a very interesting comment from Philip:
“I would love to see a way...
2012-02-13 (first published: 2012-02-09)
1,560 reads
Using Powershell to Deploy Performance Monitor
As good little DBAs, we should be gathering baseline statistics for our database servers. These stats can give us insight...
2012-02-13
2,827 reads
RYO Maintenance Plan – Database Backups, Part 3
4 out of 5 DBAs agree
I’ve covered creating my backup directories and the actual backup of the database(s). The last...
2012-02-08 (first published: 2012-02-06)
2,316 reads
RYO Maintenance Plan – Database Backups, Part 2
Last time I dealt with the creation of subdirectories, in one or more root locations, to house my database backups....
2012-01-30
1,847 reads
RYO Maintenance Plan – Database Backups
Remember kids...
Anyone who knows me knows that I’m a big proponent of automating routine tasks. If I have to do...
2012-01-26 (first published: 2012-01-23)
3,561 reads
Goals – 6 month checkup
Last week’s resolutions post reminded me that it’s time for another status check on the goals I set for myself...
2012-01-17
827 reads
TSQL Tuesday #026 – Second Chances
Welcome to the first TSQL Tuesday of 2012! This month’s soiree is being hosted by Dave Howard (blog | twitter) and...
2012-01-10
919 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