Moving The Bottleneck
Most of you probably get that there will always be a bottleneck in a system. You implement a fix in...
2013-07-24
579 reads
SQLAndy
I Learned Something From You
I learned something from you – that was something someone said to me at the end of a recent consulting engagement....
2013-07-23
752 reads
Upscale Bowling
I don’t bowl often, maybe once a year at best. It’s a fun way to spend a couple hours – I...
2013-07-22
706 reads
Security Cameras in the Neighborhood
I live in a pleasant, calm, middle class neighborhood. Not much crime here, at most the rare break-in or vandalism,...
2013-07-19
725 reads
More on Finding Bad Links On Your Blog
Yesterday I mentioned using the Google Webmaster Tools to identify some bad URL’s here on the blog. I decided to...
2013-07-19
634 reads
Fixing Bad Links Found Using Google Webmaster Tools
I’ve been doing various clean up tasks this week related to the blog, with part of that being a review...
2013-07-18
825 reads
PASS Security Virtual Chapter & Security Topics at PASS Summit
I just saw a post from Brian Kelley about the new PASS Security Virtual Chapter launching and the first presentation...
2013-07-17
602 reads
Speakers Announced for SQLSaturday #232 in Orlando
It’s done, finally! The sessions for SQLSaturday #232 have been selected and the schedule is available for viewing. We have...
2013-07-17
695 reads
PCI Compliance Presentation on July 17, 2013
Next week I’ll be doing a new presentation about PCI compliance – aka dealing with credit cards – online (follow this link...
2013-07-09
528 reads
Notes from the 2013 American Association of Woodturners Symposium
This was my first time attending the AAW Symposium, hosted by the American Association of Woodturners. Here are some quick...
2013-07-02
780 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