A Goal of Speaking at PASS Summit
Everyone has goals or at least they should have goals. As a young professional out of college, I had plenty...
2016-09-26
582 reads
Studying Failures
Over the weekend, I went to the local theater to watch Sully, the movie about the US Airways pilot who...
2016-10-05 (first published: 2016-09-26)
1,321 reads
Nil to Speaker: Improving your PowerPoint skills
As I work on my speaking skills one of my tasks is improve my PowerPoint presentations. To that end I’ve...
2016-09-26
610 reads
Future DBA – Hadoop Big Data 1
In our last blog on Hadoop Big Data we have discussed about Hadoop and its tools/utility to connect to HDFS. on...
2016-09-26
608 reads
SQL SSRS Express Edition Cannot Connect to Azure SQL Databases
This has bit a couple of clients recently, figured I'd put out a PSA.
Express editions of SQL Server Reporting Service,...
2016-10-04 (first published: 2016-09-25)
2,161 reads
PowerShell, Pester and Ola Hallengrens Maintenance Solution
If you are a SQL DBA you will have heard of Ola Hallengrens Maintenance solution If you haven’t go and...
2016-10-04 (first published: 2016-09-24)
3,772 reads
Order by Month Number and Show Month Name
This may feel very
simple to many developers and yes it is, but I saw this request somewhere in community
website.So thought...
2016-09-24
947 reads
11 years of PASS Summit
This is a story of my 11-year association with PASS, and the many ways it helped me grow as a...
2016-09-23
447 reads
Announcing SQLSaturday Portugal Lisbon-Edition 2017
With just 1 week until SQLSaturday Portugal Porto 2016, I am glad to share that we have SQLSaturday Lisbon 2017...
2016-09-23
470 reads
Think Using .. In Code Is A Time Saver? Think Again!
Ok, so what is this 4 part naming convention? It is the way the SQL Server (and other DBs out...
2016-09-23
502 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