Steve Jones

Is the Schema Still Needed?

Do you know what the schema is? In Relational databases, there is the concept of a database and a table, but the schema sits between them. In SQL Server, this is known as the owner. But do we really need this additional layer? Has it ever caused you problems? Has it outlived its usefulness?

2003-05-21

5,210 reads

Blogs

Backup your SQL instances configurations to GIT with dbatools – Part 2 – Add parallelism

By

We have seen how we can export and save the results to a folder...

Data Visualization, Context, and Domain Expertise

By

I recently posted a graph to twitter and asked people to explain it. Let’s...

Approaches to running Databricks ETL code from Azure ADF

By

Databricks is fantastic, but there is a small issue with how people use it....

Read the latest Blogs

Forums

Worker Threads Per Session

By alex.sqldba

Morning All, Is it possible to determine how many threads are spawned by a...

Is it acceptable to use the presence of a value in a NULLable column as a flag?

By edwardwill

I have a stored procedure that processes rows in a table. The stored procedure...

Invalid object name OPENJSON

By BOR15K

I have an Express edition of SQL 2019 Microsoft SQL Server 2019 (RTM-GDR) (KB4517790)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Minus Query

See possible answers