Daily Coping 26 Jan 2021
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...
2021-01-26
16 reads
Blog Posts
Logical crossroads in Azure Data Factory (IF and Filter operations)
(2021-Jan-19) I was raised listening and reading fairy tales where the main character would reach a crossroad with a large stone that had some directions written on it – turn...
2021-01-26 (first published: 2021-01-19)
222 reads
Power BI: Making Date & Time Keys
Saving the Day from Delay Part 2 Creating DateKey and TimeKey columns can be done with built in functions in the Power Query editor. Quick call out, if you...
2021-01-26 (first published: 2021-01-18)
924 reads
Daily Coping 25 Jan 2021
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...
2021-01-25
16 reads
Data Lakehouse defined
As a follow-up to my blog Data Lakehouse & Synapse, I wanted to talk about the various definitions I am seeing about what a data lakehouse is, including a...
2021-01-25
10 reads
Getting Started with Robotic Process Automation (RPA) Using the Power Automate Desktop
There are a lot of hot phrases you’ve likely heard thrown around during various keynote sessions at conferences over the last 5 years. “Digital Transformation”,
2021-01-25 (first published: 2021-01-16)
633 reads
Speaking about Latches & Spinlocks at the EightKB Online Conference
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-25
8 reads
Speaking about Latches & Spinlocks at the EightKB Online Conference
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-25
14 reads
Speaking about Latches & Spinlocks at the EightKB Online Conference
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-25
5 reads
Speaking about Latches & Spinlocks at the EightKB Online Conference
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan - you get a weekly email packed with all the essential knowledge you need to know about performance...
2021-01-25
4 reads
Blogs
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...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Forums
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...
The String Distance I
Comments posted to this topic are about the item The String Distance I
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