Friend of Redgate 2016
I’m excited to announce that I have been named a Friend of Redgate for 2016. The program targets influential people in their respective...
2016-02-07
588 reads
SQL Server Database File Size and Free Space Revisited
I recently had a comment posted to one of my first articles I wrote way back in 2012 concerning adding a column that detailed the used space as a...
2016-02-06
21 reads
Gartner Magic Quadrant for BI/BA and the Lone Three Leaders
History clearly confirms that good things come in threes. As far as I know this is the first time that...
2016-02-05
511 reads
Power BI Publish to Web for Anonymous Access is Here
Earlier this week on Wednesday the Microsoft Power BI made an incredibly exciting announcement and released Power BI “publish to web”...
2016-02-05
1,941 reads
Copying SSIS packages With DTUTIL
A frequent need when performing a server migration is to copy the SSIS packages from one server to a new...
2016-02-15 (first published: 2016-02-05)
6,498 reads
Using Custom File Delimiters in SSIS
File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field...
2016-02-16 (first published: 2016-02-05)
2,704 reads
Its been a busy start to the year
Its been a busy start to the year at gethynellis.com. I have been involved in a Big Data training courses...
2016-02-05
495 reads
PASS Summit 2016 – call for Speakers…
PASS Summit 2016 is the biggest, largest, highest rated summit in the World for the Microsoft SQL Server & BI professionals,...
2016-02-05
807 reads
Minnesota BI User Group – Powering Up HDInsight with Power BI (December 2015)
On Wednesday, December 16, I presented on this topic at the Minnesota BI User Group. This session is based on...
2016-02-04
561 reads
Positivity
I’m sitting in the classroom of SQL Cruise listening to Tim Ford (b|t) explain mechanisms for monitoring indexes. It’s a...
2016-02-04
557 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