Jason Ash

Enable FIPS 140-2 Compliance in SQL Server

What is FIPS? How do I use it? What is going to break if I do use it?

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(6)

You rated this post out of 5. Change rating

2018-06-25

7,319 reads

It’s time for T-SQL Tuesday again and this is a great prompt to start...

T-SQL Tuesday is a monthly blog party hosted by a different community member each...

How I used AI for this postChatGPT to generate images based on info specifically...

Comments posted to this topic are about the item Databricks Genie Spaces for SQL...

Comments posted to this topic are about the item The Costs of Multiple Platforms

Comments posted to this topic are about the item RegEx Functions II

I have this data in a table in a SQL Server 2025 database:

EmailAddressID EmailAddress
7              dylan0@ADVENTURE-WORKS.COM
8              Diane1@ADVENTURE-WORKS.COM

If I run this query, which row(s) are returned?

SELECT top 10
 *
 FROM person.EmailAddress
 WHERE REGEXP_LIKE(EmailAddress, '^d')
 AND BusinessEntityID IN (7,8)