Supporting Wikipedia & Other Organizations
I just sent Wikipedia five bucks. As someone who uses Wikipedia and finds it useful, I’m willing to donate in...
2014-01-01 (first published: 2013-12-26)
1,294 reads
SQLAndy
SQL Server Pro Community Choice Awards
I’m a bit late posting this, but it’s worth a couple minutes to check out the Community Choice awards, might...
2013-12-23
918 reads
Google IQ Test
Friday (Dec 20, 2013) the Google Doodle was a crossword puzzle. I was curious so I clicked and yes, it...
2013-12-23
698 reads
NFC Tags-Fun, And Maybe Useful at SQLSaturday
Last week I had one of those days when I read something and then heard someone talking about the same...
2013-12-16
904 reads
First Week As The DBA Whitepaper Published
For those that attended the webcast I did last week for Idera the companion whitepaper is now available for download....
2013-12-11
831 reads
Learn To Code
Today I ran through the first tutorial at Code.org. It has 20 very short lessons that use Angry Birds and...
2013-12-11
629 reads
Webcast Today: Surviving The First Week As The New DBA
Today at 3 pm EST I’m presenting Surviving The First Week As The New DBA. Some of the topics I’m...
2013-12-05
690 reads
Review: The Abilene Paradox
The Abilene Paradox by Jerry Harvey is not a new book, written in 1988. It’s part of some reading I’m...
2013-11-27
1,331 reads
The World Needs More A/B Testing
Have you ever been told that it’s ok to fail? Did it ever feel like it was really ok to...
2013-11-26
482 reads
Review: The Year Without Pants
The Year Without Pants by Scott Berkun is about a former manager/now speaker and writer going to work for WordPress...
2013-11-26
494 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