chadbaldwin

------------------------------------------------------------
GO
------------------------------------------------------------
SELECT [CurrentDB] = (SELECT x.recovery_model_desc FROM sys.databases x WHERE [name] = DB_NAME())
------------------------------------------------------------------------------
GO
------------------------------------------------------------------------------
IF OBJECT_ID('tempdb..#tmp_log_track','U') IS NOT NULL DROP TABLE #tmp_log_track; --SELECT * FROM #tmp_log_track
CREATE TABLE #tmp_log_track (
	ID					int				NOT NULL IDENTITY(1,1),

chadbaldwin

{
  "OriginalBase64": "JgB4AQABIJASEhISEjcSEhISEhMRExISEjYSNhITETcRNxE3EzYSNhISEjcRExETERMRExETEhITNhISEjcRNxE3ETcSNhI2EgAE5wABH0kSAAv1AAEgSBEAC/UAASBJEgAL9QABH0kSAAv1AAEgSREAC/UAASBJEgAL9gABH0gSAAv2AAEgSBIAC/UAASBJEgAL9gABH0kRAAv2AAEgSBIAC/UAASBIEwAL9QABH0kSAAv1AAEgSREAC/UAASBJEgAL9gABH0kRAAv1AAEhSBEAC/YAASBIEgAL9QABIEkRAAv2AAEgSBEAC/YAASBIEwAL9QABH0oRAAv1AAEgSBIAC/UAASBJEgAL9QABH0kSAAv1AAEgSBEAC/YAASBIEwAL9QABH0kSAAv1AAEgSBIAC/UAASBJEgAL9QABH0oRAAv1AAEgSREAC/UAASBJEgAL9QABIEkRAAv1AAEgSREAC/UAASFIEgAL9QABH0oRAAv1AAEhSBIADQU=",
  "RawMessage": [
    38, 0, 120, 1, 0, 1, 32, 144, 18, 18, 18, 18, 18, 55, 18, 18, 18, 18, 18, 19, 17, 19, 18, 18, 18, 54,
    18, 54, 18, 19, 17, 55, 17, 55, 17, 55, 19, 54, 18, 54, 18, 18, 18, 55, 17, 19, 17, 19, 17, 19, 17, 19,
    17, 19, 18, 18, 19, 54, 18, 18, 18, 55, 17, 55, 17, 55, 17, 55, 18, 54, 18, 54, 18, 0, 4, 231, 0, 1, 31,
    73, 18, 0, 11, 245, 0, 1, 32, 72, 17, 0, 11, 245, 0, 1, 32, 73, 18, 0, 11, 245, 0, 1, 31, 73, 18, 0, 11,
    245, 0, 1, 32, 73, 17, 0, 11, 245, 0

chadbaldwin

$base64 = 'JgB4AQABIJASEhISEjcSEhISEhMRExISEjYSNhITETcRNxE3EzYSNhISEjcRExETERMRExETEhITNhISEjcRNxE3ETcSNhI2EgAE5wABH0kSAAv1AAEgSBEAC/UAASBJEgAL9QABH0kSAAv1AAEgSREAC/UAASBJEgAL9gABH0gSAAv2AAEgSBIAC/UAASBJEgAL9gABH0kRAAv2AAEgSBIAC/UAASBIEwAL9QABH0kSAAv1AAEgSREAC/UAASBJEgAL9gABH0kRAAv1AAEhSBEAC/YAASBIEgAL9QABIEkRAAv2AAEgSBEAC/YAASBIEwAL9QABH0oRAAv1AAEgSBIAC/UAASBJEgAL9QABH0kSAAv1AAEgSBEAC/YAASBIEwAL9QABH0kSAAv1AAEgSBIAC/UAASBJEgAL9QABH0oRAAv1AAEgSREAC/UAASBJEgAL9QABIEkRAAv1AAEgSREAC/UAASFIEgAL9QABH0oRAAv1AAEhSBIADQU='

$output = [pscustomobject]@{
    OriginalBase64 = $base64
    RawMessage = [System.Convert]::FromBase64String($base64)
    MessageType = $null
    RepeatCount = $null
    MessageLength = $null
    InitialPulse = $null
    NECMessage = [uint]::MinValue # 4 byte int to store the 4 NEC message sections

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

    <# Docs:
       https://hub.docker.com/_/microsoft-mssql-server
       https://learn.microsoft.com/en-us/sql/linux/sql-server-linux-configure-environment-variables
    #>

    # Start SQL Server docker instance
    Write-Verbose 'Creating function: Start-SQLServer'
    function Start-SQLServer {
        [CmdletBinding()]
        param (

chadbaldwin

.