SQL Server 2016 FK operator bug?
I recently read an a blog on MSDN that covered new features for the query optimizer in SQL Server 2016....
2016-07-29 (first published: 2016-07-25)
2,037 reads
Deploying Row Level Security with SQL Compare
Row Level Security (RLS) is a great new feature in SQL Server 2016. It’s been in Azure SQL Databases for...
2016-07-29 (first published: 2016-07-25)
1,299 reads
Monitor Query Performance
Blog post #7 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Sooner or later when you’re working...
2016-07-28 (first published: 2016-07-25)
2,630 reads
Blogger Questions: What should I blog about?
Over the last four years I’ve blogged almost 400 times. It’s become a refuge, a resource, a source of pride,...
2016-07-25
436 reads
Fourth Week in July
This is the fourth week of four of my July training programming and this week we have two courses that...
2016-07-25
342 reads
Speaking at SQL Server Geeks Annual Summit 2016
I am very happy and proud to share the news that I will be speaking in SQL Server Geeks Annual...
2016-07-25
423 reads
Learn About SQL Server Master Data Services 2016
SQL Server 2016 comes up with the new release of Master Data Services (MDS). In it, some new features have...
2016-07-28 (first published: 2016-07-25)
2,476 reads
Happy Birthday Power BI!
Today marks one years since Power BI was officially released. It’s been an amazing ride and I’d like to thank...
2016-07-24
500 reads
Descriptive Statistics with SQL and R – II
In the previous post I looked into some very basic and common measures of descriptive statistics – mean, median and mode,...
2016-07-24
632 reads
CISL 1.3.0 is released
I am extremely proud to share with everyone the news that the long-awaited and quite overdue release of the CISL...
2016-07-24
448 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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