Upcoming SQL Saturdays & Precons
This coming weekend is the SQL Saturday #307 in Iowa City, Iowa. I am really looking forward to attending this event...
2014-06-04
463 reads
A Sherlockian Question Of the Day & Why I’m Writing Questions
If you haven’t noticed by now I’ve been writing quite a few questions of the day for SQLServerCentral. It started,...
2014-06-04
335 reads
Is PowerShell worth the time?
This is a good question for me to ask. I’ve been learning it, and working through examples in my PowerShell...
2014-06-06 (first published: 2014-06-04)
3,778 reads
Partitioning Basics – Part 1 – Creating Partitions
Partitioned tables can be a quick and efficient way to (amongst other things) archive data. In the next couple of...
2014-06-09 (first published: 2014-06-04)
5,092 reads
15 years of experience with Identity columns
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,059 reads
Using PIVOT function without a CTE
There are some cases when you need to use a PIVOT function in SQL but you cannot use a CTE....
2014-06-04
1,274 reads
Power Pivot as the Core to your Power BI Solution
I’ve noticed a recent trend with many presentations and articles on Power BI and Excel functionality. Many of these presentations...
2014-06-03
1,126 reads
Access Granted or Not? Question of the Day
Access Granted or Not? is my latest Question Of The Day and I think it represents a pretty good troubleshooting...
2014-06-03
475 reads
I Voted For the 2014 PASS NomCom
I was interested to see that the online voting system has changed this year to one powered by Simply Voting....
2014-06-03
411 reads
SSAS Performance Logger Now Available
I’ve created a simple query performance logging tool for Analysis Services, called the SSAS Performance Logger. The tool allows you...
2014-06-03
482 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