James Serra's Blog

Blog Post

Serving layers with a data lake

Data lakes typically have three layers: raw, cleaned, and presentation (also called bronze, silver, and gold if using the medallion architecture popularized by Databricks). I talk about this is...

2023-08-28 (first published: )

323 reads

Blog Post

Data Marketplace

I question I have been getting from customers lately is about a data marketplace. What is it, and what products can I use to build it? A data marketplace,...

2023-04-24 (first published: )

142 reads

Blog Post

New Microsoft Purview features

Microsoft Purview, formally called Azure Purview (see Azure Purview is generally available) has recently released a number of new cool features. I wanted to call out a few of...

2023-02-22 (first published: )

414 reads


A New Word: Ghough


ghough – n. a hollow place in your psyche that can never be filled;...

T-SQL Tuesday: Encryption and Data Protection


I have the honour of hosting this month’s T-SQL Tuesday. In case there’s any...

Parameterize your Databricks notebooks with widgets


Widgets provide a way to parameterize notebooks in Databricks. If you need to call...

Read the latest Blogs


ASCII value of certain column is null

By SQL_Surfer

When ASCII(Column) is null, what does it represent? Is this some kind of special/control...

Need to output table data into multiple CSV files

By Mh-397891

Hello, I created the below script to output 999 rows from SQL Server table...

Changing Database page Verify on a Database in an AG

By John D

I have a database on SQL 2019 in an Availability Group (AG) and I...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers