January 2014 S3OLV and Tabular Models
This is really late notice. We had some extenuating circumstances this month and then a last minute cancellation. Now that...
2014-01-09
659 reads
Powershell in a Month – Day 8 Objects: data by another name
This is part of my Powershell Challenge, to learn more about PowerShell (PoSh) using the Learn Windows Powershell 3 in a Month...
2014-01-09
1,203 reads
Work Ethic and Family – A Tribute to My Parents
A tribute is an expression of gratitude or praise. A couple of years ago, I started a series about individuals...
2014-01-09
667 reads
Breaking Complex Data into Visualizations that Tell a Story
How much do you enjoy reading pages and pages of detailed report data? A large amount of information presented in...
2014-01-16 (first published: 2014-01-09)
3,057 reads
Free Online SQL Server Training for the Week of January 12, 2013
If you’re a training provider and I’ve missed you, please drop me a line at brian {dot} kelley {at} sqlpass...
2014-01-09
738 reads
Business Intelligence/Data Warehouse Assessment
When I am tasked to do a business intelligence or data warehouse assessment, the steps I take to do that...
2014-01-09
2,049 reads
Shutting down multiple servers with Powershell
I’ve recently helped a company move their infrastructure to a new data centre. Part of this involved shutting down a...
2014-01-09
559 reads
Lemonade and Life
I’ve got a torn ACL. I found out yesterday at a visit with a surgeon that gave me the results...
2014-01-09
824 reads
Two-Factor Authentication
Something you have and something you know – that’s the heart of two-factor, sometimes called multi-factor, authentication. RSA was for years...
2014-01-15 (first published: 2014-01-09)
6,366 reads
Laying The Ground For A Successful Reporting Project
Building a reporting system from the ground up is a daunting task. Such a big project usually involves intricate resource...
2014-01-14 (first published: 2014-01-09)
3,156 reads
Blogs
Announcements from the Microsoft Fabric Community Conference — Barcelona 2026
By James Serra
Microsoft shared a broad set of Fabric, Power BI, and SQL updates at FabCon...
Au Revoir for now
By Steve Jones
No, I’m not quitting or retiring. Just going on vacation, but I leave tonight...
Forums
Let's Talk Certifications
Comments posted to this topic are about the item Let's Talk Certifications, which is...
Force join by longest possible choice
Title pretty much says it. I want to join to a table that has...
Building a SQL Server Fleet Audit That Leadership Actually Reads
Comments posted to this topic are about the item Building a SQL Server Fleet...
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