PolyBase: I now Pronounce you SQL and Hadoop
Are you interested in Hadoop? With SQL Server 2016 just around the corner, a powerful new feature is being included called...
2016-04-27
1,052 reads
My Cable Modem Keeps Rebooting!
There are obviously quite a few things that could cause internet issues that are totally out of our control, but...
2016-04-27
469 reads
Columnstore Index Enhancements in SQL Server 2016
One of my most favorite technologies is Columnstore. Thankfully, the guys at Microsoft seem to agree with me, because they...
2016-05-10 (first published: 2016-04-27)
7,022 reads
Power BI and the Bing Maps API
This week I was working on a project for a school up North. This customer wanted to use Power BI...
2016-05-10 (first published: 2016-04-26)
4,278 reads
MongoDB : How to get Top, Bottom,Middle and Range of records
In MongoDB,the limit() method is used to limit the result set to be returned. You can also use this with various...
2016-04-26
9,307 reads
Upcoming conferences
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing SQLBits, I’ll still be getting a chance to enjoy...
2016-04-26
10 reads
Upcoming conferences
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...
2016-04-26
396 reads
Upcoming conferences
It’s shaping up to a busy year for conferences, well busy by my standards that is. While I’m unfortunately missing...
2016-04-26
876 reads
Interview with Warwick Rudd
Part of traveling to various events and being a part of the SQL Community means one can meet some pretty...
2016-05-09 (first published: 2016-04-26)
1,016 reads
Strengthsfinder Results
I recently took the Strengthsfinder evaluation and thought I’d save the results here.
2016-04-26
619 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