Attendee Questions from My #24HoP Presentation
I want to once again thank everyone who attended my 24 Hours of PASS session last week. I especially appreciate...
2016-06-02
799 reads
Showplan comparison
A new functionality in SSSM 2016 is the ability to compare two execution plans. In one of the execution plans...
2016-06-02
170 reads
Broadening horizons: from DBA to Data Science #1
As an IT professional we are used to spending a lot of time learning about new technologies or how we...
2016-06-09 (first published: 2016-06-02)
4,865 reads
SQL Server 2016 available today
In case you haven't heard, SQL server 2016 is generally available today! If you haven't try it out, you should...
2016-06-02
855 reads
Another Recursive CTE–Doing Math
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2016-06-01
530 reads
SQL Server 2016 is here!
Today is the day: SQL Server 2016 is available for download! You can download all the versions (enterprise, standard, web,...
2016-06-01
976 reads
SQL Server 2016 general availability and Feature-Support // allgemeine Verfügbarkeit und Feature-Support
(DE)
Es ist soweit: Der neue SQL Server, in meinen Augen das beste Release seit vielen, wenn nicht gar überhaupt,...
2016-06-01
553 reads
PowerShell : Script Method Error -Method invocation failed because [Microsoft.SqlServer.Management.Smo.ServerRole] does not contain a method named ‘Script’.
I was working on generating scripts for logins, users and server roles and I could able to to generate scripts...
2016-06-01
630 reads
Higher Education Retention Analytics using Power BI
Partnering with Stetson University, I am happy to share the first of many Power BI Higher Education Analytics solutions. This...
2016-06-06 (first published: 2016-06-01)
2,380 reads
Power BI Custom Visuals Class (Module 01 – Custom Visuals Introduction)
Welcome to an exciting new FREE class that I am launching today! Over the next year (that’s right year!) I...
2016-06-01
2,255 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