Find a useful system store procedure to list all mapping user of SQL login account.
sp_msloginmappings @Loginname , @Flags
@loginname: the login account name, If...
2013-09-27 (first published: 2013-09-24)
9,903 reads
As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...
2013-09-24
750 reads
Hello Dear Reader! We are finishing up the final day of the Performance Tuning Workshop here in Atlanta and I...
2013-09-26 (first published: 2013-09-24)
7,538 reads
I have gone through and made some minor updates and bug fixes for all of my SQL Server Diagnostic Information...
2013-09-24
1,200 reads
As you may have seen in my post yesterday “PASS Board of Directors Election: Candidates announced” I am running for...
2013-09-24
707 reads
Sometimes I see confusion on the difference between a data warehouse (DW) and master data management (MDM). Below is a...
2013-09-24
1,460 reads
One of the things that can make Windows Azure SQL Databases (WASD) attractive is the fact that they run inside...
2013-09-24
774 reads
Tim Ford is running for a seat on the PASS Board of Directors and has my vote. Yes I think...
2013-09-24
606 reads
If you’re in the DC/Baltimore area, or just feel like coming to DC to learn about SQL Server, please join...
2013-09-24
525 reads
Recently I wrote about the myth that you can’t use an alias in an UPDATE statement. You can of course,...
2013-09-24
890 reads
By Steve Jones
I caught this interesting item over on Pinal Dave’s blog: Eleven Interview Questions that...
By Hemantgiri
I use color-coded connections in SSMS to distinguish Production, Pre-Production, UAT, and Development. But...
Comments posted to this topic are about the item Building a SQL Server Fleet...
Comments posted to this topic are about the item Smart AI Agents and Data...
Comments posted to this topic are about the item 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