Using SQL Elastic Pools
We use SQL elastic pools at work. I needed to learn more about their nuances and help you with some of their challenges. Setting Up Elastic Pools Here‘s some...
2024-04-05 (first published: 2024-03-29)
495 reads
Blog Posts
Webinar Apr 9: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise
On Tuesday I have a webinar with a Redgate sales engineer: Accelerating Success: De-risking and Streamlining Releases with Flyway Enterprise. This will cover You can register here. In this...
2024-04-05
10 reads
Spring 2024 Speaking Engagements
I will be presenting Answering the Auditor’s Call with Automation at two upcoming events, one virtual and one in-person.
DBA Fundamentals Virtual User Group Tuesday, April 9 2024 at Noon...
2024-04-03 (first published: 2024-03-26)
127 reads
SQL Compare Force Column Order in a Table
I had a client that was concerned about SQL Compare behavior when a developer adds a column to the middle of a table. I wanted to reassure them, so...
2024-04-03 (first published: 2024-03-20)
375 reads
Off to SQL Saturday Salt Lake City … on Friday
I’m off on Thursday for Salt Lake City and a SQL Saturday on Friday. SQL Saturday Salt Lake City 2024 is happening, and I’m glad I get to go....
2024-04-02
58 reads
Power Query ODBC bug affecting date calculations
I was working on an imported Power BI semantic model, adding some fiscal year calculations to my date table. The date table was sourced from a view in Databricks...
2024-04-02
4 reads
How I use Terraform to deploy my AWS amplify react js project
As a Software Engineer, I would like to deploy my AWS Amplify react js project using Terraform so that I can automate my workflow and eliminate any manual intervention...
2024-04-01
26 reads
Interview around DevOps, Data, AI and Microsoft Fabric
A few weeks ago I did an interiview with Nagaraj Venkatesan – a good friend of mine who works for Microsoft Singapore. You can watch video below – I...
2024-04-01 (first published: 2024-03-20)
184 reads
The PASS Data Community Summit 2024 Call for Speakers
The PASS Data Community Summit call for speakers and volunteers is open. You have until April 10 to submit something, and you can do that here: Data Community Summit...
2024-04-01 (first published: 2024-03-22)
128 reads
Fabulous Stuff in Fabric – Part 5: Folders in Workspaces
A while ago I had a little blog post series about cool stuff in Snowflake. I’m doing a similar series now, but this time for Microsoft Fabric. I’m not going...
2024-03-31
34 reads
Blogs
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
PowerPoint to HTML with Claude AI
By Steve Jones
I had an idea for an animated view of a sales tool, and started...
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Forums
Why the following cmds in sequence do not work
I need to delete rows from both the temporal main and history tables. The...
When SQL Server Central Went Down
Comments posted to this topic are about the item When SQL Server Central Went...
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('tim', 'tom')
Assume preview features are enabled. See possible answers