In the previous post (http://www.sqlservercentral.com/blogs/denniss-sql-blog-1/2016/09/30/say-hello-to-sql-live-health-check-part-1/) I talk about the main screen where you can have a single glance of the...
2016-10-05
1,341 reads
If you have just begun using SQL Server 2016 or you have been using it for a while now you...
2016-10-05
3,120 reads
Problem
A common misconception that i've heard a few times around backups is that a FULL backup invalidates previous TRANSACTION LOG...
2016-10-04
326 reads
In this module you will learn how to use the Chiclet Slicer Power BI Custom Visual. The Chiclet Slicer is...
2016-10-04
977 reads
It’s another week of travel for me, starting early this morning. This is another crazy trip, and yes, I did...
2016-10-04
405 reads
Last year I published an article on SQLServerCentral from Guarab Vohra on using SQL Prompt with a VCS. I really...
2016-10-04
650 reads
In our earlier blog we discussed an introduction to MongoDB. so, how is MongoDB is into BigData, MongoDB has a...
2016-10-04
488 reads
I’ll be delivering two webinars for MSSQLTips.com in the coming months. The first one is about the – amazing – new features...
2016-10-04
594 reads
Has SSMS (SQL Server Management Studio) been crashing on you? Have you been getting Out of Memory messages when attempting...
2016-10-04
7,272 reads
Question – Can you detach a corrupt database? Answer – IT DEPENDS! More specifically it depends on the SQL Server version. SQL...
2016-10-04
612 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