SQL Server Recovery Models
A SQL Server database can be in one of three recovery models. FULL, BULK_LOGGED and SIMPLE. The recovery model you...
2010-10-12
1,969 reads
Speaking at South Florida SQL Server User Group
I will be speaking at the South Florida SQL Server User Group on October 13 via Live Meeting. My topic...
2010-10-12
446 reads
SQLSaturday#59 - Interview with Robert Pearl (1st in series)
SQLSaturday#59 - Interview with Robert Pearl (1st in series) - Say what?
As we get the countdown under way, I caught up...
2010-10-12
1,224 reads
Google Wind
I’m not sure Google is a better company than Microsoft or some of the other extremely large companies that get...
2010-10-12
820 reads
Press Release: SQLSaturday#59 Speaker Session Schedule Announced...
Source Event Home Page: http://www.sqlsaturday.com/59/eventhome.aspx
Written & Distributed by: Robert Pearl
You may have heard that we’re planning an event in NYC, called...
2010-10-12
950 reads
Review: NPR Baseball Driveway Moments
NPR Baseball Driveway Moments ($15 @ Amazon) is an audio book I got from the local library to listen to on...
2010-10-12
391 reads
A Haunting TSQL Tuesday Tale
If you truncate a table, you cannot undo the action like you can with a delete. What is the difference between the two methods to remove data from a...
2010-10-12
8 reads
A Haunting TSQL Tuesday Tale
Time for the ghouls and goblins to come out of the woodwork once again for another tale of deception and...
2010-10-12
1,432 reads
T-SQL Tuesday #12 - Misconceptions
It’s time for T-SQL Tuesday again, and I’m happy to participate again. This is a monthly blog party started by...
2010-10-12
1,266 reads
Running Totals for Each Group
A while ago, I posted a blog on how one could perform running totals using Reporting Services and a user...
2010-10-11
4,402 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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