Azure SQL - Backup to URL (SQL on Azure VM to Azure Storage Account) ❕This article has not been completed yet. However, it may already contain helpful Information and therefore it has been published at this stage Info: This documentation shows the implementation using
Automation How to Execute a Stored Procedure in MS SQL Using PowerShell This article has not been completed yet. However, it may already contain helpful information and therefore it has been published at this stage. Generating some Template Tables..... CREATE TABLE Product (ProductID INT, ProductName VARCHAR(100) ) GO CREATE TABLE ProductDescription (ProductID INT, ProductDescription VARCHAR(800)
Microsoft SQL How to list top tables (disk usage) - SQL SQL - Way: -- Use sys.tables, sys.indexes, sys.partitions, sys.allocation_units and sys.schemas to display the line number, and also the size of tables select sch.name as SchemaName, tab.name as TableName, par.rows as RowCounts, sum(alc.total_
Powershell dbatools -the tiny universal database management solution - PowerShell Definitiondbatools is a free PowerShell module with over 500 SQL Server administration, best practice and migration commands included. You can think of dbatools as a command-line SQL Server Management Studio Minimum RequirementsServer SQL Server 2000 No PowerShell needed on the host for SQL Server-only
Powershell Tiny database backup script - MSSQL Once again an essential MSSQL topic. The backup of a database (in this case an Express version). Since this version is freely available and usable, the customer of course doesn't want to spend money for the backup). But thank god he has the money
