The Data Janitor
I was joking with Buck Woody on Facebook the other day and he mentioned he’d been a data janitor at...
2009-04-07
773 reads
Blog Posts
Data Type Conversions
Lately I’ve gotten a lot of questions submitted to SQLServerCentral that have dealt with weird data type issues. We had...
2009-04-06
592 reads
LinkedIn - Part 3
As I've covered in my two earlier posts I've been investing a little time to figure out how to make...
2009-04-06
495 reads
New SSIS Book to be Released
If you've noticed a significant drop in my blogging I apoligize but I've been working on an exciting project with...
2009-04-06
680 reads
Dealing with Difficult Forum Users - The Flip Side
Earlier I talked about dealing with the difficult forum user from the perspective of providing help. Now let us look...
2009-04-05
1,999 reads
It’s all magic to me.
Technorati Tags: SQL Server,I/O"Any technology, no matter how primitive, is magic to those who do not understand it."
freefall
Arthur C. Clarke...
2009-04-05
602 reads
Measuring the Impact of Task Switching/Multitasking
Many of us make a living by working on tasks while monitoring email, taking a few calls, and in non...
2009-04-05
473 reads
Prius Repair #1
I’m aborting for now. I think I could replace the seat belts, but I don’t have the right part at...
2009-04-05
561 reads
A Variable Length Random String
I was looking through some of the active threads on SQLServerCentral.com tonight, and I ran across one with some code...
2009-04-04
3,648 reads
New Years Resolutions 2009 – Q1 Update
How am I doing on my New Year’s Resolutions for SQLServerCentral? I decided to make another update as Q1 has...
2009-04-03
677 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