Sabbatical!
Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...
2022-07-18
4 reads
Redgate Software has a policy wherein every 5 years, employees receive a 6-week paid sabbatical. Well, I’m up to year 11 (I skipped a year my first time), so...
2022-07-18
4 reads
Scary Scalar Functions series overview
Part One: Parallelism
Part Two: Performance
Foreword
In the second part of this series, we’ll look at how Scalar functions (or UDFs) affect performance.
If you want to follow...
2022-07-18 (first published: 2022-07-02)
561 reads
SQL Saturday is coming back in-person to Los Angeles. I’ve been to this event a few times, and was sad when the pandemic pushed it virtual. However, 2022 is...
2022-07-18
8 reads
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-07-15
36 reads
For more formal enterprise Power BI development, many people have a checklist to ensure data acquisition and data modeling quality and performance. Fewer people have a checklist for their...
2022-07-15
148 reads
I was reading a SharePoint List using the “Get Items” activity in an Azure Logic App. I explain how you can create such a Logic App in the blog...
2022-07-15 (first published: 2022-06-27)
112 reads
Recently PASS Data Community Summit sessions were selected and the wounds were opened on Twitter around speaker diversity in the community. I heard from several people via my DMs...
2022-07-15 (first published: 2022-06-30)
214 reads
This is the second in the series of tools and technologies that I use to deal with the loss of functionality in my hands and arms. Check out this article for...
2022-07-15
39 reads
Last week I posted about a request to get a list of services. The first problem I ran into was ... Continue reading
2022-07-14
231 reads
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-07-14
33 reads
By Brian Kelley
This was announced last week at Microsoft Ignite and it's been covered by others...
By Rayis Imayev
"Dave: Open the pod bay doors, HAL.HAL: I’m sorry, Dave. I’m afraid I can’t...
By Steve Jones
Redgate acquired a data modeling tool from Vertabelo recently and I wanted to explore...
Comments posted to this topic are about the item The Ending Substring
Comments posted to this topic are about the item Done is Better than Good,...
Comments posted to this topic are about the item Configuring the On-Premises Data Gateway:...
In Azure SQL Database and SQL Server 2025, if I run this, what is returned?
SELECT '[' + SUBSTRING('Steve Jones', 7) + ']' See possible answers