.
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
Add some sort of "reset_time" or similar to Index stats DMVs | |
https://feedback.azure.com/d365community/idea/e9e84bf2-64c4-ee11-92bc-000d3a0fb290 | |
Output warning message when altering an indexed view that all indexes (clustered and non-clustered will be dropped) | |
https://feedback.azure.com/d365community/idea/0f1f2993-43b6-ee11-92bc-000d3a033659 | |
Statement execution duration global variable - Similar to @@ROWCOUNT, but instead how long the previous statement took to run | |
https://feedback.azure.com/d365community/idea/884c86b1-9b85-ee11-a81c-000d3ae5ae95 |
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
# Run this script from within the git repo you want to copy data OUT of | |
$copyTo = 'C:\MyTestFolder' | |
$ErrorActionPreference = 'Stop' | |
$currBranch = git branch --show-current | |
$repoRoot = git rev-parse --show-toplevel | |
if ($LASTEXITCODE -gt 0) { return } |
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], c.TestA, c.TestB | |
FROM sys.tables t | |
CROSS APPLY ( | |
SELECT TestA = STRING_AGG(c.[name], '_') | |
, TestB = STRING_AGG(c.[name], ',') | |
FROM sys.columns c | |
WHERE c.[object_id] = t.[object_id] | |
) c | |
WHERE t.is_ms_shipped = 1 | |
ORDER BY t.[object_id] |
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
# Start SQL Server docker instance | |
function Start-SQLServer { | |
param ( | |
[Parameter()][string]$Tag = 'latest' | |
) | |
$containerName = 'sqlserver' | |
$sa_password = 'yourStrong(!)Password' | |
$container = docker inspect $containerName | ConvertFrom-Json |
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
tts: | |
- platform: google_translate | |
template: | |
- binary_sensor: | |
- name: garage_open_no_motion | |
state: > | |
{{ | |
(is_state('binary_sensor.contact_7_contact', 'on')) | |
and |
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
alias: Garage Door Open Notification | |
description: Send out repeating notifications or announcements that the garage door is left open | |
mode: restart | |
trigger: | |
- platform: state | |
entity_id: | |
- group.garage_motion | |
- binary_sensor.contact_7_contact | |
condition: | |
- condition: state |
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
If you try to add a space to the name in GitHub, it gets trimmed. | |
If you try to add a space to the name in Windows, it gets trimmed. | |
The best option seems to be to add the file via command line with the space in the name, then commit and push. |
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
$string = 'Tables' | |
$result = '','/','*/','**/' | ? {$true} -PV left | | |
% { '','/','/*','/**' } -PV right | | |
% { | |
$glob = "${left}${string}${right}" | |
$stat = Measure-Command { $list = rg --files -g $glob } | |
[pscustomobject]@{ | |
Glob = $glob | |
Count = $list.Count | |
Stat = $stat.Milliseconds |
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
# configuration.yaml | |
template: | |
- sensor: | |
- name: new_entity_id | |
device_class: power | |
unit_of_measurement: W # watts | |
state: "{{ states('sensor.target_entity_id') | default(0, true) | round(2, default=0) }}" | |
# customize.yaml | |
sensor.new_entity_id: |
NewerOlder