Top SQL Server migration questions
Below are the top 12 questions I am seeing from customers looking to migrate on-prem SQL Server to Azure, and the blogs that I have wrote that try to...
2019-07-29
78 reads
Blog Posts
T-SQL Tuesday #116–Always Linux
This month is an interesting invitation from Tracy Boggiano. It’s on Linux, which I like. I hadn’t thought about this in terms of T-SQL Tuesday, but I think it...
2019-07-29 (first published: 2019-07-09)
188 reads
Weekly reading #23
New week has started and apart from the usual information from the data world I would like to share one more. The Machine Learning topic published last week has...
2019-07-29
15 reads
ASF 024: Leila Etaati interview
Introduction Leila Etaati is an AI MVP, mentor, trainer, speaker and consultant. She spoke in some important conference such as Microsoft USA Ignite, Microsoft Data Insight Summit, SQL PASS,...
2019-07-26
33 reads
Chaos engineering for SQL Server running on AKS using KubeInvaders
A couple of weeks ago I came across an awesome GitHub repo called KubeInvaders which is brilliant work of Eugenio Marzo (b|t) KubeInvaders allows you to play Space Invaders...
2019-07-26 (first published: 2019-07-03)
470 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 3
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
13 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 3
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
34 reads
Connecting Azure Databricks to Azure Data Lake Store (ADLS) Gen2 Part 3
This is the third and final post in a series that addresses how to use
Azure Data Lake Store (ADLS) Gen2 as external storage with Azure
Databricks. Unlike the...
2019-07-26
147 reads
Finding the Best Azure Datacenter
When dealing with cloud technology there is a phrase that everybody should remember: Physics Always Wins. There isn’t any way to get around the speed of light (2.98 x...
2019-07-26
307 reads
Low Tech Repeating Tasks in Trello
I mentioned in earlier posts that I’m using Trello this year for managing SQLSaturday tasks and figured I might as well go all in and add some of the...
2019-07-26 (first published: 2019-07-09)
296 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