Robert Pearl


Blogs

Master SQL Subqueries with This Free Course

By

Want to boost your SQL game? Check out this free course, SQL Subqueries: Real-World...

Removing the REST Endpoint in the Data API Builder

By

The more I work with the Data API Builder (DAB), the more I lean...

T-SQL Tuesday #182: Personal Integrity

By

It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...

Read the latest Blogs

Forums

orphaned users in sys.sysusers

By andreas.kreuzberg

Hi everybody, we got 2 entries in this table [myDatabase].[sys].[sysusers] Is there a possibility...

TDE for multiple databases and severs

By sqlfriend

We are self hosting sql servers, we are not using Azure for sql servers....

Help with parent/child query please

By Mr. Holio

Hi everyone, Trying to get this data to the following format but I can't...

Visit the forum

Question of the Day

Sparse Column Storage

When does a column declared as SPARSE use no storage?

See possible answers