Three Operating System (Windows) patches due on Tuesday
Microsoft's advance security bulletin has come out and it looks like they are planning on releasing 3 security bulletins on...
2009-03-06
690 reads
Blog Posts
Voice Your Opinion on Topics to be Included at the 2009 PASS Summit
If you are thinking about, or planning to attend the 2009 PASS Community Summit, here is your opportunity to tell...
2009-03-06
450 reads
Book Review: Just Culture
I just finished reading Just Culture, which talks about the challenges of building a system that encourages people to report...
2009-03-05
339 reads
Tagged again
Once again I was tagged to answer a question. This time by Chris Shaw http://chrisshaw.wordpress.com .
Here is the question: Do...
2009-03-05
575 reads
The MVP Summit Wrapup
This week I've been at the Microsoft MVP Summit in Washington State. This is my second summit, and I was...
2009-03-05
1,108 reads
[Off Topic] Get Fit in February – Wrap Up
During the month of February, I participated in the Get Fit in February challenge last month. Along with a few...
2009-03-04
630 reads
Book Review - Naked Conversations
This was one of the first books that I grabbed on my Kindle at the Business of Software Conference in...
2009-03-04
383 reads
Book Review: eBoot Camp, Proven Internet Marketing Techniques to Grow Your Business
My friend Chris loaned me his copy of eBoot Camp as I'm trying to strengthen what I consider to be...
2009-03-04
372 reads
Database Mirroring FAQ: How do we handle transaction log maintenance for a mirrored database?
Question: How do we handle transaction log maintenance for a mirrored database?
This question was asked on a technical discussion group....
2009-03-04
23,504 reads
Owning an Object in SQL Server 2005/2008
One of the things that we have to re-learn when going from SQL Server 2000 to 2005/2008 is that objects...
2009-03-04
6,670 reads
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