T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
6 reads
Blog Posts
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
5 reads
T-SQL Tuesday #133: What (Else) Have I Learned from Presenting?
T-SQL Tuesday is a monthly blog party in the SQL Community and this month is hosted by Lisa Bohm (b | t) and it’s about what else I have...
2020-12-08
4 reads
T-SQL Tuesday #133–What I Learned From Presenting
This month Lisa Griffin Bohm is the host and thanks to her from hosting. She was one of the last people I pressured lightly to host. She came up...
2020-12-08
17 reads
Daily Coping 7 Dec 2020
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...
2020-12-07
29 reads
Data Architecture Blog Post: CI CD in Azure Synapse Analytics Part 1
Hello Dear Reader! It's been a while. I've got a new blog post over on the Microsoft Data Architecture Blog on using Azure Synapse Analytics titled, CI...
2020-12-07
12 reads
Data Architecture Blog Post: CI CD in Azure Synapse Analytics Part 1
Hello Dear Reader! It's been a while. I've got a new blog post over on the Microsoft Data Architecture Blog on using Azure Synapse Analytics titled, CI...
2020-12-07
81 reads
Top 10 Must-Ask Questions Before Going to the Cloud
After architecting and migrating some of the world’s largest data platforms, Let’s walk through my top ten must ask questions before migrating to the cloud so that you can save time, money,...
2020-12-07 (first published: 2020-11-23)
694 reads
Virtual Log Files
Today’s post is a guest article from a friend of Dallas DBAs, writer, and fantastic DBA Jules Behrens (B|L) One common performance issue that is not well known that...
2020-12-07 (first published: 2020-11-24)
387 reads
A Note to the PASS Board of Directors
I just read with dismay that Mindy Curnutt has resigned. That’s a big loss at a time when the future of PASS is in doubt and we need all...
2020-12-06
108 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