The Redgate Summit in Atlanta
Navigating the Database Landscape is the headline of our Redgate Summit in Atlanta on Mar 13. I’m doing the Keynote with Grant Fritchey and Kathi Kellenberger with this title,...
2024-03-04
82 reads
Blog Posts
A New Word: Aesthosis
aesthosis– n. the state of feeling trapped inside your own subjective tastes – not knowing why you find certain things beautiful or ugly, only that you do – wishing...
2024-03-01
90 reads
EightKB 2024
EightKB is back! The biggest online SQL Server internals conference is back in 2024…it’s all happening on August the 8th! We’ve open our call for speakers, you can submit...
2024-03-01 (first published: 2024-02-21)
256 reads
Friday Flyway Tips–Capture the Filegroup for Tables
A customer asked recently why Flyway doesn’t detect the filegroup for some changes. I showed them it does and decided to write a post on this. I’ve been working...
2024-03-01 (first published: 2024-02-16)
176 reads
Friday Flyway Tips–Quick Command Line Access
One of the things I had to do recently in a demo was access the Git command line. The way I did it impressed a customer, so I put...
2024-03-01
65 reads
Elevate Your Data Leadership: A Unique Intensive Learning Experience
I’ve collaborated with two industry experts to design a transformative course for data leaders: “The Technical and Strategic Data Leader.” This six-week intensive learning journey is crafted to elevate...
2024-02-28 (first published: 2024-02-16)
348 reads
T Sql Tuesday 170: Learning From Abandoned Projects
T-SQL Tuesday is a monthly blog party hosted by a different community member each month. I missed out on January 2024’s edition because I didn’t think I had anything...
2024-02-28 (first published: 2024-02-20)
197 reads
Humble Bundle of Java Books
I try to keep an eye on the Humble Bundle bundles for books. The bundles serve two great purposes: I was able to grab the Cybersecurity bundle, but by...
2024-02-26
132 reads
Knowing String Defaults in T-SQL–#SQLNewBlogger
For years I’ve assumed I knew the string defaults, but I realized that’s not right. This post looks at what I learned. Another post for me that is simple...
2024-02-26 (first published: 2024-02-14)
349 reads
There Is Insufficient Free Space on Disk Volume To Create the Database
I have been involved in countless database migrations. Most of the time I have access to the existing source servers and future destination servers. In cases where you have...
2024-02-26 (first published: 2024-02-15)
493 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 BCA KCU HR MUHAMMAD TLP/WA 0817839777
Bantuan Cs 0817839777 Jl. Mayjen HR. Muhammad No.17, Putat Gede, Kec. Sukomanunggal, Surabaya, Jawa...
BCA KCU BUKIT DARMO BOULEVARD Tlp:0817839777
Telp / Wa 0817839777 Jl. Mayjend. Jonosewojo No.14, Pradahkalikendal, Kec. Dukuhpakis, Surabaya, Jawa Timur...
ALAMAT KANTOR BCA KCU SIDOARJO TLP/WA 0817839777
Cs: 0817839777 Jl. Ahmad Yani No.39 A, Rw1, Sidokumpul, Kec. Sidoarjo, Kabupaten Sidoarjo, Jawa...
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