Shrinking Database Log Files
Files in SQL Server need to grow as the database grows, and in very specific circumstances need to be shrunk...
2016-02-15
1,291 reads
SQL Saturday 496 Exeter – PreCon Agenda
Hi
Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like...
2016-02-14
512 reads
PASS Summit 2016 Program Committee
As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit. I have been on the program Committee the last 4...
2016-02-13
22 reads
PASS Summit 2016 Program Committee
As I usually do, I applied to be a member of the Program Committee for the 2016 PASS Summit. I...
2016-02-13
378 reads
Goodness-of-Fit Testing with SQL Server Part 5: The Chi-Squared Test
By Steve Bolton
…………As I’ve cautioned before, I’m writing this series of amateur self-tutorials in order to learn how to use...
2016-02-13
1,296 reads
Speaker of the Month: February 2016
I’ve been a little remiss on this. I just haven’t been getting out to see people speak for a while...
2016-02-12
460 reads
Reblog: SSIS Performance Testing
I had to do some performance testing for an MSSQLTips article and I thought I’d share the framework I used in...
2016-02-19 (first published: 2016-02-12)
1,742 reads
Limitation of In-Memory OLTP in SQL Server 2016 – Merge not supported with memory tables as target
Hi friends, in this post we will discussed another limitation of In-Memory OLTP that in-memory tables as a Target in...
2016-02-12
618 reads
SQL Family: The Wonder Years
Last week, Bill Wolf aka @SQLWareWolf and I somehow got onto the topic of High School pictures. So in jest, I...
2016-02-11
266 reads
Limiting Database Permissions for DLM Dashboard
I was talking with some of our support people recently about permissions on DLM Dashboard. A client was having issues,...
2016-02-18 (first published: 2016-02-11)
1,676 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