Slides from 2016 Techno Security & Mobile Forensics Conference
I’ve completed both of my presentations at the 2016 Techno Security and Forensics Investigation Conference (#technosecurity). If you were able...
2016-06-07
525 reads
Sights that just scream, “No!”
I’m at a conference, specifically a security conference. So I looked at the available WiFi connections. Among the conference and hotel specific...
2016-06-07
456 reads
Power BI Custom Visuals Class (Module 02 – Enlighten Aquarium)
In this module you will learn how to use the Enlighten Aquarium Power BI Custom Visual. While it might not...
2016-06-07
1,849 reads
Incomp…
This is about analytics.
This is about day to day life.
This is also about how the things should not being done.
Incomp…...
2016-06-07
562 reads
InsideSQL–The Deep Dive
There’s a new conference in London next week, the InsideSQL conference on June 14th. It’s at the CodeNode venue, near...
2016-06-07
485 reads
AG Worker Thread Blocked by Log Backup
We have an internal monitoring query that checks for system threads that are blocked. Recently, we received an alert email...
2016-06-15 (first published: 2016-06-06)
2,132 reads
PowerShell – Install PowerShell
Recently got a question regarding PowerShell installation hence this post took an existence.
How to Install PowerShell various versions
http://technet.microsoft.com/en-us/library/hh847837.aspx
http://social.technet.microsoft.com/wiki/contents/articles/21016.how-to-install-windows-powershell-4-0.aspx
Can we have...
2016-06-06
658 reads
Painting with PowerShell: SQL Server Administration
This blog post is just a quick follow from my presentation last week for the SQL PASS PowerShell Virtual Chapter.
Here...
2016-06-06
463 reads
SQLSaturday Iowa City is this weekend!
If you’re within driving distance of Iowa City, IA, I’d love to see you at SQLSaturday Iowa City this weekend!...
2016-06-06
439 reads
Monday Morning SQL Break – June 6, 2016
It’s Monday time for this week’s Monday Morning SQL Break. A chance to catch up on links I’ve shared and...
2016-06-06
423 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