The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
The Software Comparison - Part 2
The second editorial from Steve Jones comparing software to other types of jobs continues with a look at the legal profession.
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
The Software Comparison
Is building software like building a house? Steve Jones digs into the comparison at the start of an editorial series looking at other professions.
Database Weekly - June 2, 2008
A look back at the news from the week including Windows 7 and taking an unwired vacation.
Reverse Engineering Alias Data Types in SQL Server 2000
In SQL Server 2005 there is the concept of alias data types, which are similar to user-defined data types in SQL Server 2000. Yakov Shlafman brings us the first part of a series looking at these structures in SQL Server 2000.
The Exceptional DBA Awards
Seeking to recognize DBAs for the work they do, the Exceptional DBA Awards are open for nominations. Steve Jones talks a bit about the event.
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
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...
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