Re-blog – January 13 – January 19
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-01-20
573 reads
PASS Summit session videos online
If you are interested in viewing the recorded sessions for the PASS Summit 2011, you can order the DVD. You...
2012-01-20
906 reads
Database uplevel Restores Follow On
Today's post is a follow on from one earlier this month Database uplevel Restores. I got round to testing restoring...
2012-01-20
1,149 reads
Rename an Analysis Services Instance
This is just a short post for Friday. I have been working a fair amount with SSAS and the rest...
2012-01-20
5,596 reads
Local Community Events & User Groups from Around Town....
Staying true to the meaning of SQL Community with respect to local chapters and user groups, I wanted to bring you...
2012-01-20
1,582 reads
SQL Cachestore flush
For each cleared cachestore in the plan cache SQL Server reports a message in the error logs , such as :
SQL...
2012-01-20
1,184 reads
The top 5 reasons to speak at SQL Rally
Have you been thinking about speaking at the upcoming SQL Rally in Dallas? If so, remember that the deadline for...
2012-01-20
748 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
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
RECONFIGURE can flush the procedure cache
I ran across this KB article the other day, which lists a few ways in which performance is affected by...
2012-01-24 (first published: 2012-01-19)
2,202 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