What could you achieve with 60% more time?
Regardless of your job or industry, do you ever have enough hours in the day to get everything done? If...
2019-01-21
200 reads
SQL Treeo
Five database management trends to embrace in 2019
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with...
2019-01-07
304 reads
Five database management trends to embrace in 2019
In 2018, companies looked for ways to improve their database performance and security. Their aim was to keep up with ever-higher expectations of speed, privacy and returns on investment....
2019-01-07
12 reads
Why do we think water and databases are similar?
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup...
2018-12-17
227 reads
Why do we think water and databases are similar?
It’s 20 years since Google was launched, the Euro was agreed, and the Three Tenors sang at the World Cup opening ceremony. That was also the year (1998) when...
2018-12-17
17 reads
Three tips to help your database team avoid burn out this holiday season
As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of...
2018-12-03
364 reads
Three tips to help your database team avoid burn out this holiday season
As you’re enjoying the festivities this month, spare a thought for your database administrators and IT teams. It’s one of the busiest and most stressful times of the year...
2018-12-03
15 reads
Would you give our database monitoring the UX thumbs up?
“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other...
2018-11-20
278 reads
Would you give our database monitoring the UX thumbs up?
“You’ve got to start with the customer experience and work backwards to the technology.” You’ve probably heard this, and other similar UX advice, before. We are passionate believers in...
2018-11-20
22 reads
A Health Check can keep your SQL database in great shape
Modern businesses are data-driven. Many business leaders will tell you it is the “lifeblood” of their company. Good data helps...
2018-11-07
281 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