It’s a small world
As I write this we are packing to leave for Disney World, where my family and I will spend close...
2016-10-26
374 reads
Sending Trevor love…
As some of you may be aware – fellow SQL family member, PASS Director, SQL Server MVP, founder of SQL Cruise...
2016-10-26
388 reads
PASS Summit 2016–Tuesday
For the first day at the Summit this year, I spent half my time in a Pre-Conference session with Idera...
2016-10-25
477 reads
Columnstore Indexes – part 89 (“Memory-Optimised Columnstore Limitations 2016”)
Continuation from the previous 88 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
I would like to dedicate this blog...
2016-10-25
527 reads
Convert User Friendly Retention to DateTime value with PowerShell
I think the title is fairly descriptive so let me put a little context around it for you. In my...
2016-10-25
781 reads
Getting dbatools in Powershell
I had the chance to watch dbatools in action recently at SQL Saturday Cambridge. I watched a presentation from Chrissy...
2016-10-25
1,258 reads
Convert User Friendly Retention to DateTime value with PowerShell
I think the title is fairly descriptive so let me put a little context around it for you. In my...
2016-10-25
295 reads
Azure App Service Companion for iOS
This has absolutely nothing to do with SQL Server, it actually has nothing to do with data but I felt...
2016-10-25
481 reads
Using TRY..CATCH in SQL Prompt
I learned something new recently about SQL Prompt. I was working on documenting and experimenting with snippets and found a...
2016-10-24
1,388 reads
PowerShell : CSV – Disk Space Report – Excel
Abstract
Monitoring disk space utilization of server(s) is a critical and important job for any administrator. Keeping things organized might improve...
2016-10-24
957 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