Speaking at SQL Server Days 2015
I have the great pleasure to announce I’m speaking for the 5th time at the Belgian SQL Server Days! The...
2015-07-15
662 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
Power BI Confusion
Just a quick post on some Power BI material that I believe should reach as many people as possible. I get...
2015-07-14
1,636 reads
Thoughts on Power Query and SSIS
Recently I received a very interesting question on Twitter from Jeremy (blog | twitter):
@jmarx definitely yes
— Koen Verbeeck (@Ko_Ver) July 10,...
2015-07-13
2,566 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
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
Doing a Full Outer Join in Power Query
A while back a give a session at the element61 Microsoft Business Analytics Day, a free event where the capabilities...
2015-07-09 (first published: 2015-07-02)
3,845 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
Hello world!
Hi there!
Although this looks like my first blog post, it actually isn’t. This is the new place for my blog,...
2015-07-08
380 reads
How to drop a Temporal Table
No no, I didn’t say temporary, but temporal! SQL Server 2016 introduces a great new feature called Temporal Tables. Or...
2015-07-03
2,785 reads
My first SQL 2016 bug
A little while back SQL Server 2016 CTP2 was announced and I have spent some time playing with it (read: spent...
2015-06-29
1,468 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