How to fix replication issue cannot truncate table
I have the privilege to work on Saturday and Sunday, holding a pager during my shift hours. I get most of the blog ideas during this stint. Today’s post...
2020-11-21
24 reads
Blog Posts
Kubernetes Precon at DPS
Pre-conference Workshop at Data Platform Virtual Summit 2020 I’m proud to announce that I will be be presenting pre-conference workshop at Data Platform Virtual Summit 2020 split into Two...
2020-11-21
38 reads
Kubernetes Precon at DPS
Pre-conference Workshop at Data Platform Virtual Summit 2020
I’m proud to announce that I will be be presenting pre-conference workshop at Data Platform Virtual Summit 2020 split into Two...
2020-11-21
14 reads
Notes on the PASS 2020 Virtual Summit – Conclusions
I waited a week to write this, letting the experience settle some. Looking back, it wasn’t a terrible experience. Content was findable and as far as I could tell...
2020-11-21
24 reads
Consider the Benefits of Powershell for Developer Workflows
Who Am I Talking To
You use bash or python.
PowerShell seems wordy, extra verbose, and annoying.
It’s a windows thing, you say… why would I even look at it.
Pry bash out...
2020-11-20 (first published: 2020-11-04)
446 reads
Daily Coping 20 Nov 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-11-20
21 reads
I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
14 reads
I Wrote a Book – Hands-On SQL Server 2019 Analysis Services
While not the first time I have authored, this is the first book that I wrote as the sole author. Analysis Services is the product I built my career...
2020-11-20
121 reads
Pro Microsoft Power Platform: Solution Building for the Citizen Developer
Over the last several months a team of excellent authors, including myself, have been writing a very exciting new book about Microsoft’s Power Platform. We
2020-11-20 (first published: 2020-11-04)
328 reads
Server-Level Roles – Back to Basics
In this article, I have shown how to use the power of custom server roles to help reduce your administration time. The custom security role is like using a...
2020-11-20
44 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