TSQL Tuesday #150 Invite – Your first technical job
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start ... Continue reading
2022-05-04 (first published: 2022-05-03)
59 reads
Blog Posts
Daily Coping 3 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-03
18 reads
TSQL Tuesday #150 Invite – Your first technical job
This month for TSQL Tuesday I’d like to hear about your first technical job(s). I know most DBAs don’t start ... Continue reading
2022-05-03
5 reads
A Monthly Running Total–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. Recently I was looking at some data and...
2022-05-02 (first published: 2022-04-20)
305 reads
Daily Coping 2 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-02
19 reads
Microsoft Graph API in Power Automate: Registering the App in Azure
This video is one in a four-part series walking you through how to leverage the Microsoft Graph API within Power Automate. In this first video,
2022-05-02 (first published: 2022-04-19)
271 reads
Daily Coping 29 Apr 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-04-29
49 reads
How to Deploy Azure Logic Apps with ARM and Azure Devops
It’s easy to duplicate an Azure Logic App in a resource group, but unfortunately you cannot duplicate a Logic App between environments (you might try to copy paste the...
2022-04-29 (first published: 2022-04-21)
314 reads
Setting Up SQL Audit for STIG Compliance
Recently I spent months of my lift working on STIG and CIS compliance at my job and one of those tasks was setting up SQL Audit for STIG. Now,...
2022-04-29 (first published: 2022-04-18)
2,944 reads
Azure Redis Cache – Persistent Data
I mentioned before that you could use the idea of data persistency to rebuild your data from total failure. There are two types. RDB and AOF. RDB – persists...
2022-04-28
48 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