NULL is not = to anything
One of the fun facts about SQL Server and the relation model is the
whole concept of three valued logic. Now...
2009-04-09
1,117 reads
Blog Posts
PASS Summit 2009 Call For Speakers Extended - And Why
Please consider this a not quite official announcement, look for that on the sqlpass.org site today or tomorrow.
You may have...
2009-04-09
1,218 reads
Prius Repair Update
We decided to let the pros replace the seat belts and do the other repairs and file a claim on...
2009-04-09
373 reads
Animation in Presentations
I've never been a fan of animation in Powerpoint presentations, and as a result almost never use them in my...
2009-04-08
421 reads
Annoying Your Best Customers
Why haven't I updated the build list for SQL Server 2008 with SP1? Read on...
Today I got a press release...
2009-04-08
446 reads
PASS Call for Speakers Deadline Extended
If you have been procrastinating about submitting a speaking abstract for the 2009 PASS Community Summit, you have been given...
2009-04-08
547 reads
SQL Server 2008 Service Pack 1 Released
Hi everyone!
Service Pack 1 for SQL Server 2008 has been released and now is available for download here
Some details:
- Slipstream...
2009-04-08
617 reads
It's a .NET World!
Next week I'll be giving presentations in Charleston and in Florence here in South Carolina.
Tuesday, April 14, 2009 - Pee Dee...
2009-04-07
638 reads
Minimalist Design - Part 2
Minimalist design can easily be confused with laziness, and also sometimes hard to tell the difference between minimalist and downright...
2009-04-07
369 reads
Never Delete Data
Should you ever delete data? In a production environment, do the benefits of deleting old data outweigh the possible risks?
Data...
2009-04-07
1,699 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