SELECT 
      database_name = DB_NAME(database_id)
    , log_size_mb = CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
    , row_size_mb = CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2))
    , total_size_mb = CAST(SUM(size) * 8. / 1024 AS DECIMAL(8,2))
FROM sys.master_files WITH(NOWAIT)
WHERE database_id = DB_ID() -- for current db 
GROUP BY database_id

Editar as configurações do GRUB e substituir os parâmetros do Kernel por

quiet splash video=LVDS-1:d

1. Instalar através do Nuget Package o pacote Microsoft.EntityFrameworkCore.Tools
2. Instalar o provedor de acesso
   1. Microsoft.EntityFrameworkCore.SqlServer
   2. Add-Migration Inicial
      1. Inicial é o nome dado ao Migration, sendo esse o inicial, os Migrations devem ser nomeados.
   3. Update-Database

1. Add Microsoft.AspNetCore.Mvc.Razor.RuntimeCompilation NuGet package to the project
2. Add the following in Startup.cs:services.AddControllersWithViews().AddRazorRuntimeCompilation();

Here’s the full explanation for the curious…

Bloco nomeado

DO $$ 
	<<first_block>>
DECLARE
  film_count integer := 0;
BEGIN
   -- get the number of films
   SELECT COUNT(*) 
   INTO film_count
   FROM "Lancamento";
   -- display a message
   RAISE NOTICE 'The number of films is %', film_count;
END first_block $$;

Bloco anonimo

DO $$ 
DECLARE
  film_count INTEGER := 0;
BEGIN
   -- get the number of films
   SELECT COUNT(*) INTO film_count FROM "Lancamento";
   -- display a message
   RAISE NOTICE 'The number of films is %', film_count;
END
$$;

DECLARE @Formatos TABLE(
	Codigo INT,
	Formato VARCHAR(255)
)

DECLARE @Count INT = 0

WHILE @Count < 200
BEGIN
		BEGIN TRY
			INSERT INTO @Formatos VALUES(@Count,convert(varchar(50),getdate(),@Count))
		END TRY  
		BEGIN CATCH  
     
		END CATCH
		SET @Count = @Count + 1
END

SELECT * FROM @Formatos

USE [master];

DECLARE @kill varchar(MAX) = '';

SELECT
		@kill = @kill + 'kill ' + CONVERT(varchar(5), session_id) + ';'  
FROM
		sys.dm_exec_sessions
WHERE
		database_id  = db_id('BANCO_DE_DADOS')

EXEC(@kill);

CREATE TABLE #sp_who2
(
	SPID INT,Status VARCHAR(255),
	Login  VARCHAR(255),HostName  VARCHAR(255),
	BlkBy  VARCHAR(255),DBName  VARCHAR(255),
	Command VARCHAR(255),CPUTime INT,
	DiskIO INT,LastBatch VARCHAR(255),
	ProgramName VARCHAR(255),SPID2 INT,
	REQUESTID INT
)

INSERT INTO #sp_who2 EXEC sp_who2

SELECT
		*
FROM
		#sp_who2
WHERE
		DBName <> 'master'
		AND DBName = 'BANCO_DE_DADOS'
		AND ProgramName <> 'Microsoft SQL Server Management Studio - Query'
ORDER BY
		DBName ASC

DROP TABLE #sp_who2

npx create-react-app alga-stock –template typescript