Overview
Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The purpose behind database mirroring is continuous data availability and...
2016-09-03
106 reads
Overview
Database mirroring is a feature in SQL Server which is creating and maintaining the redundant copies of the database. The...
2016-09-09 (first published: 2016-09-03)
11,183 reads
Weekly Summary
Last week I was holiday in Cyprus. The weather was plus 30 degrees celsius all week. The pool was...
2016-09-02
527 reads
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More fixes and more features. In this latest release, they...
2016-09-02
15 reads
The SQLMonitor team at Redgate has been releasing updates at a much more rapid rate…what’s this mean to you? More...
2016-09-02
483 reads
That’s right, SQL Saturday Charlotte is coming September 17, 2016. Next to the annual PASS Summit, this is my favorite...
2016-09-01
396 reads
Overview To save any organisation from any big future loss, one needs make a proper strategy or disaster plan that...
2016-09-01
498 reads
With the evolution of SQL Server, there is an evolution in Extended Events. New features in SQL Server also means there may be some additional default sessions.
Related Posts:
Changing Default...
2016-09-01
18 reads
Remember When…
Back in late December of 2015, a challenge of sorts was issued by Tim Ford (twitter) to write a...
2016-09-13 (first published: 2016-09-01)
2,448 reads
Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower...
2016-09-01
411 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item 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