Cláudio Silva

I work as Data Platform Architect.
I love performance tuning and I'm also a PowerShell lover who automates any process that needs to be done more than a couple of times.
I contribute to open-source PowerShell modules such as dbatools and dbachecks.

Blogs

7 Best Online Advanced SQL Training Courses to Learn in 2024 and Beyond

By

The world runs on data, and SQL is the key to unlocking its secrets....

Manually Updating Redgate Monitor/SQL Monitor Patch Info

By

This post looks at updating the patch information for SQL Monitor/Redgate Monitor without using...

Bringing the Redgate Seminar to Brisbane

By

We’ve been on a Redgate tour this year, running lots of events to interest,...

Read the latest Blogs

Forums

extracting cloud based netsuite data from the cloud in ssis

By stan

Hi we are going to need to extract netsuite data from the cloud.  This...

SQL Server Always

By ptotham

  We have a Windows Server 2022 Failover Cluster with 3 nodes SQL Server...

SSMA - SQL Server Migration Assistant for Oracle question.

By Fletch

Hello SQL Server Experts. Apologies if in the wrong place, was not sure which...

Visit the forum

Question of the Day

Default Objects in Clones

On SQL Server 2022, I do this:

USE model
GO
CREATE TABLE dbo.DBALog
(logdate DATETIME2(3), logmsg VARCHAR(2000))
GO
I then create a new database:
CREATE DATABASE INVENTORY
GO
I install a new database application in here with multiple tables, views, etc. I do not run any queries. I then decide to run this code:
DBCC CLONEDATABASE(INVENTORY, Inventory_clone);
GO
What happens?

See possible answers