The Basics of Troubleshooting
After seeing several cases in the past couple of months where I felt the basics of troubleshooting were violated, I...
2010-12-06
2,221 reads
Blog Posts
Tip: Schema Qualify Objects in SPs
“Eat your broccoli.”
“Wear your gloves.”
“Schema qualify your objects.”
Your Mom wasn’t kidding, and she always gave the best advice. We’ve already...
2010-12-06
1,717 reads
Digg
I’m currently doing some experiments with ,y blog and trying out digg.com. In order to do that I need to...
2010-12-05
526 reads
What happens when a query is submitted?
I know, We cant cover life span of query in short. here is my another try to list some high level information...
2010-12-05
5,431 reads
Getting Drive Info, Part 5, the SSIS WMI Data Reader Task
In the final installment of the Getting Drive Info series (Part 1, Part 2, Part 3, Part 4), SSIS will again be used to collect and save the drive...
2010-12-04
17 reads
Getting Drive Info, Part 5, the SSIS WMI Data Reader Task
In the final installment of the Getting Drive Info series (Part 1, Part 2, Part 3, Part 4), SSIS will...
2010-12-04
1,894 reads
What PASS means to me.
I first heard of PASS (Professional Association for SQL Server) in connection with the PASS Summit. I had a several...
2010-12-04
352 reads
Book Review: Alas, Babylon
I just re-read Alas, Babylon by Pat Frank ($10 @ Amazon). It’s a bit of a touchstone for me. It was...
2010-12-03
613 reads
Free SQL Server Training for the Week of December 6, 2010
Took a break from posting this last Friday due to the holidays. But I'm back with the weekly updates.
Monday
PASS Data Warehousing/BI...
2010-12-03
940 reads
How Many Have I Read?
I saw this on Facebook, and while I’m not sure of the list, I reproduced it here. I think that...
2010-12-03
541 reads
Blogs
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...
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
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