Big Numbers
What had me reflecting on numbers was an article in the Financial Times (Conduit of Contention if you can find...
2011-07-29
1,504 reads
Blog Posts
Build a schedule for SQL Saturday
A new feature has been added to SQL Saturday. Now when you register for an event you can build your...
2011-07-29
1,437 reads
Calling SCOM in C#
Written by David Postlethwaite
I’m sure there are many out there using System Centre Operations Manager (or SCOM for short)...
2011-07-29
3,966 reads
Dual monitors, dual laptops, and the best way to manage them
Here is a tip that could make you much more productive: At home, I have a desktop computer with dual-monitors...
2011-07-29
2,298 reads
Marking FK Constraints NOT FOR REPLICATION
When administering Merge Replication, sometimes we need to mark foreign
key constraints NOT FOR REPLICATION. In some cases, we might...
2011-07-29
7,756 reads
Modified Insert Unknown Row to Dimension Table
A little over a year ago Patrick LeBlanc wrote a blog post about inserting an unknown row into a dimension. ...
2011-07-29
2,917 reads
Re-blog – July 22-July 28
As I mentioned in the introductory post, I’m summarizing posts from previous years in the the past week. Some posts...
2011-07-29
1,516 reads
Roundup for Un-SQL Friday #005: Bad Interviews
It’s time for the Un-SQL Friday #005 roundup!
From managers…
First up, The Lone DBA admits that he wasn’t always (ahem) one of us…he’s got...
2011-07-29
1,777 reads
SQL Azure – simple description, part I.
I was studying SQL Azure parameters some time ago and found out that there are no materials which tell you...
2011-07-29
1,774 reads
SQL Server Hardware Book News and Reviews
Today was an exciting day, since I discovered that fellow SQL Server MVP Brent Ozar (Blog|Twitter) had posted a very...
2011-07-29
1,485 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