SQL Server 2016 Stretch Database
SQL Server 2016 Stretch Database
One of the features in SQL Server 2016 that you will want to explore is the...
2015-08-17
1,298 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-21 (first published: 2015-08-17)
1,963 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-17
31 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of...
2015-08-17
36 reads
Shared databases or private databases?
Traditionally database developers have shared a database and while this certainly made sense when everyone had a limited amount of ram and a few hundred megabytes of hard disk...
2015-08-17
14 reads
Using Power Bi with my DBA Database
Every good DBA should have a DBA database. A place to store information about all of their instances and databases.
I...
2015-08-21 (first published: 2015-08-16)
4,348 reads
A Quote from Spock
My mom gave me a book about Leonard Nimoy recently and we talked later about the impact his life had...
2015-08-15
582 reads
How to manage SQL Server security with SQL Source Control
One of the most common issue you can find when source controlling the database is about the security. How to manage...
2015-08-15
441 reads
How to manage SQL Server security with SQL Source Control
One of the most common issue you can find when source controlling the database is about the security. How to manage...
2015-08-20 (first published: 2015-08-15)
2,213 reads
Happy Independence Day - Jai Hind
Wishing you a very
Happy Independence Day
" We owe a lot to the Indians, who taught us how to count, without which no worthwhile scientific discovery could have been made....
2015-08-15
12 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