Audit All Select Statements
Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required that queries be audited and tracked to reach compliance...
2016-08-08
70 reads
Audit All Select Statements
Legislation and regulation sometimes dictates that certain activities must be tracked within a database. On occasion, it will be required...
2016-08-15 (first published: 2016-08-08)
2,582 reads
Top 5 books on Enterprise Architecture
My post the top 3 books for becoming TOGAF certified punlished last week looked at books on preparing for the...
2016-08-08
443 reads
Current Running Queries
Following script is perhaps the most executed script in my 10 year Database Administration career. The script has been my...
2016-08-11 (first published: 2016-08-07)
3,082 reads
Create a Date Dimension in Azure SQL Data Warehouse
Most data warehouses and data marts require a date dimension or calendar table. Those of us that have been building...
2016-08-11 (first published: 2016-08-06)
2,461 reads
AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
AdvertisementsAlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
I have recently come across an issue that, one of my alwaysON secondary replica...
2016-08-16 (first published: 2016-08-06)
16,379 reads
BIT9 PathNames
We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the daily news.
Related Posts:
Cannot Open Backup Device January 1, 2020...
2016-08-05
10 reads
BIT9 PathNames
We live in a day and age when security (data, network, server, etc) is seemingly at the forefront of the...
2016-08-05
1,052 reads
What is the Lambda Architecture?
Lambda architecture is a data-processing architecture designed to handle massive quantities of data (i.e. “Big Data”) by using both batch-processing and...
2016-08-08 (first published: 2016-08-05)
3,250 reads
Visual Studio Live!–Washington DC–Save with me
I’m going to be speaking this fall at Visual Studio Live, Washington D.C. edition on Oct 3-6. This is my...
2016-08-05
461 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