Minimalist Design
I'm been in tactical mode lately, building an advertising management system for one of our projects. Actually it's v2, the...
2009-03-25
1,610 reads
Some Common Date Routines
I'm sure that these routines are available in a variety of locations, this just adds one more place that people...
2009-03-25
39,783 reads
Gone Dark
This afternoon was quite interesting around the office. A strong thunderstorm moved through the area, a common occurrence in Texas...
2009-03-25
1,405 reads
How to Deal with the Difficult Forum User
It has happened to us all at one time or another. We are trying to help someone on an online...
2009-03-25
1,562 reads
Launch Replication Monitor Without SSMS
I manage a lot of replication publications\subscriptions and when I get a latency or agent failure alert it always bugs...
2009-03-25
857 reads
What a fortnight I had
This has been one of the most stressful fortnight in this company. I did not feel this stressed when our...
2009-03-25
487 reads
Touch Your Resume
One of the pieces of advice that I give in my talk "The Modern Resume" is that you should review,...
2009-03-25
1,603 reads
Overload & Stress - Part 2
Yesterday I was commenting on how a big part of stress for me is getting that sudden burst of work...
2009-03-24
830 reads
PASS 2009 Summit Site Open
Registration has been open since the last Summit, but this year Bill Graziano and team have released the Summit 2009...
2009-03-24
590 reads
Ada Lovelace Day – Celebrating Women In Technology
Today is Ada Lovelace Day, an international day of blogging to draw attention to women excelling in technology. I don't...
2009-03-24
745 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
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
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
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