What’s next 4th time
It’s now been about two and a half months since I was given notice and decided to blog about my ... Continue reading
2022-09-28 (first published: 2022-09-08)
213 reads
Blog Posts
Daily Coping 27 Sep 2022
Today’s coping tip is take your time. Make space to just breathe and be still. An easy one today. I’m relaxing in Venice with my wife, and likely no...
2022-09-27
14 reads
My Toolbox - Everything
Foreword
Not everything in the general sense, but a tool called Everything by voidtools (Download link). Usually, I have to make this distinction when googling.
No matter how great is my...
2022-09-27
43 reads
SQL Server In Place Upgrades
Good morning dear blog reader. Today’s episode is fresh from a great weekend with the family. It is always fun to go on a road trip with my wife...
2022-09-27
2,634 reads
Daily Coping 26 Sep 2022
Today’s coping tip is to enjoy photos from a time with happy memories. On vacation today in Venice, so I ought to get more, but I’ve started to put...
2022-09-26
12 reads
Learning PostgreSQL: The Tools
In case you don’t know, I’ve been writing a series of articles over on Simple-Talk as I learn PostgreSQL. It’s all from the point of view of a SQL...
2022-09-26 (first published: 2022-08-01)
265 reads
T-SQL Tuesday #154 – SQL Server 2022
This month’s T-SQL Tuesday is being hosted by Glenn Berry , and the subject he chose is “SQL Server 2022.” Microsoft has recently released the RC0 version of SQL...
2022-09-26 (first published: 2022-09-13)
381 reads
Daily Coping 23 Sep 2022
Today’s coping tip is to notice what you are feeling without any judgment. Today I’m stressed. I have been traveling a bit and trying to work remotely from my...
2022-09-23
18 reads
Look Into Chocolatey
Just a suggestion, but I’d say you should look into Chocolatey. Let me explain why. Sabbatical For those who don’t know I was recently on a six-week sabbatical from...
2022-09-23 (first published: 2022-09-12)
350 reads
Snowflake – Where is the explain/execution plan?
Whatever your database background is you will have heard of an execution / explain plan. Snowflake is no different. Coming from a MS SQL background I was used to...
2022-09-23
126 reads
Blogs
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...
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...
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