RegEx Those Dates
Recently I was working on transforming some dates, and wanted to generate a large n number of dates for testing....
2014-12-15
1,306 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
- Bluesky: way0utwest.bsky.social
- Threads: @way0utwest
SQL Server Disk Space Emergencies
One of the things I’ll see happen often with SQL Server instances is that the system will run out of...
2014-12-15 (first published: 2014-12-08)
7,695 reads
2014-12-15
1,770 reads
The Last Job
Steve Jones contemplates employment and the future of the last job he'll have. This Friday he asks you if this might be yours.
2014-12-12
164 reads
Citizen Programmers
Steve Jones finds the Salesforce platform interesting and notes we have lots of "citizen programmers" doing work with data.
2014-12-11
146 reads
T-SQL Tricks – Customizing SSMS Templates with Parameters
I wrote briefly about templates in Management Studio (SSMS), and showed the default templates that come with SQL Server. I...
2014-12-11 (first published: 2014-12-03)
7,056 reads
Converting Dates
I ran across a post recently where someone had dates stored as characters (never good), but also in this format:...
2014-12-10
862 reads
Holiday Struggles
The sporadic schedule of a day or two a week this holiday season has been a struggle for Steve Jones.
2014-12-09
188 reads
T-SQL Tuesday #61 – Giving Back
It’s that time of month again, the time when we have a day where everyone writes on the same topic.
This...
2014-12-09
662 reads
We Still Need Human Judgment
Computers aren't necessarily more infallible than humans, and they aren't necessarily even going to make better decisions. We still need humans in the decision process.
2014-12-08 (first published: 2010-06-23)
200 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