Extended Events and Fixed Schemas
Working with databases, XML, and many software applications, it is not uncommon to deal with fixed schemas. In the database...
2015-09-14
533 reads
What SQL Server components are installed on this machine?
Figuring out what components of SQL Server are installed on a particular machine has always been a task that has...
2015-09-14
631 reads
SQL Server’s statistics
Again another interesting article from RED GATE …
SQL Server’s statistics provide the query optimizer with the information it needs to...
2015-09-14
880 reads
Split personality text editing in SSMS with Sublime Text 3
Split personality text editing in SSMS with Sublime Text 3
My preview post showed a demonstration of the multi-cursor editing power...
2015-09-14
207 reads
SQL Server – Methods to find running totals of a column
HI friends, in some working scenario or during interviews we got the task to find the running totals of a...
2015-09-14
620 reads
Houston TechFest Presentation Downloads
Thanks for joining me at Houston TechFest 2015 at the NRG Center in Houston, TX! Big congrats to Michael and...
2015-09-13
480 reads
HammerDB Performance Collection with SQL Server – Updated
A while back, my friend Mike Fal ( b | t ) released a PowerShell script that can sample the counter inside SQL...
2015-09-24 (first published: 2015-09-13)
2,414 reads
Step by Step SSIS learning What Data Conversion use in SSIS ? TIP#116
Dear Friends,
In the series of step by step learning of SSIS this is part #6 in which we are going...
2015-09-13
963 reads
GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
458 reads
GAM and SGAM
In my previous blog, I tried to explain How SQL Server Manages your data in pages and extents. (Link for...
2015-09-12
853 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