Limit Results Based on Aggregated Threshold
Problem
A post was recently added to one of the forums that I monitor so that I can help users in...
2011-04-11
1,716 reads
Blog Posts
Powershell Day 11
Day 11 COM and WMI Powershell is a very powerful language, with Powershell we can achieve same result with the...
2011-04-11
922 reads
Slides & Samples for my SQLbits session
As announced in both of my sessions, you can download the slides & samples for
my SQLbits sessions here:
Message
in a Bottle: Service...
2011-04-11
760 reads
SQLBits Attendance Breaks Previous Records
How many people can you identify in the above photo from the closing party at SQLBits? Can you find Ola...
2011-04-11
1,357 reads
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan....
2011-04-11
1,125 reads
SSIS Job Ownership
I was strolling along one day when I saw somebody asking how to find out who owns a maintenance plan. That evolved into finding out who owns the the...
2011-04-11
32 reads
T-SQL Tuesday Reminder – Coming next week
Matt Velic is hosting T-SQL Tuesday this month. You have a week to get a post ready on the apply...
2011-04-11
1,411 reads
A SQL Server Hardware Nugget A Day – Day 10
Wow, we are 1/3 of the way through this series! Today’s post is “Classic Intel Xeon Processor Numbering Explained”. By...
2011-04-10
372 reads
A SQL Server Hardware Nugget A Day – Day 9
For Day 9 of my SQL Server hardware series, I want to give my current recommended AMD Processor List for...
2011-04-10
597 reads
Powershell Day 10
Day 10 Working with Directory and Registry As you know, Powershell works with command prompt, and you know it works...
2011-04-10
306 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