Case Sensitive searches in T-SQL
I just ran into an issue with one of my applications where a SQL statement had updated a status code...
2012-01-19
2,845 reads
SSRS Tip: Hide a tablix if no rows returned
I have a tablix in an SSRS report, populated by a query that might or might not return any rows. ...
2012-01-19
2,187 reads
Session Code – Extending Reporting Services with Custom Code
This is my wish list of things I’d like to cover in todays session at 11 AM EST https://www1.gotomeeting.com/register/935071481 but...
2012-01-19
3,532 reads
Dedicated Administrator Connection
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that those functions were in some DMOs and that you...
2012-01-19
8 reads
Dedicated Administrator Connection
Recently you may have read my article about some hidden functions in SQL Server. In that article you learned that...
2012-01-19
982 reads
SQL Server – Powershell Excel to HTML
SQL Server, Powershell and Excel are a good mix . But saving to Powershell output to HTML is versatile – if requiring...
2012-01-19
863 reads
Master Data Services 2012
As I mentioned in a pervious post Master Data Services for SQL 2012 is a huge improvement over the SQL...
2012-01-19
3,612 reads
Update Statistics and the new TraceFlag 2371
What comes first, the chicken or the egg? What happens first – update statistics or re-compilations?
The Statistics life cycle
As a regular...
2012-01-18
386 reads
Blackout
What more can I say. I disagree with the kind of legislation that is being presented via SOPA and PIPA. In support of the community, my site will be...
2012-01-18
7 reads
Blackout
What more can I say. I disagree with the kind of legislation that is being presented via SOPA and PIPA.
In...
2012-01-18
806 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