Changing the SQL Data Masker Connection Target
This post will explain how to change the connection in your masking set when using SQL Data Masker from Redgate. I’m writing this more for myself than anyone else....
2019-09-11
47 reads
Blog Posts
Gatekeeping and the lack of diversity in the workplace
Recently I have become more vocal on Twitter and on my personal blog about my social activism. For the record, I have been an activist for LGBTQIA+ rights since...
2019-09-11
118 reads
Restoring an Expired Certificate–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers. One common task that you might need to...
2019-09-11 (first published: 2019-09-02)
305 reads
SQL Server Wishlist
This month for T-SQL Tuesday Kevin Chant asks us what our fantasy SQL feature would be. https://www.kevinrchant.com/2019/09/03/t-sql-tuesday-118-your-fantasy-sql-feature/ I think it’s appropriate to give a shout-out to Microsoft at this...
2019-09-11
90 reads
SQLSATDenver PreCon – Kubernetes Zero to Hero – Installation, Configuration, and Application Deployment!
Pre-conference Workshop at SQLSaturday Denver I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Denver on October 11th 2019! This one...
2019-09-11
49 reads
Weekly reading #25
It has been a long time since the last weekly reading post. We have been in Shanghai and Bangalore during the time. We attended in #DPS10 in Bangalore –...
2019-09-11
6 reads
Weekly reading #25
It has been a long time since the last weekly reading post. We have been in Shanghai and Bangalore during the time. We attended in #DPS10 in Bangalore –...
2019-09-11
29 reads
Workshop – Kubernetes Zero to Hero at SQL Saturday Denver!
Pre-conference Workshop at SQLSaturday Denver
I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Denver on October 11th 2019! This one won’t...
2019-09-11
17 reads
Workshop – Kubernetes Zero to Hero at SQL Saturday Denver!
Pre-conference Workshop at SQLSaturday Denver I’m proud to announce that I will be be presenting an all day pre-conference workshop at SQL Saturday Denver on October 11th 2019! This one...
2019-09-11
12 reads
Tracking Who Last Changed a Row
This post is a response to this month's T-SQL Tuesday #118 prompt by Kevin Chant. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database and professional...
2019-09-10
20 reads
Blogs
PostgreSQL Support in the Data API Builder
By Steve Jones
Next week I’m at VS Live in San Diego (register and join me) and...
Ten Years of PowerShell
Ten years ago today, I filmed a Pluralsight Play by Play on open source...
T-SQL Tuesday #202: 100 Hours
By Steve Jones
It’s time for T-SQL Tuesday again and this is a great prompt to start...
Forums
Stored Procedures for Server-Level Object and Column Search
Comments posted to this topic are about the item Stored Procedures for Server-Level Object...
Databricks Genie Spaces for SQL Analysts: Natural Language Querying Without Leaving Your Data Platform
Comments posted to this topic are about the item Databricks Genie Spaces for SQL...
The Costs of Multiple Platforms
Comments posted to this topic are about the item The Costs of Multiple Platforms
Question of the Day
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.COMIf 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)See possible answers