We Need a DBA Boot Camp
Today we have a guest editorial from Andy Warren. We often find that many DBAs fall into the job as accidental DBAs, and need more training. Is a boot camp the way to get them up to speed quickly?
2011-07-06
246 reads
Today we have a guest editorial from Andy Warren. We often find that many DBAs fall into the job as accidental DBAs, and need more training. Is a boot camp the way to get them up to speed quickly?
2011-07-06
246 reads
I ran across this article about How to Delete an Account from Any Website on the PC Magazine web site....
2011-07-05
918 reads
Hour of the Horde by Gordon R. Dickson ($1-5 @ Amazon) is an interesting story. The basic plot is that one...
2011-07-01
429 reads
My friend Rob Hatton pointed me to Google Correlate, a new service that lets you explore data trends in a...
2011-06-30
1,793 reads
This post is password protected. To view it please enter your password below:
Password:
2011-06-30
1,480 reads
Today we have a guest editorial from Andy Warren. We have regular maintenance that needs to be performed on our cars, and also regular maintenance that needs to be done on our servers. Andy points out that companies need to understand this and make sure these regular activities are performed.
2011-06-29
242 reads
I work with a client that recently moved into a newly renovated space in a smaller office building. The renovation...
2011-06-29
887 reads
Our call for speakers for #85 will be open about another 10 days, and then Bradley Ball can jump into...
2011-06-28
616 reads
Last year we had some problems with our annual election, enough problems that clearly we needed to do a deeper...
2011-06-27
672 reads
Here’s a two part story(Part 1, Part 2 from Information Week by Larry Tieman you should read. There’s a great...
2011-06-24
895 reads
By gbargsley
One of the first things I review when I inherit a new SQL Server...
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
When things go wrong - like trouble signing in, videos pausing, unclear charges, or...
Tlp/Wa_Cs:0817-866-887. Jl. Lenteng Agung Raya No.26 E-F, RT.1/RW.4, Ps. Minggu, Kota Jakarta Selatan, Daerah...
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