Database Adminstration Scalability
database administration scalabilityI am working on a project that is very successful in terms of its market
share, i.e. product users...
2008-11-27
1,876 reads
Pumpkin Tossing
One more holiday post. Hope you all enjoyed Thanksgiving and are now enjoying either a quiet and well deserved day...
2008-11-27
1,368 reads
Does regulation make data any safer?
Working with healthcare organizations, I am constantly aware of the restrictions my staff and I must abide by according to HIPAA constraints. ...
2008-11-27
1,678 reads
Happy Thanksgiving
I'm cheerfully taking the day off today (and tomorrow too!), and I'm writing this a week in advance as I...
2008-11-26
1,460 reads
Workaround Primary Key Violations in SSIS
Before you get much further, please do not use this for every case where you have issues with duplicate rows....
2008-11-26
1,522 reads
Surface Demo
Second try. The video didn’t embed in the previous post. Nor this one. Here's the link
Microsoft Surface Demo
This is from...
2008-11-26
1,436 reads
Surface Possibilities
This is interesting. I’m not sold on Surface, though I did play with one last week in Seattle.
2008-11-26
1,394 reads
Spend Money to Make Money
One of those old sayings that has a grain or two of truth to it. Stocks, real estate, education even,...
2008-11-25
1,563 reads
Airlines Don't Care About Customers? Nor Does The Government!
I saw this post about a recent panel that tried to come up with guidelines for airlines as far as...
2008-11-25
1,394 reads
Catching Up
My goal of 400 posts a month has been in jeopardy with all the traveling I've been doing over the...
2008-11-25
1,483 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