The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it should be used carefully because it could often not...
2016-06-11
15 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
647 reads
The COUNT function in T-SQL
The COUNT function is among the most used functions in the T-SQL codes. Even though COUNT is easy to use, it...
2016-06-11
408 reads
Not More Than 16 Characters?!?
Microsoft, you’re killing me. This is the warning I received when typing in a password for Office 365:
I blinked when...
2016-06-16 (first published: 2016-06-10)
4,091 reads
How To Get A Free SQL Server Indexing Book – Week 2
Free Book! Another free indexing books, more awesome! In last week’s post, I talked about how I’ve got a number of copies of Expert Performance Indexing for SQL Server;...
2016-06-10
10 reads
How To Get A Free SQL Server Indexing Book – Week 2
Free Book!
Another free indexing books, more awesome!
In last week’s post, I talked about how I’ve got a number of copies...
2016-06-10
943 reads
Database Scoped Configurations
In SQL Server 2016, one of the key management improvement is a new feature that is called Database Scoped Configurations.
This...
2016-06-10
2,083 reads
SQL Server 2016 NYC Launch Event - Slide Decks Posted!
Quick post-event follow-up of our very successful SQL Server 2016 NYC Launch Event! We would like to thank ALL our...
2016-06-10
1,422 reads
MS Exams Increasing In Price
Just glanced through the MCP newsletter and see that the price of the exams (or at least the one I...
2016-06-14 (first published: 2016-06-09)
2,655 reads
PowerShell – Disk Space Monitoring and Early Warning Reports
Disk space is one of those things that frequently runs out of space no matter how much you bump it...
2016-06-09
1,343 reads
Blogs
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
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