Author of the Year at MSSQLTips.com
I have the pleasure and privilege to announce that I was awarded with the “Author of the Year” award at...
2015-01-13
521 reads
Koen Verbeeck
- Twitter: @https://twitter.com/Ko_Ver
- Website: https://sqlkover.com/
- LinkedIn: https://www.linkedin.com/in/kverbeeck/
The mysterious permission issue
As you might have realized, this is not the title of an Agatha Christie book, but rather about some nasty...
2015-01-09
783 reads
Better late than never…
Just like last year, I’m a bit late with the obligatory “how was last year and what is this year...
2015-01-08
642 reads
Overview of Published Articles – 2014Q4
Here is an overview of the articles I published in the last quarter of 2014.
INTENSE SCHOOL
MCSE Prep: Overview of T-SQL Windowing...
2015-01-07
530 reads
Formatting Durations in SSAS: Caveat
I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read...
2014-12-22
726 reads
Nominated for the 2014 Tribal Awards
Just like last year, SQLServerCentral.com and Simple Talk are hosting the Tribal Awards. In their words:
The Tribal Awards, co-hosted by Simple-Talk and...
2014-12-18
860 reads
PASS BI VC recording is available now
The recording of the webinar I did for the PASS BI virtual chapter is live!
(Quick reminder: it was the same...
2014-12-05
741 reads
Beware the defaults! (in windowing functions) – The Movie!
I was recently contacted by the fine gents of Webucator, an online training services provider. In order to promote their...
2014-11-27
1,081 reads
Nominated for Author of the Year
I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at...
2014-11-20
535 reads
PASS BI VC: How to (not) torment your fellow SSIS developer?
On November 17th 2PM CET I will redo my SQL Server Days presentation How to (not) torment your fellow SSIS...
2014-11-12
707 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