SQL Internals Reading Data Records Part 6: Variable Length Data
Welcome back Dear Reader to Part 6 on our series of how to read a Data Record. In Part 1...
2012-07-09
1,257 reads
SQLBalls
Differences in the Null Bitmap between SQL 2005 and 2012
Hello Dear Reader, I’ve been working on a series for BIDN.com, the Business Intelligence Developers Network, on how to read...
2012-07-05
1,229 reads
SQL 2000 TIPS AND TRICKS DECK AND DEMOS
Hello Dear Reader today I'm going to be presenting on SQL 2000 Upgrade tips and tricks for Pragmatic Works Training...
2012-06-28
1,203 reads
Cross Database Views and Schema Binding
One of the most interesting things I've found as a DBA is learning about features in other RDBMS platforms. Sure...
2012-05-31
2,617 reads
MAGICPASS Tonight It’s All About Encryption
http://www.flickr.com/photos/shuck/3971270079/
Tonight I will be live in front of my home town crew at MagicPASS, lead by the one and only...
2012-05-16
695 reads
SQL Rally Deck's and Demo's Up
Hello Dear Reader! I'm coming to you live from the wonderful SQL Rally in Dallas Texas. I have two sessions...
2012-05-10
506 reads
Thank You to the People That Get Us There
http://www.flickr.com/photos/saygoodie/4548042971/
Hello Dear Reader starting today out in Dallas Texas at the Dallas Convention Center is the Second Annual SQL Rally. ...
2012-05-09
678 reads
T-SQL Tuesday #30 TOP 5 Rules for the SQL Community *Screw Ethics
Chris Shaw (@SQLShaw|Blog) is hosting T-SQL Tuesday this month. It has been a while since I participated and this month...
2012-05-08
822 reads
SQL Saturday 130 Deck & Scripts Live
Hello Dear Reader, greetings from SQL Saturday 130 in Jacksonville. This is just a quick post to say that the...
2012-04-28
1,181 reads
See you at SQL Saturday 130 Jacksonville!
http://www.flickr.com/photos/rohicks/4788477593/
Hello Dear Reader, this Saturday April 28th is SQL Saturday 130 in Jacksonville FL! The good people from the Jacksonville...
2012-04-26
902 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 [email protected] 8 [email protected]If 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