Loading a Text File from T-SQL
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-02-10 (first published: 2016-02-01)
3,396 reads
SSC Editorial: Design a Better SQL Server Pricing Model
Design a Better SQL Server Pricing Model ran on January 21, 2016 and as you can guess from the title is...
2016-02-01
590 reads
Monday Morning SQL Break – February 1, 2016
It’s Monday and time fora round-up of last week’s blog and twitter activity – and even an on-time post for all of...
2016-02-01
474 reads
Learning R: Happy With My Book Choice
This is just a quick update. I wrote about the two books I’m using to learn R. Well, I’m extremely...
2016-02-01
507 reads
Running code on the startup of SQL Server
Every now and again you need to run code when your instance starts up. For example you might want to...
2016-02-08 (first published: 2016-02-01)
1,477 reads
TempDB Excessive Memory Usage Example
I see TempDB using more memory than I feel it should and found a way to resolve it. Previously I dove into technical details and questioning what I saw...
2016-02-01
31 reads
TempDB Excessive Memory Usage Example
I see TempDB using more memory than I feel it should and found a way to resolve it. Previously I...
2016-02-05 (first published: 2016-02-01)
2,756 reads
Memory Fundamentals for SQL Server - AWE ( Address Windowing Extensions), /PAE Switch (Physical Address Extension)
In the previous blog we saw the difference between Virtual Address Space between 32-bit and 64-bit systems. We also saw...
2016-02-05 (first published: 2016-02-01)
4,749 reads
My Best Blog Posts from 2015
ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...
2016-02-01
37 reads
My Best Blog Posts from 2015
ALWAYS LEARNING About mid-way into August of 2015, I learned some important new factors in Search Engine Optimization (SEO) that caused me to make some big changes to the way in...
2016-02-01
29 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