A Week of Books - Part 2
I'm just finishing up Boards At Work which talks about how a good board of directors can make a big...
2008-12-15
576 reads
Blog Posts
PASS Presentation Evaluation Results
Just as I did last year I'm posting my evaluation scores for review. I co-presented with Steve Jones a session...
2008-12-15
814 reads
SQL Quiz Part 2
I was recently tagged by Tim Mitchell to give a response to Chris Shaw’s SQL Quiz Part 2 so here...
2008-12-15
821 reads
SQL Server 2005 SP3
… has arrived: http://www.microsoft.com/downloads/details.aspx?FamilyID=ae7387c3-348c-4faa-8ae5-949fdfbe59c4&displaylang=en
It’s obviously hot off the presses because the “What’s New document” is 404.
2008-12-15
681 reads
SSIS - Fast Parse
I had another chance last week to answer an email follow up question from the session Brian and I gave...
2008-12-15
8,516 reads
St. Louis Day of .Net
Yesterday I spoke on 2008 T-SQL and Data Types at the St. Louis Day of .Net event. This was an...
2008-12-14
424 reads
FriendFeed Review
I’ve been trying the social networking thing, with accounts on Twitter, Facebook, and LinkedIn. I guess I have one on...
2008-12-12
779 reads
SQL Quiz #2 - Toughest Challenges in my Career
I finally got tagged for the SQL Quiz, which I've been following. Michelle Ufford, aka SQLFool, tagged me following her...
2008-12-12
1,351 reads
Calories Burned During Sex
Ah, if you're reading this aren't you the curious one! I ran across the link below a while back and...
2008-12-11
646 reads
How Do I Configure SSIS to Work With a Named Instance
How Do I Configure SSIS to Work With a Named Instance?
By default, SSIS (SQL Server Integration Services) uses the msdb...
2008-12-11
12,812 reads
Blogs
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...
T-SQL Tuesday
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
Exploring DiskANN: Part 2: PQ, SSDs, caching and beam search
How I used AI for this postChatGPT to generate images based on info specifically...
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