2012-02-08
1,162 reads
Blog Posts
My upcoming speaking engagements
In the last weeks it was very silent on my weblog, but life is pretty fast in 2012.
Currently I'm preparing...
2012-02-08
579 reads
Not enough storage is available to complete this operation
This message appears in the TDP SQL dsmsched file. It’s usually associated with low levels of contiguous memory
BackupVirtualDeviceSet::SetBufferParms: Request large...
2012-02-08
3,458 reads
RYO Maintenance Plan – Database Backups, Part 3
4 out of 5 DBAs agree
I’ve covered creating my backup directories and the actual backup of the database(s). The last...
2012-02-08 (first published: 2012-02-06)
2,339 reads
Using Reporting Services as your Software Frontend
Microsoft SQL Server Reporting Services is an excellent and easy-to-use platform for creating, viewing, managing, and subscribing to reports of...
2012-02-08
689 reads
What is Microsoft Connect?
Microsoft Connect (blog, twitter) is a site where you can post feedback to improve the quality of many Microsoft products and...
2012-02-08
764 reads
Whitepaper – Extending Reporting Services with Custom Code
Today Pragmatic Works released a whitepaper I wrote and I thought I would share it with you. Prepare for Marketing...
2012-02-08
1,645 reads
A Script A Day - Day 7 - Memory Queries
Today's script is a collection of a few memory queries I've collected from various sources over the years. These queries are by no...
2012-02-07
2,342 reads
Arithmetic Overflow in sp_MSarticle_validation
This is probably a rare occurrence — but I've noticed that data validation for an article with 10 billion or more...
2012-02-07
1,021 reads
Avoiding Bad Query Performance
There’s a very old saying, “When you find yourself in a hole, stop digging.”
And my evidence today is:
That’s certainly not...
2012-02-07
1,214 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
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
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...
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