Microsoft SQL Server 2016 Certifications Announced
Hi friends, Microsoft has announced the release of three new SQL 2016 certifications, based on the different working database professional’s...
2016-07-08
809 reads
SQL Server Basic - Memory
For those of you who just started to manage SQL server might wonder why SQL server use so much memory....
2016-07-08
867 reads
SQL Server and Continuous Integration
This is the 1st in a series of posts on SQL Server and Continuous Integration. Some of the tools I’ll be...
2016-07-07
762 reads
Using sp_executesql Parameters –#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-07-07
881 reads
Virtualization does not equal a private cloud
I see a lot of confusion when it comes to creating a private cloud. Many seem to think that by...
2016-07-07
1,364 reads
Zilch to Speaker: 2016 Summit Abstract Reviews
Steve Jones (b/t) has been asking people to post their Pass Summit submissions and the reviews that came back, along...
2016-07-07
451 reads
Influence Skills: Live From London Day 3
The main news this morning: Wales' heroic efforts at the Euros came to end last night with a 2-0 defeat...
2016-07-07
395 reads
Tempdb monitoring - Free space alert
SQL Server uses tempdb for many features, including row versioning, service broker and query execution amongst others. During the execution...
2016-07-07
3,862 reads
T-SQL Tuesday #080
T-SQL Tuesday time is here again! And I’m honored to be hosting this months block party. Why you ask? T-SQL...
2016-07-07
926 reads
Why MongoDB?
MongoDB is Object-Oriented, simple, dynamic and scalable NoSQL database. It is based on the NoSQL document store model, in which...
2016-07-06
773 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