SQL Guatemala

New Youtube Channel

Last year I noticed I was blogging way less than I should, in part because of new projects: work, personal stuff, local community activities, university projects... you name it.As...

2020-01-31

22 reads

T-SQL Basics: using OUTPUT

You are working on a database development project, and you need to obtain the records before/after an INSERT, DELETE, UPGRADE or MERGE Statement to present it to the user...

2020-01-09 (first published: )

997 reads

SQL Engine basics: Caching data

SQL Server engine does an excellent job to optimize query performance and it has different methods to achieve this goal, one of these methods is the data caching.Data caching...

2019-07-16 (first published: )

930 reads

Blogs

Reviewing 2019 Career Goals

By

According to this post, I rate 2019 as a Failure. Of the books I...

ASF 029: Tomaz Kastrun interview

By

Introduction Tomaž Kastrun is BI & DEV developer, data analyst & data science. With...

Schema Filtering in SQL Prompt

By

I love SQL Prompt, and I’m regularly impressed by the enhancements our teams continue...

Read the latest Blogs

Forums

Automatic Redaction of PII

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Automatic Redaction of PII

Find Strings Containing Hex Range

By phobia42

I have a table with a varchar field.  It contains a number of characters...

How to implement row last access date column

By xr280xr

I'm creating a table to store serialized shopping cart data associated with a user...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers