Daily Coping 23 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-23
33 reads
Blog Posts
Markdown Links– Remembering the Basics
For some reason, I can never remember how to do markdown links. I know to use the hash symbol (#) for headings. I know that asterisks do bold, or...
2020-11-23
31 reads
Serious Thoughts About PASS
Back when Covid started I guessed that this might be yet another live-or-die challenge for PASS. PASS is heavily dependent on Summit revenue and uses it to fund all...
2020-11-23 (first published: 2020-11-12)
276 reads
sp_RestoreScript 1.8 Now Released
It looks like there was a bug lurking in sp_RestoreScript that was causing the wrong ALTER DATABASE command to be generated when using @SingleUser and a WITH MOVE parameter....
2020-11-23
49 reads
Azure SQL Database and Memory
There are many factors to consider when you are thinking about the move to Azure SQL Database (PaaS) – this could be single databases (provisioned compute or serverless) to...
2020-11-22
141 reads
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
14 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
36 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
6 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
22 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)
444 reads
Blogs
Are you getting value from your reporting?
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
The Book of Redgate: SQL Server Central
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Forums
Microsoft Security Changes and SQL Server
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Expanding into Print
Comments posted to this topic are about the item Expanding into Print
Downtime Caused by the Postgres Transaction ID Wraparound Problem
Comments posted to this topic are about the item Downtime Caused by the Postgres...
Question of the Day
The String Distance I
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers