Hiring Your First Employee
Visit Business of Software
It’s my boss, or rather the owner of the company I work for (yes I work for...
2008-12-22
670 reads
Call It a Day, or a Day Minus 2 Milliseconds
There's one report that I look at every day to assess how things are going on a project we launched...
2008-12-21
617 reads
Sp_altermessage “Classic”, much better than “New” sp_altermessage
I was reading through the SQL Server 2005 SP3 release notes yesterday (sadly, it was enjoyable) and clicked through to...
2008-12-19
807 reads
Version Restores
I saw a question today on restoring a SQL Server 7 backup to SQL Server 2005, and I wasn't sure...
2008-12-19
670 reads
A Week of Books - Part 5
Last and not least this week, The Snowball: Warren Buffett and the Business of Life. This is an authorized biography...
2008-12-18
711 reads
SQL Quiz: Two Mistakes
I was tagged by Gail Shaw to post two big mistakes made during my professional career. The only challenge here...
2008-12-18
843 reads
Evaluate Jack Corbetts Blog
My friend Jack has been blogging for almost a year now and is looking for feedback. If you're a blogger...
2008-12-18
598 reads
The December Car Update
I missed the November Car update, but I was too busy with the PASS Summit to get one done.
However last...
2008-12-18
665 reads
A Week of Books - Part 4
Magazines today instead of books, but hopefully you'll count that as close enough to my theme of the week. I...
2008-12-17
543 reads
Dos and Don'ts for Projecting a Professional Image on the Internet
In a previous blog post, I suggested that less than professional content, that you or others post on the Internet...
2008-12-17
1,168 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