Using OUTPUT with a field list.
I recently wrote an article for SQL Server Central about using OUTPUT. In case you aren’t aware OUTPUT is a...
2016-11-30
719 reads
SQL Server & Containers – Part Three
This post follows on from Part Two in which we created a custom docker image. We’ll now look at pushing...
2016-12-14 (first published: 2016-11-30)
2,034 reads
CISL 1.4.1 is released
Just one month later after the 1.4.0 release of CISL, I am here again blogging about the new release 1.4.1...
2016-11-30
651 reads
SQL Server 2016 SP1 – Rocking RELEASE!!!
Last week, I did a presentation titled "SQL Server 2016 SP1 – Rocking RELEASE!!!" to Singapore SQL User Group. The Presentation was...
2016-11-29
855 reads
Rate a Session for GroupBy
One of the things that I struggle with is understanding whether a session at a conference like a SQL Saturday...
2016-11-29
777 reads
Analytics Platform System 2016 Release
Microsoft has a new release for the Analytics Platform System (APS). This appliance update is called APS 2016 and has...
2016-11-29
527 reads
VMware vSphere 6.5 breaks your SQL Server vNUMA settings
VMware’s latest release of the vSphere virtualization suite, version 6.5, changes how they handle vNUMA presentation to a virtual machine,...
2016-12-07 (first published: 2016-11-29)
3,364 reads
Power BI Custom Visuals Class (Module 27 – Synoptic Panel)
In this module you will learn how to use the Synoptic Panel Power BI Custom Visual. The Synoptic Panel is...
2016-12-06 (first published: 2016-11-29)
2,114 reads
Notes from our 3rd Student to IT Pro Seminar
Concurrent with SQLSaturday Orlando we ran our third student seminar. This is our way of giving back to the college...
2016-11-29
697 reads
Announcing Minion CheckDB release date!
Minion CheckDB is the third piece of our free backup and maintenance tools, rounding out the list with Minion Backup...
2016-11-28
1,064 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