My First Technical Job: T-SQL Tuesday #150
It’s that time of the month again for a T-SQL Tuesday blog party. This month is hosted by Kenneth Fisher, who has hosted a few times in the past....
2022-05-10
58 reads
Blog Posts
My job managing a calling list. : T-SQL Tuesday #150
I’m actually hosting this month and I was wondering about your first technical job. Mine was kind of interesting. I ... Continue reading
2022-05-10
16 reads
Daily Coping 9 May 2022
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...
2022-05-09
40 reads
Database Design for Tracking Solar Production
We had a solar system installed at our house this year. I’m excited to see how this performs, as our estimates and research shows this ought to be a...
2022-05-09 (first published: 2022-04-27)
333 reads
Friend of Redgate 2022
I am honored and humbled to be chosen to be part of the Friend of RedGate program for another year. This program is near and dear to my heart, and I look forward...
2022-05-09
41 reads
Microsoft Graph API in Power Automate: Adding Guest Users to your Tenant
This is video three in a four-part series walking you through how to leverage the Microsoft Graph API within Power Automate. In this video, you
2022-05-09 (first published: 2022-05-03)
301 reads
Updated Pluralsight Course – Configuring and Managing Kubernetes Security
My updated course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here, or if...
2022-05-09
5 reads
Updated Pluralsight Course – Configuring and Managing Kubernetes Security
My updated course “Configuring and Managing Kubernetes Security” is now available on Pluralsight here! If you want to learn about the course, check out the trailer here, or if...
2022-05-09
26 reads
Add Disk Performance Counters to Windows Task Manager
Have you ever wondered why Windows Server doesn’t show disk performance metrics in Task Manager, but your Windows 10/11 OS does? It’s a really silly difference. Let’s fix that....
2022-05-06 (first published: 2022-04-26)
8,256 reads
Azure Function with PowerShell and the Power BI REST API
In this blog post I’m going to show you how you can create an Azure Function that will interact with the Power BI REST API. I choose PowerShell as...
2022-05-06 (first published: 2022-04-26)
601 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