Microsoft & R Programming Session Materials & Resources Available
Last Thursday night I had the pleasure of speaking with Gregory Kramer and his friends at the Madison, WI Power...
2016-01-26
1,038 reads
Does an index scan always read the entire index?
No.
That’s a bit short for a blog post, so let me explain. First, the difference between a seek and a...
2016-01-26
525 reads
Tim Ford’s Entry-Level Content Challenge
All bloggers started as beginners. We picked things up, learned them, and got to the point where we wanted to start sharing our knowledge. The problem is that most...
2016-01-26
17 reads
Tim Ford’s Entry-Level Content Challenge
All bloggers started as beginners. We picked things up, learned them, and got to the point where we wanted to...
2016-01-26
581 reads
What is an Identity?
Identity (or AutoNumber) is a column that automatically generates numeric values. A start and increment value can be set, but...
2016-01-26
142 reads
What is Normalization in SQL Server?
In relational database design, the process of organizing data to minimize redundancy is called normalization. It usually involves dividing a...
2016-01-26
207 reads
What is Power BI?
One of the “benefits” of being a chapter leader is that sometimes it means doing a presentation yourself when you...
2016-02-02 (first published: 2016-01-25)
3,029 reads
Creating a Database Snapshot
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-01-29 (first published: 2016-01-25)
2,765 reads
Monday Morning SQL Break – January 25, 2016
It’s Monday and time for this week’s blog and twitter round-up. If you haven’t already, follow me on twitter (@StrateSQL)....
2016-01-25
399 reads
Finding Your Query in Query Store
Query Store is pretty amazing. I’m loving working with it. I think it’s likely to change how query tuning will...
2016-02-01 (first published: 2016-01-25)
2,366 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