Data Compare on Temporal Tables
I hadn't seen much talk on doing data comparisons on temporal tables, as they are a new feature. I went...
2016-11-02 (first published: 2016-10-28)
3,144 reads
This Week In Data – Episode 10 (Getting Started with Azure)
Welcome back to another episode of This Week In Data! If you missed our previous episodes, you can watch them...
2016-10-28
845 reads
SQL Server Compression 101
The data compression feature in SQL Server can help reduce the size of the database as well as improve the performance of intensive I/O intensive workloads, especially on data...
2016-10-28
13 reads
SQLDinner/Meetup Tonight at PASS Summit
If you’re at the PASS Summit and would like to meet some new people, come see us from 5:30 to...
2016-10-27
751 reads
First thoughts on Power BI on premises
The wait is over, the Reporting Services team finally released a preview for Power BI Desktop reports hosted on premises...
2016-11-01 (first published: 2016-10-27)
3,483 reads
PASS Summit Friday Night Activity
Anyone staying until Saturday from the PASS Summit in Seattle? Be at the Seattle Underground at 530p for a 6p...
2016-10-27
433 reads
Distributed Databases - One Way Synchronization
Applies to: xSQL Data Compare v7.0.0 – v9.0.0
Business Need
A very common organization of the data infrastructure for big companies who operate in many countries and use some type of...
2016-10-27
11 reads
Distributed Databases - One Way Synchronization
Applies to: xSQL Data Compare v7.0.0 – v9.0.0
Business Need
A very common organization of the data infrastructure for big companies who operate...
2016-10-27
327 reads
PASS Summit Keynote 2 – Release 2
Dr. David DeWitt is getting ready to take the stage to a huge ovation and is thrilled to be back...
2016-10-27
591 reads
PASS Summit Keynote 2 – Release 1
Grant Fritchey taking the stage to talk about the financial health of PASS.
250k members , 170 countries, and 87% global representation...
2016-10-27
566 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