No MVP Summit for Me
On the corner of my rather messy desk is little recognition item in the image to the right. It’s a...
2012-02-24
857 reads
Blog Posts
Re-blog – February 17 – February 23
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer readers may...
2012-02-24
582 reads
Speaking at the SQL Lunch UK
Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change. Unlike the SQL Lunch that I...
2012-02-24
811 reads
Speaking at the SQL Lunch UK
Yep, that’s correct, the SQL Lunch has expanded to the UK with one slight change. Unlike the SQL Lunch that...
2012-02-24
455 reads
SQL Server - DBA Team FAQ
Developers constantly ask about placing the latest code\feature\process\third party applications onto Production Database Servers.
I’m building an FAQ to supply Developers...
2012-02-24
1,131 reads
SQL Server 2012 (“Denali”): Spatial Features
SQL Server 2012 introduces several significant enhancements to spatial types, such as support for new subtypes of circular arcs, new...
2012-02-24
2,027 reads
A Plea: Have your guidance documentation reviewed
Today one of my auditors sent me her matrix for auditing Microsoft SQL Server. I had seen part of it...
2012-02-23
1,234 reads
A Script A Day - Day 17 - Possible Poor Indexes
Today’s script is one I’ve taken from a job I use to collect possible poor indexes. I’ve tweeked it slightly...
2012-02-23
552 reads
A Script A Day - Day 18 - Viewing System Configuration
Today’s script is something I’ve learned today, it’s cool learning new stuff! When viewing server configurations in the past I’ve...
2012-02-23
567 reads
Linchpin People LLC Announces Two New Partners - Press Release
February 23, 2012 – Today, LINCHPIN PEOPLE, LLC, offering technical advisory, consulting and training services in the Microsoft SQL Server Space,...
2012-02-23
2,482 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