Sending Mail using SQL Server Express Edition
In SQL server standard and enterprise edition,A DataBase mail functionality in built to sent mail.But in SQL Server express edition,You...
2013-09-02
65,505 reads
Rare Species, Extinction and the MCM
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification series at Microsoft joined the ranks of...
2013-09-02
12 reads
Rare Species, Extinction and the MCM
As of 11:04 PM MST ( -6 UTC ), the Microsoft Certified Master along with the other certifications in the Advanced certification...
2013-09-02
1,220 reads
SQL Server: Data File Structure
In our earlier posts , we have discussed about various types pages in details. In this post let us discuss about...
2013-09-02
2,649 reads
Handling Large Many to Many bridge tables
In some scenarios you will need to create a many to many relationship in your cube in SSAS. One of...
2013-09-02
3,395 reads
70-457 Reviewer #11 Configuring and Maintaining a Backup Strategy
This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL...
2013-09-01
547 reads
Is the Master Certification Dead or Will it be Born Again?
The Certified Master and Architect community was collectively notified Friday, August 30, 10 PM Pacific Time (Microsoft Time) that the...
2013-09-01
944 reads
70-457 Reviewer #10 Managing SQL Server Agent
This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables...
2013-08-31
1,216 reads
Retiring of the MCM Certifications
The MCM is dead. Long live the MCM.
The small, exclusive club of SQL Server Microsoft Certified Masters is going to...
2013-08-31
4,255 reads
Terminal #MCM – 30 days to go
We just finished the webshow last night, when one of our chatroom fellows – Nic Cain – told us that the MCM...
2013-08-31
1,183 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