Using Power BI to list Enterprise Only SQL Features
Someone recently asked me if there was a list of all the SQL Server “Enterprise Only” features available on the...
2016-07-19
663 reads
What's the difference between Scrum, Kanban, Lean and XP?
…I’m about to find out.
Continuing with the July training programme, this week I producing Learning Tree course 918 Agile Fundamentals:...
2016-07-19
461 reads
Getting started with In Memory OLTP in SQL Server 2016 – Part 1
In Memory OLTP (Hekaton) introduced in SQL Server 2014 is a new database engine component which is optimized for OLTP...
2016-07-18
709 reads
Retrieving diagnostic data from SQL Server’s Default Trace
Have you ever tried to query the contents of the default trace and then spent more time trying to figure...
2016-07-18
481 reads
Speaking at SQL Saturday #513 in Albany, NY on July 30th – PowerShell and SQL Server
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-07-18
330 reads
Power BI Custom Visuals Class (Module 08 – Dot Plot)
In this module you will learn how to use the Dot Plot Power BI Custom Visual. The Dot Plot is...
2016-07-20 (first published: 2016-07-18)
2,369 reads
Building locally from VSTS
One of the things that you need with a Continuous Integration server is that ability to build your software on...
2016-07-22 (first published: 2016-07-18)
1,496 reads
Monday Morning SQL Break – July 18, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on twitter (@StrateSQL). This is a good chance to catch...
2016-07-18
16 reads
Monday Morning SQL Break – July 18, 2016
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2016-07-18
817 reads
Speaking at SQL Saturday 513 in Albany, NY on July 30th - PowerShell and SQL Server
If you are a SQL Server professional and are interested in spending a day with a bunch of other like-minded...
2016-07-18
140 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