T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
T-SQL Tuesday #024 – Using SYSTEMRESTRICTSCHEMA Function in MDX to Query DMVs
This blog entry is participating in T-SQL Tuesday #024, hosted...
2011-11-08
1,796 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
How Do I Spell #SQLFamily? #SQLNomz Of Course
How Do I Spell #SQLFamily? #SQLNomz Of Course
Nomz (Doma Kun)
It’s time for Meme Monday again, and this month’s theme is...
2011-11-07
1,186 reads
SQL PASS Summit 2011: Session Files
SQL PASS Summit 2011: Session Files
PASS Summit 2011
This past week was the SQL PASS Summit 2011 in Seattle, WA. I...
2011-10-17
1,430 reads
Presentation Files: 10 Things All BI Administrators Should Know
Presentation Files: 10 Things All BI Administrators Should Know
I sooooo remember this sign!
I was very excited to get to present...
2011-09-30
2,010 reads
Auditing Users in a Failover Partner Database
Auditing Users in a Failover Partner Database
SQL Audit is Watching
I read a question on a discussion list today asking if...
2011-09-20
1,640 reads
The Barking Dog Analogy
The Barking Dog Analogy
Maggie and Woody
A discussion started today on Twitter about CXPacket waits. There had been a heated debate...
2011-09-20
1,107 reads
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...
2011-09-12
912 reads
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
September 15 Data Arch VC Meeting: Architecture Career Paths for SQL Server Professionals
Subject:Architecture Career Paths for SQL Server ProfessionalsLevel:200 (Intermediate)Start...
2011-09-12
827 reads
Session Files for Replication Magic Presentation to WSSUG
Session Files for Replication Magic Presentation to WSSUG
Replication Magic
I presented my session on Replication Magic: Initializing from Backup to the...
2011-08-26
1,383 reads
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
August 18 Data Arch VC Meeting: John Racer on Data Warehouse Architecture
Subject:Data Warehouse ArchitectureLevel:200 (Intermediate)Start Time:Thursday, August 18, 2011 1:00...
2011-08-15
1,401 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Forums
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
Smart AI Agents and Data Security
Comments posted to this topic are about the item Smart AI Agents and Data...
RegEx Functions IV
Comments posted to this topic are about the item RegEx Functions IV
Question of the Day
RegEx Functions IV
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', 'i') AND BusinessEntityID IN (7,8)See possible answers