SQL Server Management Studio – Footloose and Fancy Free
That’s right. There’s been a divorce. SQL Server Management Studio (SSMS) has been divorced from the server product. In fact,...
2015-07-20
733 reads
I’m Speaking! Edmonton SQL Server User Group
I am honored to be speaking at the Edmonton SQL Server User Group. I always find it humbling to be...
2015-07-20
487 reads
Orlando SQL Saturday Precon – Transform and Visualize Data with Power BI
I found out a couple of weeks ago that I will speaking at the Orlando SQL Saturdayfor the first time...
2015-07-24 (first published: 2015-07-20)
2,118 reads
The Database Corruption Challenge
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes...
2015-07-20
373 reads
The Database Corruption Challenge
For the last ten weeks Steve Stedmen (blog | twitter) has been running a database corruption challenge. The final challenge closes...
2015-07-20
1,014 reads
How to close all active database connections in one shot?
While trying to restore SQL Server database or do any other actions which require exclusive database access you may face...
2015-07-20
8,278 reads
Filtered Index restrictions and Kendra Little’s Index Quiz
A few weeks ago I saw a tweet about Kendra Little’s (b/t) new SQL Server Quizzes. Of course I had...
2015-07-24 (first published: 2015-07-20)
2,185 reads
SQLSaturday Orlando 2015–Classes on Thursday and Friday for Even More Learning
We have a solid tradition here in Orlando of offering some all day classes the Thursday and Friday before SQLSaturday....
2015-07-20
634 reads
SQL Server Polybase (2016)
What is SQL Server Polybase?
Coming in SQL Server 2016 is the ability to query relational tables as well as data...
2015-07-20
1,329 reads
Introduction To Temporal Tables In SQL Server 2016
Hi friends, today I will get you introduced with another new feature of SQL Server 2016 i.e. Temporal Tables. SQL...
2015-07-23 (first published: 2015-07-20)
3,099 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