Ethics in IT - Database Weekly (Nov 17, 2008)
Employers say they're looking for more ethics and morals in IT for 2009. Steve Jones hopes it's true.
Employers say they're looking for more ethics and morals in IT for 2009. Steve Jones hopes it's true.
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
Is Open Source something you should examine with the economy diving down? Steve Jones talks about a few of the issues.
This article examines the Recovery Model options used by SQL Server 2008 and the various methods that can be used to backup a database such as Differential and Transaction Logging. In addition, Transaction Logs, the mechanism that makes Recovery Models possible will be introduced.
Previous versions of SQL Server were not that great at keeping track of object dependencies. The reason for this was due to the fact that all object dependencies were tracked by the ID of the object, which meant that the object had to exist first.
With people becoming smarter about technology, does it make sense for them to choose their own computer? Steve Jones thinks so.
With people becoming smarter about technology, does it make sense for them to choose their own computer? Steve Jones thinks so.
With people becoming smarter about technology, does it make sense for them to choose their own computer? Steve Jones thinks so.
Employers say they're looking for more ethics and morals in IT for 2009. Steve Jones hopes it's true.
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
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