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
Blog Posts
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
How to let non-admin business users run replication agent jobs
This blog post is basic in nature but highlights a very real requirement that may arise when administering replication. Occasionally...
2012-01-19 (first published: 2012-01-13)
2,119 reads
Introducing “X on XMLA”
XMLA or XML for Analysis is used in SQL Server Analysis Services and other multidimensional data systems to manage the...
2012-01-19
549 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
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
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
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
The Hockey Team to Represent a Truly Bilingual City: Let’s Give Cunneyworth The Proper Chance He Deserves to Lead the Canadiens to a Stanley Cup Someday as Al McNeil Did in 1971
The Media in Quebec has opened up 2012 with a continuation of what it wishes to disseminate, or more probably,...
2012-01-19
3,091 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
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