SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 (Redmond, WA) Session Files
SQL Saturday 108 Replication Magic
Session files are now available for download. The zip file...
2012-02-26
923 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
[Shameless Plug] Can We Have Your Vote?
[Shameless Plug] Can We Have Your Vote?
SQL PASS SQLRally
Argenis Fernandez (|@DBArgenis) and yours truly have submitted a Pre-Conference for SQL...
2012-02-08
1,070 reads
Breaking Down TempDB Contention (part 2)
Breaking Down TempDB Contention (part 2)
Tempdb Contention via Idera Diagnostic Manager
I wrote a somewhat popular script and blog post a...
2012-01-30
3,030 reads
The Kind of DBA I Want to Be
The Kind of DBA I Want to Be
Rokusaburo Michiba (Iron Chef Japanese)
I was a big fan of the original Iron...
2012-01-27 (first published: 2012-01-22)
2,806 reads
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Values in Data Ranges Without a Lookup Table
Including Missing Data
One of the ways that I learn new things...
2012-01-14
1,729 reads
Webcast: Putting a Better SQL Server in Production
Webcast: Putting a Better SQL Server in Production
Production Line
Webcast:Putting a Better SQL Server in Production
Date: Wednesday, January 18, 2012 3:00...
2011-12-26
1,246 reads
Using Dynamic Values in XMLA
Using Dynamic Values in XMLA
XMLA
A question was raised on Twitter today via the #sqlhelp hash tag about passing parameter values...
2011-12-18
1,939 reads
Undocumented Gotchas of Transactional Replication
Undocumented Gotchas of Transactional Replication
Gotcha - Norelco commercial (1977)
This discussion started on Twitter via the #sqlhelp hash tag. The question that...
2011-12-17
1,400 reads
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
PASS Data Arch. Virtual Chapter: Row Versioned Data Warehouses
Subject:Row Versioned Data WarehousesStart Time:Thursday, December 15, 2011 6:00 PM US Pacific...
2011-12-14
813 reads
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
PASS Data Arch. Virtual Chapter: On beyond Zebra AdventureWorks OR where did I go wrong?
Subject:On beyond Zebra AdventureWorks or where...
2011-11-15
1,066 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