Starting with Chocolatey
I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time,...
2017-01-09 (first published: 2017-01-02)
3,226 reads
Presentations & Blogging of 2016 in Review
For the 4th year in a row, I am keeping data on my professional engagements to help the others –
public...
2017-01-02
419 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor and I’m humbled to be included in this...
2017-01-02
21 reads
Microsoft Most Valuable Professional – Data Platform
Today, I’m proud to announce that I have been named a Microsoft MVP – Data Platform. This is an exceptional honor...
2017-01-02
664 reads
Grateful to have been a Microsoft MVP
A couple of weeks ago I received the disappointing but expected news that I wasn’t renewed as a Microsoft Data...
2017-01-02
441 reads
Make Your Application's Name Heard
Odds are, you’ve got more than one application or script accessing your database or SQL Server instance at any given time. You’re probably stacking them on a small number...
2017-01-02
13 reads
Identifying Blocking Chain in SQL Server
HAPPY NEW YEAR 2017!!
I hope you all had a good Christmas and New Year. I always try to review my...
2017-01-01
13,138 reads
2016 – A Year to remember
2016 has undoubtedly been a landmark year in my life. To me it marked my first conscious entry into mid...
2016-12-31
820 reads
Data Channel - Interview 02 - Hamid Fard on SQL Server Memory Capacity Planning
Dear All,
Welcome to the second interview of Data Channel. Very happy and proud to have Mr Hamid Fard, MVP and...
2017-01-06 (first published: 2016-12-31)
1,837 reads
Performance-Oriented SQL Server Development – The Scripts
Last Thursday, I delivered my seminar, Performance-Oriented SQL Server Development at the Expert Days conference in Israel.
It was a great experience,...
2016-12-30
924 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