Master Data Services error – Cannot read configuration file due to insufficient permissions
In preparation of my upcoming webinar on the new features of Master Data Services 2016, I installed MDS on my...
2016-10-23
2,336 reads
How DATEDIFF_BIG a new feature of SQL SERVER 2016 Can Keep You Out of Trouble
In the series of SQL SERVER 2016, this is a new post. in this post, we will discuss DATEDIFF_BIG and...
2016-10-22
862 reads
Columnstore Indexes – part 88 (“Minimal Logging in SQL Server 2016”)
Continuation from the previous 87 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Getting Data into the Database is one...
2016-10-22
594 reads
Fixing Untrusted Foreign Key or Check Constraint
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax.If...
2016-10-22
244 reads
Fixing Untrusted Foreign Key or Check Constraint
Untrusted constraints can be found when you alter/drop foreign key relationships and then add them back without the proper syntax....
2016-10-22
1,253 reads
If You Read One Article About Split String in SQL SERVER 2016s Read this One #3
In the Series of SQL SERVER 2016, this is another post. Before Jumping in detail just think if you have...
2016-10-22
965 reads
VMworld Europe 2016 Wrap Up
This past week I had the pleasure of attending our first VMworld Europe conference, held this week at the Fira Gran Via in...
2016-10-21
729 reads
Meet and Greet Data Pros at #sqlsummit
Next Monday night is the networking dinner that Andy Warren and I have put together for the last 6 years....
2016-10-21
498 reads
#RedgateRocks at the PASS Summit
If you are attending the PASS Summit next week in Seattle, and want to attend a fun party on Thursday...
2016-10-21
497 reads
How O’reilly Picks Sessions
Read this and wanted to share as we head to the PASS Summit next week: This is how we do it:...
2016-10-21
433 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