Reblog: What’s the deal with Excel and SSIS?
SQLKover update: When I read this old blog post of mine, all I can think about is: Power Query to...
2015-07-10
1,339 reads
100th post
This is my 100th blog post here at LessthanDot!
(I’m not lying, check for yourself)
I started blogging at the end of...
2015-07-10
525 reads
Podcast about my career and the SQL Server Community with Chris Bell
During my time at SQL Saturday in Philadelphia (Early June), Chris Bell invited me to be a guest on his...
2015-07-09
693 reads
Why I won’t be running SQL Server Standard Edition on Business Critical Servers!
I keep getting questions around what core features are missing in Standard Edition of SQL Server,and why there is a...
2015-07-09
1,163 reads
Introduction To Dynamic Data Masking in SQL Server 2016
In release of SQL Server 2016 CTP 2.0 another new feature that is released is Dynamic Data Masking. Using Dynamic...
2015-07-09
614 reads
Overview of Published Articles – 2015Q2
Here is an overview of the articles I published in the secondt quarter of 2015.
INTENSE SCHOOL
Book Review: Query Tuning & Optimization by...
2015-07-09
532 reads
SQL Server Storage best practices
Server storage is one of the most important things for SQL Server performance. Chances to utilize a lot of RAM and...
2015-07-09
3,481 reads
Proper Aliasing will help you somewhere TIP#104
Recently, When we were delivering session on “SQL SERVER” one of the persons asked why we require Aliasing so I...
2015-07-09
469 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
1,342 reads
Layer a database into a SQL Server container
In my previous post on running SQL Server in a container I showed how you could use the Spoon (https://spoon.net)...
2015-07-08
42 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