chadbaldwin

------------------------------------------------------------------------------
GO
------------------------------------------------------------------------------
DROP VIEW IF EXISTS dbo.vw_TableSize_Snapshots;
GO
CREATE OR ALTER VIEW dbo.vw_TableSize_Snapshots
	WITH SCHEMABINDING
AS
SELECT InstanceID, DatabaseID, SnapshotDate, ObjectCount = COUNT_BIG(*)
FROM dbo.TableSize

chadbaldwin

Odd (and inconsistent) behaviour with datetime/datetime2 comparisons

Test results for SQL Server feedback submission:

https://feedback.azure.com/d365community/idea/2b294fcf-5f55-ef11-b4ad-000d3add4ccc

---

Tested against all available compat levels for docker tags:

chadbaldwin

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

chadbaldwin

# 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 }

chadbaldwin

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]

chadbaldwin

# 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

chadbaldwin

.

chadbaldwin

tts:
  - platform: google_translate

template:
  - binary_sensor:
      - name: garage_open_no_motion
        state: >
          {{
            (is_state('binary_sensor.contact_7_contact', 'on'))
            and

chadbaldwin

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

chadbaldwin

​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.