Run!

Code first is great for rapid prototyping but it gets to the point where some traditional OO analysis and database schema design needs to be done.

Baselining is a large topic so you might want to look at third party tools. This may get you started:

https://www.brentozar.com/archive/2006/12/dba-101-using-perfmon-for-sql-performance-tuning/

https://www.sqlservercentral.com/articles/perfmon-using-sql-server-performance-counters

To get a log backup there must have been at least one full backup...

I would be interested to see how you do that. I suspect it would require...

• This reply was modified 7 months, 3 weeks ago by  Ken McKelvey.

This is not possible. You will need a bak...

RTFI

Denies a permission to a principal. Prevents that principal from inheriting the permission through its group or role memberships. DENY takes precedence over all permissions, except that DENY does...

• This reply was modified 8 months ago by  Ken McKelvey.

Maybe:

WITH Lags
AS
(
    SELECT P.Code, X.DataPassaggio, P.idServizio, P.up
        ,LAG(idServizio) OVER (PARTITION BY P.Code, X.DataPassaggio ORDER BY P.DataPassaggio) AS...

• This reply was modified 8 months ago by  Ken McKelvey.

DDL? Test Data? You have enough points to know this.

You did some calculations...

You should explicitly cast the results to the type you want - presumably not float.

It depends!

Your other options are Hierarchyid or nested sets.

https://learn.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sql-server?view=sql-server-ver16

https://www.sqlservercentral.com/articles/hierarchies-on-steroids-1-convert-an-adjacency-list-to-nested-sets

https://www.sqlservercentral.com/articles/hierarchies-on-steroids-2-a-replacement-for-nested-sets-calculations-1

Security can also be done in SQL Server with RLS.

I am not a SSIS expert but with regards to authentication methods:

1. Windows Authentication will be more secure especially if you can use Managed Service Accounts. The downside can...

2. Sign a SP for permissions in another Database.

/* Only works with DML */
USE <main_db, sysname,>;
GO
SET ANSI_NULLS, QUOTED_IDENTIFIER ON;
GO
CREATE OR ALTER PROCEDURE <schema_name, sysname, dbo>.<proc_name, sysname,>
AS
SET NOCOUNT,...

1. Sign a SP for permissions within the same database.

USE <Main DB, sysname,>;
GO
SET ANSI_NULLS, QUOTED_IDENTIFIER ON;
GO
CREATE OR ALTER PROCEDURE <schema_name, sysname, dbo>.<proc_name, sysname,>
AS
SET NOCOUNT, XACT_ABORT ON;

RETURN;
GO

GRANT [rights]...

Further reading:

https://straightforwardsql.com/posts/cross-db-access-with-module-signing/

https://sqlquantumleap.com/2017/12/30/please-please-please-stop-using-impersonation-execute-as/

This is detailed and probably requires you to place a bag of frozen peas on top of your head.

https://www.sommarskog.se/grantperm.html

Also, here are some outline SSMS templates (Ctrl...

• This reply was modified 8 months, 3 weeks ago by  Ken McKelvey.