A New Word: Chysalism
Chysalism – n. the amniotic tranquility of being indoors during a thunderstorm? While I love the sun, I did enjoy thunderstorms when I lived in Virginia. Something neat about...
2023-05-05
42 reads
Blog Posts
Change the Default Git Branch for a dbt Cloud Project
In dbt, you can link your project to a github account, which is obviously the right thing to do. By default, the project uses the main branch. But what...
2023-05-05 (first published: 2023-04-24)
59 reads
Exporting SQL Data Compare Results to Excel
I had someone ask recently about getting SQL Data Compare results in Excel. It’s easy to do and this post looks at the process. Exporting a Comparison I won’t...
2023-05-05 (first published: 2023-04-25)
161 reads
Traveling to SQL Saturday Jacksonville 2023
I’m heading to SQL Saturday Jacksonville 2023 today, speaking tomorrow. After not making any of their events, I went in 2022 and am back for their 15th event this...
2023-05-05
34 reads
Adding microseconds to a timestamp in Azure Data Factory
(2023-Apr-25) It’s not hard to see that many different teams were involved in building Azure Data Factory (ADF) product at Microsoft. It doesn’t have conformed constraints for naming the objects...
2023-05-03 (first published: 2023-04-25)
970 reads
Find out how fast is your SQL database growing using the backup metadata from msdb
Sometimes I need to know how fast a database is growing, or which particular database is growing the most out of all the databases on a SQL instance. Now...
2023-05-03 (first published: 2023-04-24)
817 reads
Azure Resource Group
What is Azure Resource Group? Azure Resource Group is a powerful feature that enables effective organization and management of resources in the Azure cloud. A Resource Group is a...
2023-05-01
150 reads
How to use the new dynamic format strings for measures in Power BI
The April 2023 release of Power BI desktop introduced a new preview feature called dynamic format strings for measures. This allows us to return values with different formats from...
2023-05-01 (first published: 2023-04-21)
762 reads
New Job -> Week 6 -> Ozar sp_BlitzIndex
This is part of a series of new job blog posts. You can find them all here. Week 6 goal: Analyze all Azure SQL Database indexes. Last week, I...
2023-05-01 (first published: 2023-04-24)
780 reads
Tales From The Field Weekly Wrap Up for the Week of 04-24-2023 Steve Martin, Martin Short, & Tacos
Hello Dear Reader! I've realized something writting this blog. I don't like to sit still. It is very rare that I have a down weekend, and this weekend was...
2023-05-01
85 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
RegEx Functions II
I have this data in a table in a SQL Server 2025 database:
EmailAddressID EmailAddress 7 dylan0@ADVENTURE-WORKS.COM 8 Diane1@ADVENTURE-WORKS.COMIf I run this query, which row(s) are returned?
SELECT top 10 * FROM person.EmailAddress WHERE REGEXP_LIKE(EmailAddress, '^d') AND BusinessEntityID IN (7,8)See possible answers