Master Advanced SQL: 2 Essential Courses for Every Data Analyst
If you're a data analyst, you already know that SQL isn't just a nice-to-have skill – it's the bedrock of your work. But let's face it, SQL isn't a...
2024-08-19
212 reads
Blog Posts
Monday Monitor Tips- Enabling Index Tracking in Redgate Monitor
There is a new index feature in Redgate Monitor, but it’s disabled by default. This post shows how to enable things. This is part of a series of posts...
2024-08-19 (first published: 2024-08-05)
145 reads
Monday Monitor Tips: Changing the Fragmentation Alert
I had a customer that was concerned about the fragmentation alert for indexes and wanted to know how to change it. This post discusses the change. This is part...
2024-08-19
43 reads
My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github…
My personal experience Dockerizing a Ruby on Rails Application: Deploy to AWS ECR using Github ActionsI recently received a request on how to Dockerize a Ruby on Rails application after...
2024-08-19
59 reads
Service Broker Blocking
This post is dedicated to all 10 other DBAs that use Service Broker (you know who you are).
The main reason for this blog post is that I’ve got no...
2024-08-19 (first published: 2024-08-09)
181 reads
Managing Database code
This is my own contribution to the T-SQL Tuesday I am hosting – on managing database code. I am from the older generation – where the farthest we went...
2024-08-18
50 reads
SQL Saturday Denver 2024 Resources
Here are the resources from my talks today. Best Practices for Seamless Database Deployments PPTX slides Architecting Zero Downtime Deployments git repo: https://github.com/way0utwest/ZeroDowntime PPTX slides Some good questions today,...
2024-08-18 (first published: 2024-08-17)
56 reads
A New Word: Povism
povism – n. the frustration of being stuck inside your own head, unable to see your face or read your body language in context, only ever guessing how you...
2024-08-16
35 reads
dbatools Required Filesystem Access for Database Restores
The Problem While performing an instance migration this spring, I happened upon something I didn’t expect in [dbatools](https://dbatools.io/). It should have been a simple backup/restore copy of the databases,...
2024-08-16 (first published: 2024-08-06)
272 reads
How We Built It: Beeper’s New Blog
Our special projects team was eager to build Beeper a new blogging home. Here's the beautiful result.
2024-08-16 (first published: 2024-08-15)
26 reads
Blogs
Microsoft Build 2026 announcements
By James Serra
Once again there were a number of Microsoft Build announcements related to data and...
T-SQL Tuesday #199: Roundup
A good week ago I hosted the monthly T-SQL Tuesday blog party. I invited...
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...
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...
Follow Your Hunch
Comments posted to this topic are about the item Follow Your Hunch
What Happens When You Ask a Local AI to Query Your Database?
Comments posted to this topic are about the item What Happens When You Ask...
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