Using 3rd party tools. T-SQL Tuesday #119
It’s that time again! Alex Yates (b/t) has asked us to discuss a time in tech when we’ve changed our ... Continue reading
2019-10-11 (first published: 2019-10-08)
463 reads
T-SQL Tuesday #119 – Changing Your Mind
This month Alex Yates (B|T) is hosting T-SQL Tuesday which is a monthly blog party started by Adam Machanic (B|T) and co-ordinated by Steve Jones (B|T) The challenge that...
2019-10-08
88 reads
T-SQL Tuesday: Changing my mind
This month’s T-SQL Tuesday is hosted by my friend across the pond – Alex Yates. Alex has a fantastic topic for us to blog about – he asks us...
2019-10-14 (first published: 2019-10-08)
532 reads
Communicating Effectively at the Workplace
This post is a response to this month’s T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-10 (first published: 2019-10-08)
426 reads
Communicating Effectively at the Workplace
This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-08
16 reads
Communicating Effectively at the Workplace
This post is a response to this month's T-SQL Tuesday #119 prompt by Alex Yates. T-SQL Tuesday is a way for the SQL Server community to share ideas about different database...
2019-10-08
8 reads
SQL Server Admin Best Practices with DMV's at GroupBy
Excited to be presenting at virtual GroupBy Conference for the first time on Thursday, during the North America time slots. I just finished tuning up this old presentation that I've presented...
2019-10-08
60 reads
T-SQL Tuesday #119 - Changing Your Mind
For T-SQL Tuesday this month, Alex Yates (blog | twitter) gives us this challenge:
I would like you to write about something in your IT career that you have changed...
2019-10-08
16 reads
A #DevOps Discussion on Thursday with Abel Wang
I’m hosting a webinar later this week with Abel Wang, one of the talented members of the League of Extraordinary Cloud DevOps Advocates at Microsoft. This Thursday, October 10,...
2019-10-07
53 reads
SQL Injection Mitigation in SQL Server 2019
I’ve been teaching a lot more about SQL Injection lately (including blog posts). I’ve been doing this because, despite this being a 21 year-old problem with well defined solutions,...
2019-10-07
187 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