The Hassles of Travel - Part 2
I didn't want to go on this trip, but I agreed to do it. Now I regret it.
My flight to...
2009-01-18
778 reads
Blog Posts
It's Minus Twenty-Five Outside and I'm Writing about Transaction Log Files
(1linerForward) I originally wrote this in French while working at LaCaisse.com - http://dbhive.blogspot.com/2008/07/fichiers-journaux-de-transactions.html
Why do you care, as a DBA, or a Developer...
2009-01-17
7,610 reads
List Objects in a Filegroup in SQL Server 2005
I have tried hard to google a SQL query to find what objects exist in a specific filegroup, but in...
2009-01-16
12,557 reads
Loading Up For Travel
I fly to the UK tomorrow, not really my favorite thing to do, so I’m trying to ensure I can...
2009-01-16
788 reads
Comments on Pro Full-Text Search in SQL 2008 by Michael Coles
Apress sent me a free review copy, so I took a quick look through it at lunch. I've used full...
2009-01-15
607 reads
devLINK Technical Conference to Be Held in Nashville, TN in August
The 2009 devLINK Technical Conference will be held in Nashville, TN, August 13-15, 2009. This three-day conference provides technical content...
2009-01-15
478 reads
Have you disabled autoplay yet?
If not, you should. Because autoplay being on means any time a removable data device, such as a USB stick,...
2009-01-15
752 reads
Honoring a Contest
Over the last six months or so, Pepsi has been running a PepsiStuff promotion on many of their products. They...
2009-01-15
651 reads
How Humans Behave
It is strange how people react in different circumstances. Yesterday while going through the forums, there was an interesting post....
2009-01-15
452 reads
Microsoft Solution Accelerators on TechNet
I was browsing through the new titles that are on Safari and saw some planning guides around Windows Server 2008...
2009-01-15
822 reads
Blogs
Ten Years of PowerShell
Ten years ago, I published a post about filming a Pluralsight Play by Play...
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...
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