S3OLV August Meeting II
I recently published a post about the upcoming meeting for S3OLV. This post is to serve as an update to...
2011-08-08
578 reads
Blog Posts
Security Is Your Responsibility
My primary responsibility at my organization is no longer to be the security architect and incident response team lead. I...
2011-08-08
963 reads
SQL MCM Training – Day 0
For the next 3 weeks I'm in Bellevue/WA for the SQL MCM training provided by Paul
Randal, Kimberly Tripp, and Bob...
2011-08-08
647 reads
SSRS Export En Masse
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found myself in need of extracting all RDLs from a...
2011-08-08
43 reads
SSRS Export En Masse
Have you ever found yourself in need of exporting all of the reports from a Report Server? I have found...
2011-08-08
2,548 reads
Tools to make creating MDX much easier
For those of you who use MDX, I’m sure you share my opinion that MDX is a lot harder to...
2011-08-08
798 reads
What SQL Server Books Do You Recommend?
Reprinted and amended from my editorial at Database Weekly.
For nearly 11 years now, one of the most common questions people...
2011-08-08
1,059 reads
Chennai SQL Server User Group and me
My one week long search to identify active SQL Server community in Chennai ended last Sunday.
Chennai SQL Server User Group...
2011-08-07
2,025 reads
Delete backup files older than days
For almost all sql backup jobs, we want to have a step to delete old backup files older than a...
2011-08-06
4,549 reads
Audit SQL Logins
Written by David Postlethwaite There are several ways that you can audit who has logged in to your SQL Server. The...
2011-08-05
4,779 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