Using Power BI with Enterprise, On-premises Data
I just finished posting a 4-part series demonstrating how to use Power BI with on-premises data. The running time for...
2016-06-19
702 reads
Power BI Architecture Diagram v2 is Now Available
I finally finished putting together version 2 of my Power BI architecture diagram. I previously put together an architecture diagram...
2016-06-18
983 reads
The RGE
I first heard this little acronym from Grant Fritchey (b | t). He used it when talking about backups and restores,...
2016-06-24 (first published: 2016-06-17)
1,811 reads
Return Max or Min Value of a Group of Columns as a Single Column
Recently, I needed a query to identify tables that developers had create as point-in-time backups of tables that were never...
2016-06-17
792 reads
Upcoming Course – LFCE: Advanced Linux Networking
I’m pleased to announce that I’m working on a new course for Pluralsight.
The course is titled LFCE: Advanced Linux Networking.
This course targets IT professionals that design and maintain Linux...
2016-06-17
14 reads
Upcoming Course – LFCE: Advanced Linux Networking
I’m pleased to announce that I’m working on a new course for Pluralsight.
The course is titled LFCE: Advanced Linux Networking.
This...
2016-06-17
788 reads
Why is creating excel sheets from SSIS so hard ?
If there is one process that should be simpler than it is out of the box, it is creating Excel...
2016-06-17
1,457 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for SQL Server to give away. This is a book that I...
2016-06-17
22 reads
SQL Server Indexing Book Giveaway – Week 3
In past two weeks’ posts (1, 2) I talked about how I’ve got a few copies of Expert Performance Indexing for...
2016-06-17
728 reads
Connect to SQL Azure database from SSMS
In this article I'll show you how to connect to SQL Azure database instance and create a simple database. First you have...
2016-06-17
348 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