SQLpassion Online Training about Statistics & Plan Caching
On April 22, 2021 I will run an SQLpassion Online Training about Statistics & Plan Caching in SQL Server. Statistics are used by SQL Server to estimate how many...
2021-03-22
8 reads
Blog Posts
Summarizing a Script with SQL Prompt
I have never used this feature, but someone was asking for feedback on Prompt, and I noticed this in the menu: Summarize script. I had guessed that it might...
2021-03-22 (first published: 2021-03-17)
77 reads
?????????????????????????? ???????????????????? ?????????????????? ???? ?????????????????? Azure
A detail paradigm to support SQL on Azure cloud, DP 300 study guide, and explore the hidden side of cloud databases. Administering Relational Databases on Microsoft Azure takes readers...
2021-03-21
67 reads
A new WordPress theme and a new job
As you can tell, I have switched to a new WordPress theme for this blog site. I have now been blogging for ten years! It seemed like a good...
2021-03-20
5 reads
A new WordPress theme and a new job
As you can tell, I have switched to a new WordPress theme for this blog site. I have now been blogging for ten years! It seemed like a good...
2021-03-20
34 reads
Daily Coping 19 Mar 2021
I started to add a daily coping tip to the SQLServerCentral newsletter and to the Community Circle, which is helping me deal with the issues in the world. I’m...
2021-03-19
17 reads
Enjoying Sunshine
My coping tip a couple days ago was to enjoy your weather. In it, I was dealing with clouds and what most people see as bad weather. Today is...
2021-03-19
23 reads
It’s Been a Year
I’ll turn this into an editorial, but it’s been a year since my area shut down and life changed. I would never have guessed things would last this long,...
2021-03-19
18 reads
My new Home Studio Setup
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-03-19 (first published: 2021-03-15)
519 reads
Rebuilding SQL Saturday–Picking a Board of Directors
With Redgate planning to donating the SQL Saturday brand, trademarks, and domain to a non-profit foundation, there is a need to build a group of individuals to voluntarily manage the...
2021-03-19 (first published: 2021-03-15)
271 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...
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