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...
2015-08-27
1,497 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
207 reads
Use FILEPROPERTY to find free space in all the database
The use of SpaceUsed property of the FILEPROPERTY function gives how much space is used also we can derive lot...
2015-08-26
1,006 reads
Uploading Files to an HDInsight Cluster (No Scripting Required)
As I noted in my first post, I am not a fan of scripting. In that post we set up...
2015-08-26
904 reads
Critical Virtualized Database Education at VMworld
If you are one of the lucky ones who gets to attend VMworld USA this year, and you have any...
2015-08-26
632 reads
SSC Editorial: Annual Security Compliance Training
Compliance training, never a fun topic and I think that is too bad. A combination of companies checking the box,...
2015-08-26
718 reads
The Problem With AshleyMadison - » Syndication
What is the real problem with the AshleyMadison data breach? Well, let...
The post The Problem With AshleyMadison appeared first on...
2015-08-26
601 reads
Agile Development – A DBA’s Initial Thoughts
I recently had the opportunity to attend a three day Agile development workshop. At a very high level, Agile development...
2015-08-26
630 reads
Slides and Demos for SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
42 reads
Slides and Demos for SQLSupper August meeting
Last night I had a lot of fun presenting on one of my favorite topics, MARS and SQL Server protocols...
2015-08-26
51 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