SQL University: Precedence Constraints
Welcome back, class! In our last class, we setup a parent-child package configuration and showed how you can pass variables...
2011-05-06
2,112 reads
sqlchicken
SQLRally OverDrive Events!
So you’re going to SQLRally in Orlando next week? Want to take advantage of ALL of the awesome opportunities presented?...
2011-05-06
401 reads
Policy-Based Management and Local Password Policy
This post is based on an interesting question/situation that was posted over at ASKSSC.com today. The user asked how to...
2011-05-04
1,404 reads
Parents Just Don’t Understand
Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship...
2011-05-02
669 reads
SQL University: Parents Just Don’t Understand
Welcome to the second week of SSIS this semester at SQL University. Today we’re going to talk about the relationship...
2011-05-02
603 reads
Be the Master of your Data Warehouse Universe at SQLRally!
Do you have a data warehouse initiative in your current organization and looking for a way to learn how to...
2011-04-14
855 reads
Find Table Heaps Using Policy-Based Management
This is just a quick post in regards to a conversation I just had via Twitter. If you don’t already...
2011-04-08
1,025 reads
Meme Monday: 11 Words or Less
Looks like time for another meme, this time from Tom LaRock (Blog | Twitter). He challenged us to write a blog...
2011-04-04
380 reads
24 Hours of PASS: Day 1
Yesterday was the first day of PASS’ 24 Hours of PASS event. For those not familiar, 24 Hours of PASS is...
2011-03-16
769 reads
SQL University Lecture Series: Women in Tech
This week SQL University is on Spring Break but we’ve lined up some activities to help keep students busy (you...
2011-03-16
662 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