Learning R: Foundations
Learning a programming language is largely an act of using that language to do stuff. Done.
However, the big thing about...
2015-12-07
1,261 reads
Performance Tuning with sp_BlitzIndex
Just a small blog post about how I used sp_BlitzIndex for the first and how awesome that was. sp_BlitzIndex is one...
2015-12-10 (first published: 2015-12-07)
3,299 reads
Powerful SQL Queries for SQL Server
New Year, new powerful SQL queries!
Start the New Year off with some great Transact-SQL training and join me for...
2015-12-07
456 reads
What's New in SQL Server 2016, Community Technology Preview 3 (CTP 3.1)
What's New in SQL Server 2016
Benefits of SQL Server 2016:
Enhanced in-memory performance provides up to 30x faster transactions, more than...
2015-12-07
137 reads
Puzzled by T-SQL
Live blogging this a bit as I try things. This will update a bit, so you’ll have to read through.
Adam...
2015-12-03
1,418 reads
Run T-SQL in Parallel
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations and I have written and improved it many times...
2015-12-03
18 reads
Run T-SQL in Parallel
Writing CLR procedures to run T-SQL concurrently is not an extremely new idea. I have seen a lot of implementations...
2015-12-03
2,984 reads
Speaking at SQLSaturday Nashville in January 2016
I’m starting the new year with a trip to Nashville for SQLSaturday #480 to do presentation on automating restores. New topic,...
2015-12-03
575 reads
Question of the Day: Check, Please
This one is live today, it’s about Powershell and restoring databases, based on some scripting I had been working on....
2015-12-03
560 reads
Changing Course On Learning
With all the new stuff on the Microsoft Data Platform, it’s really hard to keep up with it all. I had...
2015-12-03
504 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