T-SQL Tuesday #48–Cloud Atlas
I never saw the movie, though it’s on my list to watch sometime. I love the Wachowski’s as directors.
This month...
2013-11-12
981 reads
Loadbalancing SQLServer
Loadbalancing SQLServer is not something that comes straight out of the box. If you want to use load balancing you...
2013-11-12
3,538 reads
Cargo Cult Data Professionals
Ever since David Moutray introduced me to the concept of cargo cult programming, it’s been running round and round in...
2013-11-12
985 reads
T-SQL Tuesday – Cloud Atlas – #TSQL2sDay
This month, Jorge Segarra (Blog | @SQLChicken) is running T-SQL Tuesday on the cloud. T-SQL Tuesday is a monthly blogging event where a number...
2013-11-12
792 reads
The Cloud Is Scary – #TSQL2sDay #49
It’s T-SQL Tuesday time! I haven’t contributed in a while, so I really wanted to participate this time. The topic...
2013-11-12
645 reads
T-SQL Tuesday #48 – Cloud Atlas
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will...
2013-11-12
554 reads
In-Memory OLTP and the Identity Column
Over the past month I've been playing around with the new In-Memory OLTP (code name: "Hekaton") features within SQL Server...
2013-11-12
1,530 reads
Index Fragmentation : Quick Tip
Fragmentation can cause issues for performance to the point of having queries not resolve at all. Your normally scheduled maintenance...
2013-11-12
440 reads
Prevent creating stored procedures with RECOMPILE hint – Policy Based Management is your friend !
I got motivated to write this post as there was a question on twitter which was like -
The user was...
2013-11-12
1,263 reads
How SQL Server Full Backups Work
I’m writing this in support of a few talks I give that talk about backups. This is how I see...
2013-11-11
920 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