You can create a database under the assumption that SQL looks after all the problems of concurrency. It will probably work fine under test conditions: then, in the production environment, it starts losing data in subtle ways that defy repetition. It is every Database Developer's nightmare. In an excerpt from his acclaimed book, Alex Kuznetsov explains why it happens, and how you can avoid such problems.
2010-07-09
3,657 reads
Take a look at a sample chapter and see who won copies of this book from our Question of the Day Contest.
2007-09-13
2,779 reads
Longtime author here, Michael Coles, has written a new book on SQL Server 2005 Programming and has sent us a sample chapter on SQLCLR programming. Download the chapter and source code and grab this great book from your favorite bookseller.
2007-05-03
4,295 reads
Apress is giving away some copies of this book on SQLServerCentral.com by sponsoring our Question of the Day. A sample chapter is also available online now!
2005-12-15
4,659 reads
Cryptography and encryption are coming to many systems, including databases. Check out a sample chapter from this upcoming book.
2005-11-07
3,859 reads
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item 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