Applied SQL: Server Side Traces
It’s time to get your server side trace on, with a little practical application!
I introduce this whole concept in Applied...
2011-08-29
779 reads
Blog Posts
Code Camp New Zealand 2011
I was unable to go to TechEd this year but I did get a chance to hit up Code Camp. It...
2011-08-29
932 reads
Creating Facebook page for blog
Few weeks ago I released my SSMS productivity add-in and it has already almost 200 downloads. Responses are quite warm...
2011-08-29
851 reads
Inserting Records AND Getting The Identity in SSIS - Part 2
Since I posted a ways back on retrieving the identity value for inserts in SQL Server Integration Services, I've learned many things...
2011-08-29
7,079 reads
Inserting Records AND Getting The Identity in SSIS - Part 2
Since I posted a ways back on retrieving the identity value for inserts in SQL Server Integration Services, I've learned many things - one of which is an inline solution for...
2011-08-29
62 reads
Inserting Records AND Getting The Identity in SSIS - Part 2
Since I posted a ways back on retrieving the identity value for inserts in SQL Server Integration Services, I've learned many things - one of which is an inline solution for...
2011-08-29
1,107 reads
Notes From The 2011 Jacksonville Code Camp
In a departure from my usual plan, this year I drove up to Jacksonville mid-morning in time to have a...
2011-08-29
833 reads
SQL Saturday #90 OKC
This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first...
2011-08-29
921 reads
SQL Saturday #90 OKC
This past Saturday, I made the relatively short (3 hour) drive north to Oklahoma City to participate in their first...
2011-08-29
831 reads
SQL Saturday #90–Oklahoma City recap as chauffeur and speaker
I’d never been to Oklahoma City, and when Kristin Ferrier asked me to come to SQL Saturday #90 and do...
2011-08-29
925 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