tSQLt in Azure SQL Database
I was excited to hear about the v12 Azure databases supporting CLR assemblies. Mainly because I’ve been doing testing work...
2015-09-07 (first published: 2015-08-27)
4,118 reads
Using Power BI with HDInsight Part 1: Power Query and Files
With the rise of HDInsight and other Hadoop based tools, it is valuable to understand how Power BI can help...
2015-08-27
713 reads
Getting Started With Power BI Desktop: Simple Visualization
This is the third installment of our Getting Started With Power BI Desktop series. The first post is about installation...
2015-08-27
820 reads
Entity Sync Relationship - Master Data Services 2016
Entity Sync Relationship is a new feature in Master Data Services 2016. It enables you to share entity data between different models. You can keep a single version of...
2015-08-27
371 reads
Relational databases vs Non-relational databases
I see a lot of confusion about the place and purpose of the many new database solutions (“NoSQL databases”) compared...
2015-08-27
1,526 reads
Does SQLSaturday Increase Chapter Attendance?
One of the big goals for SQLSaturday was for it to be a membership drive. It’s worked hugely well in...
2015-08-27
726 reads
SQLSat403 – Recap
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event...
2015-08-27
359 reads
SQLSat403 – Recap
The doors close, lights turn off, and cars begin to pull out of the parking lot. Another SQL Saturday event...
2015-08-27
629 reads
Reblog: Force installation of 64-bit ACE OLE DB provider
Anyone working with SSIS and Excel probably had the following issue: you are creating an SSIS package using an Excel...
2015-08-27
769 reads
Brentozar’s Training: Chocolate & Cowboy Hats Included
It was entertaining to listen to a technical wizard fighting the obsession with waiting to eat chocolate with 3k viewers...
2015-08-27
323 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