Increased Productivity with the Pomodoro Technique – TAPtips
Today's TAPtips is about Increased Productivity with the Pomodoro Technique. Have you tried the Pomodoro Technique? If so, what were...
2017-01-10
274 reads
My first Microsoft MVP Award!
Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing...
2017-01-10
11 reads
My first Microsoft MVP Award!
Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing my career in the fields of data analysis, processing...
2017-01-10
11 reads
Power BI Custom Visuals Class (Module 33 – Sankey Bar Chart)
In this module you will learn how to use the Sankey Bar Chart Power BI Custom Visual. The Sankey Bar...
2017-01-10
756 reads
Query Optimizer and Data Definition Language Queries
Data Definition Language queries don’t go through the optimizer, right? While normally, my short answer to this question in the past would...
2017-01-10
600 reads
My first Microsoft MVP Award!
Exactly 10 years ago I started my career as a Software developer in a Bank, which for me meant directing...
2017-01-10
185 reads
Connect suggestion to add included columns to sp_helpindex
I’m a big fan of the sp_help system stored procedures, which is why I’ve been a bit disappointed that the...
2017-01-10
466 reads
Why Data Warehouse Projects Fail
Data warehouse projects are among the most visible and expensive initiatives an organization can undertake. Sadly, they are also among...
2017-01-10
1,106 reads
T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
18 reads
T-SQL Tuesday #86 – Adding when DBCC CHECKDB last ran to the SYS.DATABASES catalog view
Brent Ozar is hosting TSQL2sDay #86 this month and in response to Brent Ozar’s Call for Important Connect Items I wanted to highlight this one about adding the date...
2017-01-10
12 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