Deployment of Microsoft SQL database with Azure DevOps
Hello, data folks! I have published several articles about databases and their maintenance in SSDT project on the blog. One of the posts explained step by step how to...
2019-12-12
42 reads
Blog Posts
Session Evaluations from “SQL Server Security from the Ground Up”
I was recently given the opportunity to speak at Pass Summit. As always (this is the second time) this was ... Continue reading
2019-12-12
15 reads
SSMS Tip: Beep When Query Completes
I’m old enough to remember when multitasking was considered a good thing. From the same mouths that brought you “work smarter, not harder” came the advice to always be...
2019-12-12
68 reads
The Eleven Days of Festivus 2019
The weather is turning cooler, there is holiday music everywhere, and the relatives are all excited to get together and talk about politics. That can only mean one thing:...
2019-12-12
26 reads
Who needs data access? Not You!
With a little planning and care, we can find various ways to fulfill user requests without compromising the environment.
Related Posts:
When Too Much is Not a Good Thing December 13,...
2019-12-12
8 reads
A guide to acronyms, abbreviations, and other technical terms
Here’s a list of some technical terms, acronyms, and abbreviations you may have heard, and what they mean. Some of the definitions are taken from Wikipedia. This list is...
2019-12-11
42 reads
Error message: http://System.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the varchar value ‘NULL’ to data type int.
I love this error. Primarily because it demonstrates two very important things. Errors matter. Make sure when you ask someone ... Continue reading
2019-12-11 (first published: 2019-12-05)
668 reads
Information Measurement with SQL Server Part 4.7: The Bhattacharyya and Hellinger Distances
By Steve Bolton …………Over the course of this segment of the series, we’ve slowly assembled a classification system for some distances measures that can be used for DIY data...
2019-12-11 (first published: 2019-11-30)
429 reads
Reflection on Talking at SQLSaturday Charlotte About Mental Health
On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...
2019-12-11
8 reads
Reflection on Talking at SQLSaturday Charlotte About Mental Health
On December 7, I did a session on mental illness and mental health problems being more common in IT than you think. Before the event the PASS WIT Virtual...
2019-12-11
4 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
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
RegEx Functions II
Comments posted to this topic are about the item RegEx Functions II
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