Book review – Extending SSIS with .NET Scripting
Recently I got my hands on a copy of Extending SSIS with .NET Scripting, written by SQL Server MVP Joost...
2016-01-29 (first published: 2016-01-21)
2,865 reads
Counting Your VLFs, or, Temp Tables Inside IF...ELSE Blocks
There are many many blog posts out there about Virtual Log Files (VLFs) - one of the absolute best is "8...
2016-01-21
873 reads
Return of the .NET - NYC
Thought I would share a note that I received from Nick Landry, Sr. Technical Evangelist for NY Metro & NJ, about...
2016-01-21
1,253 reads
What is RapidMiner
RapidMiner Overview
If you are searching for a data mining solution be sure to look into RapidMiner. RapidMiner is an open...
2016-01-21
571 reads
Transaction Logging & Recovery (part 3)
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server:...
2016-01-20
837 reads
Power BI and Google Analytics
One of the more underused features of Power BI is the Google Analytics data source. Working closely with marketers and...
2016-01-20
1,316 reads
Installing SQL Server 2016 Community Technology Preview
This post is designed to explain the installation steps of some of the new features in 2016 and just how...
2016-01-20
775 reads
Advent of Code–Day 2
I’ve continued working along, and while I found Day 2 to be straightforward in Python and PowerShell, I thought it...
2016-01-20
627 reads
HA/DR for Azure SQL Database
Azure SQL Database is a relational database-as-a-service in the cloud. It uses a special version of Microsoft SQL Server as...
2016-01-20
970 reads
Transaction Logging & Recovery (part 3)
… Continuation of some notes regarding the excellent content by Paul Randal in *Pluralsight: SQL Server: Logging, Recovery, and the Transaction...
2016-01-20
417 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