TDD for SQL Server using tSQLt course certificates now available
I have been asked a few times now for course completion certificates so I have decided to give out certificates to anyone who pays for a plan and sends...
2018-07-18
22 reads
Blog Posts
T-SQL Tuesday #104 – My Undercover Toolbox favourites
This months T-SQL Tuesday is being hosted by Bert Wagner , you can find the invitation for this months topic here.
Bert...
2018-07-18 (first published: 2018-07-10)
2,715 reads
Working Hard in Baton Rouge
I’m heading back to Baton Rouge for SQL Saturday #749 this August. This is one of the largest SQL Saturdays...
2018-07-18
419 reads
Building Dynamic Table-Driven Queries
This post is a response to this month’s T-SQL Tuesday #104 prompt by me! T-SQL Tuesday is a way for...
2018-07-17 (first published: 2018-07-10)
3,553 reads
New Logo Revealed
I’ve been pondering the creation of a logo for quite some time and I finally decided to go ahead with...
2018-07-17
227 reads
Power BI Custom Visuals Class (Module 110 – Icon Map)
In this module you will learn how to use the Icon Map. The Icon Map allows you to display your...
2018-07-17 (first published: 2018-07-09)
2,401 reads
Power BI World Tour Is Coming to Charlotte
If you haven’t heard, Power BI is doing a world tour, eight cities in four months and Charlotte, NC is...
2018-07-17
254 reads
PowerBI: Implement a What If parameter
Our Guinea Pig DashboardPowerBI is focused on creating interactive, analytical reports, from a lot of different data sources and with...
2018-07-17
170 reads
SQL Server Audit Recipe – xp_cmdshell
This article assumes you already have a basic understanding of SQL Server Audit, but if not, use this link to catch...
2018-07-17
202 reads
SQLSaturday Baton Rouge at LSU on August 11
We're a little under a month away from #SQLSatBR!We need VOLUNTEERS.Registration is required!We still have tables of all sizes available for sponsors!Our 10th annual SQLSaturday features an 14-track lineup...
2018-07-17
16 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