MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
9 reads
Blog Posts
MVP for Another Year
I am honored and humbled to be awarded the Microsoft Most Valuable Professional award for the Data Platform category. This is my 6th award, and I am just as...
2019-07-30
15 reads
Power BI Interview Questions – Volume 03 – DAX
Welcome to our continuing series that Erin Ostrowsky [Blog | Twitter] and I spend focusing on interviewing for a Power BI position. This series will
2019-07-30 (first published: 2019-07-09)
723 reads
The tools you should know for the Machine Learning projects
I would like to start my first Machine Learning project. But I do not have tools. What should I do? What tools (environments, libraries etc) shoudl I use? I...
2019-07-30
190 reads
Event Files on Linux
For the most part, things work the way you might expect them to work in windows - except it is on Linux. Sure some things are different, but SQL...
2019-07-29 (first published: 2019-07-10)
200 reads
More Kubernetes Concepts
This post continues looking at my process of learning more about Kubernetes. I’ve been working through the 50 days of Kubernetes (K8s). Now that I had a break from...
2019-07-29
103 reads
Optional vs Required parameters in Stored Procedures
If you are executing a stored procedure with a bunch of parameters it can be a bit of a pain ... Continue reading
2019-07-29
176 reads
Sample Azure DevOps Pipelines
I’ve said it before and I will repeat myself on this because it’s an important concept: DevOps is about culture and communication, not tools Now, that said, to implement...
2019-07-29
119 reads
SQL server and Java?
I was generally reading about SQL Server and how things have changed since the days of just having it within a Windows Eco-system only. It then led me to...
2019-07-29
87 reads
Think Like a Certification Exam at SQLSaturday Birmingham
Thanks for joining us at SQLSat Birmingham! Had a great session with an awesome amount of participation and shared insights, including some very clever test takers.Congrats and kudos to...
2019-07-29
16 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