Finding orphaned database users
Database users can become orphaned for a few reasons. For example, a database restore to another instance or deleting the...
2011-10-29
1,639 reads
DATABASE_OBJECT_CHANGE_GROUP do not audit SP or other object
Deepak Kumar (friend of mine and founder of http://www.sqlknowledge.com ) were chatting yesterday. We were discussing about audit feature in SQL...
2011-10-29
1,894 reads
Updatable Subscriptions Removed in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
2,008 reads
Updatable Subscriptions Deprecated in SQL Server 2012
After spending some time looking at SQL Server 2012 CTP3, it appears as if Transactional Publication with Updatable Subscriptions will...
2011-10-29
4,045 reads
How to hide Calculated Members in MDX SSAS
With some calculated members in MDX it only makes sense to see the calculation if a certain Hierarchy is used....
2011-10-28
2,530 reads
PASS Summit 2001 In Review…WOW!!!
It has been a couple of weeks and I have had time to get back in the groove at a...
2011-10-28
1,707 reads
SQL Server Analysis Services Performance Guide published
Another must read white-paper: Analysis Services 2008 R2 Performance Guide.
This white paper describes how business intelligence developers can apply query...
2011-10-28
2,527 reads
Displaying blank sub report
Recently I had to convert a stand alone report into a sub-report. That report was very simple… it had two...
2011-10-28
1,049 reads
Play the Bob Ross Game
I was in a meeting a few weeks ago, deadlines looming and everyone feeling the stress some. We hit a...
2011-10-28
803 reads
Convert comma separated string to table and vice versa
I know that this subject has been blogged about numerous times but I thought I'd post an alternative way of...
2011-10-28
9,437 reads
Blogs
The SUM of Nothing: #SQLNewBlogger
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
How to Move the SSMS Status Bar to the Top and Color-Code SQL Server Connections
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
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