Mailbox Statistics report with Email addresses
Script to collect and export the mailbox properties from Get-Mailbox and Get-MailboxStatistics cmdlets to a CSV file
This script can be extended based...
2016-01-07
686 reads
Advent of Code Day 1, Puzzle A
I have been working my way through the Advent of Code series across the last few weeks. This is a...
2016-01-07
679 reads
SQL Saturday Chicago Precon – SQL Server Infrastructure – March 4
I’m pleased to announce that I’m launching a new all-day precon training session at the next SQL Saturday in Chicago...
2016-01-07
386 reads
MongoDB -Access different databases and Collections
You can use db.getSiblingDB() method to access another database without switching the database.
To List Collections of PP database and query...
2016-01-14 (first published: 2016-01-07)
1,937 reads
Download the Power BI Architecture Diagram
Update: I’ve updated the Power BI architecture diagram! Click here to view version 2!
As a Data Platform Solution Architect for...
2016-01-06
4,615 reads
XenApp/XenDesktop 7.6 FP3 VDA Deployment Issue
During the upgrade to XenApp 7.6 FP3 VDA encountered the following message.
I was wondered on seeing this popup to restart...
2016-01-06
568 reads
T-SQL Tuesday #74 Invitation: Be the Change
Happy New Year and welcome to another T-SQL Tuesday (number 74 to be exact). This time of the year, everyone...
2016-01-08 (first published: 2016-01-06)
2,149 reads
What is SSDT? Part 2 - More Reasons to Bother!
In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked...
2016-01-06
1,211 reads
What is SSDT? Part 2 - More Reasons to Bother!
In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked about the first major category the development ide and...
2016-01-06
5 reads
What is SSDT? Part 2 - More Reasons to Bother!
In part 1 of this series available here I introduced my drawing of what I think SSDT is and talked...
2016-01-06
19 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