Randomizing Names with Data Masker
Data Masker for SQL Server is pretty cool. It can reduce your attack surface area and exposure under the GDPR...
2018-05-18 (first published: 2018-05-07)
3,216 reads
Blog Posts
Why I blog: TSQL Tuesday #102
It’s TSQL Tuesday again! This month our host is Riley Major (b/t) and the subject is Giving Back. He’s given...
2018-05-18 (first published: 2018-05-08)
1,820 reads
Automate SQL Server Database Restoration using bacpac with PowerShell or Batch techniques
Data is the key to your organization’s future, but if it’s outdated, irrelevant, or hidden then it’s no good. Maintenance...
2018-05-17 (first published: 2018-05-08)
4,754 reads
Creating Custom Conditions In SQL Server Policy Based Management
In my last post I covered some basic policy based management examples, in this post I want to cover writing...
2018-05-17
74 reads
Creating Custom Conditions In SQL Server Policy Based Management
In my last post I covered some basic policy based management examples, in this post I want to cover writing...
2018-05-17
91 reads
Day 17 Backup and Recovery
There are there types of Backup: Full Backup Incremental Backup Bin-Log Backup Full Backup: is a complete backup of the...
2018-05-17
248 reads
Installing OpenSSH Server on Windows 10
So in yesterday’s post we learned that the OpenSSH client is included with the Windows 10, Update 1803! Guess, what else is included in this server, an OpenSSH Server! Yes,...
2018-05-17
33 reads
Installing OpenSSH Server on Windows 10
So in yesterday’s post we learned that the OpenSSH client is included with the Windows 10, Update 1803! Guess, what else...
2018-05-17
2,562 reads
Managing Business Logic
Encapsulating business logic into data movement and presentation is a critical part of a stable information management strategy. Too often,...
2018-05-17
307 reads
Music City Data
I’ve never spoken in Tennessee. I’ve wanted to visit, but the I’ve only managed to drive through a part of...
2018-05-17
336 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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