ssh-keygen -t ed25519 -b 4096
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
req.session_id AS [session], | |
ses.program_name AS [program], | |
sqltext.TEXT AS [query], | |
DB_NAME(req.database_id) AS [database], | |
req.status, | |
wg.name AS [resource_group], | |
req.command, | |
CONVERT(varchar(10), (req.cpu_time / 86400000)) + ':' + | |
CONVERT(varchar(10), ((req.cpu_time % 86400000) / 3600000)) + ':' + |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Elastic Agent Jobs | |
-- https://sqlkitty.com/elastic-jobs-azure-sql-db/ | |
-- Add target group | |
EXEC jobs.sp_add_target_group 'AzureSQLDBs'; | |
-- Add single database (or server/elastic pool) to target group | |
EXEC jobs.sp_add_target_group_member | |
@target_group_name = 'AzureSQLDBs', | |
@target_type = 'SqlDatabase', |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT TOP 100 | |
t.NAME AS [TableName], | |
SCHEMA_NAME(t.schema_id) AS [SchemaName], | |
MAX([data_compression_desc]) AS [Compression], | |
MAX(p.rows) AS [RowCounts], | |
SUM(a.total_pages) AS [TotalPages], | |
SUM(a.used_pages) AS [UsedPages], | |
SUM(a.data_pages) AS [DataPages], | |
(SUM(a.total_pages) * 8) / 1024 AS [TotalSpaceMB], | |
(SUM(a.used_pages) * 8) / 1024 AS [UsedSpaceMB], |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
SELECT | |
[System.State], | |
[System.Id], | |
[System.Title], | |
[System.IterationLevel2], | |
[Microsoft.VSTS.Common.ClosedDate] | |
FROM workitemLinks | |
WHERE | |
( | |
[Source].[System.TeamProject] = @project |
⚠️ Recommends support request⚠️
No support request
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?xml version="1.0" encoding="utf-8"?> | |
<packages> | |
<package id="7zip.install" /> | |
<package id="adobereader" /> | |
<package id="azure-data-studio" /> | |
<package id="chocolatey" /> | |
<package id="chocolatey-compatibility.extension" /> | |
<package id="chocolatey-core.extension" /> | |
<package id="chocolatey-dotnetfx.extension" /> | |
<package id="chocolateygui" /> |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
/* | |
CREATE TABLE [dbo].[test_jsonmerge]( | |
[id] [int] NOT NULL, | |
[people_id] [varchar](50) NOT NULL, | |
[last_name] [varchar](50) NULL, | |
[sms_status] [varchar](50) NULL, | |
CONSTRAINT [PK_test_jsonmerge] PRIMARY KEY CLUSTERED | |
( | |
[id] ASC, | |
[people_id] ASC |
- Uncheck table from sync source.
- Confirm that all resources are automatically removed via above step:
-- github.com/microsoft/sql-server-samples/blob/master/samples/features/sql-data-sync/clean_up_data_sync_objects.sql
NewerOlder