SQL Nexus
I was lucky enough to be accepted to speak at SQL Nexus in Copenhagen and I attended the event a...
2016-05-12
656 reads
See you Saturday in Houston!
Here’s your friendly neighborhood reminder to get free learnin’ at SQL Saturday Houston this weekend, where we’ll have the MinionWare booth, and sessions...
2016-05-12
522 reads
Use The Correct Data Type
Blog post #5 in support of Tim Ford’s (b|t) #iwanttohelp, #entrylevel. Read about it here.
Saying that you should use the...
2016-05-18 (first published: 2016-05-12)
1,994 reads
Free eBook – Modern Storage Strategies for SQL Server
I’m pleased to announce the general availability of a new free ebook collaboration with James Green from ActualTech Media called...
2016-05-17 (first published: 2016-05-12)
3,757 reads
Comparing the contents of two tables
I’ve been working on tuning a query for the last week and I’ve had to make several changes to the...
2016-05-16 (first published: 2016-05-12)
3,581 reads
PowerShell – SQL Database Refresh -Restore – Multiple Databases
.SYNOPSIS
The purpose of the script is to restore database/s from a database backup. The requirement is to refresh ‘n’ databases.
.DESCRIPTION
The...
2016-05-12
1,764 reads
Find Unused Database Objects in SQL Server
Overview SQL Server, a relational Database management system is mainly used for storing and retrieving data whenever required by its...
2016-05-12
585 reads
Upcoming SQL Saturdays - June 2016
I am speaking at two different SQL Saturdays in June!
--
First up on June 4th is SQL Saturday #517 Philadelphia (#SQLSAT517)...
2016-05-12
629 reads
PowerShell – Backup Specific group of SQL Databases
<#
.SYNOPSIS
The purpose of the script is to initiate backup only for desired group of databases. The requirement is to refresh...
2016-05-11
595 reads
Azure Speed Testing
Have you ever wondered what Azure region would be the fastest to host your applications when those applications are accessed from your...
2016-05-11
1,554 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