Book Review: Victorious (The Lost Fleet)
Victorious by Jack Campbell ($8 at Amazon) is the finale in the six part series about Black Jack Geary leading...
2010-07-23
684 reads
Blog Posts
Free SQL Server Training for the Week of July 26, 2010
Tuesday
Pragmatic Works - SSIS Management for the DBA - 11 AM EDT - Brian Knight
PASS Application Development VC - The Benefits of SQL Azure...
2010-07-23
811 reads
Fusion-IO releases new 2.1 driver and firmware
And it is well worth the upgrade. I recently had the opportunity to interview David Flynn CEO of Fusion-IO and...
2010-07-23
1,094 reads
How I Prepared to Run for the PASS Board
The Boy Scouts have “Be Prepared” as their motto and, while I was never a scout, I think it’s always...
2010-07-23
324 reads
SQL Server 2008 R2 for the DBA Recording and PowerPoint
I recently had the opportunity to do two presentation on SQL Server R2 for the DBA. In the first session...
2010-07-23
532 reads
SQL Source Control Webinar
One of the new products that Red Gate Software has released recently is SQL Source Control. I saw a demo...
2010-07-23
1,481 reads
SQL University: Introduction to Indexes, Part the Third
Nice to see most of you have managed to fight your way through the shoggoths outside to attend another lecture...
2010-07-23
878 reads
SQLRally Logo Contest
Kendal posted the announcement yesterday that we opened the design content on 99designs. I’ve used the site before and it’s...
2010-07-23
573 reads
Syndication on SQLServerCentral
I have a few people ask about this recently, so I thought I’d blog about it, and maybe get an...
2010-07-23
1,000 reads
The week that was Friday 23 July 2010
Its been a busy week this week. From troubleshooting several production issues to writing some incremental load SSIS scripts, the...
2010-07-23
519 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
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
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,...
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