MarkPryceMaherMSFT

/*
This is very rough, it doesn't work for ints/bits/etc only varchars

This does not work if there are schema bound views

*/
select 'alter table ' + s.name + '.' + object_name(c.object_id) + ' ALTER COLUMN ' + c.name + ' ' + ttt.name + '(' + convert(varchar,c.max_length) + ');',
c.max_length , c.*, tt.*, s.* from sys.columns  c
inner join sys.tables tt on tt.object_id = c.object_id 
inner join sys.schemas s on s.schema_id = tt.schema_id

MarkPryceMaherMSFT

MarkPryceMaherMSFT

{
"KeyColumns": [ "_id_" ],
"SchemaDefinition": {
             "Columns": [
                         {
                         "Name": "id",
                         "DataType": "Int32"
                         },
                         {
                         "Name": "Timestamp",

MarkPryceMaherMSFT

import json 
import notebookutils 
import sempy.fabric as fabric 
from sempy.fabric.exceptions import FabricHTTPException, WorkspaceNotFoundException 

def pad_or_truncate_string(input_string, length, pad_char=' '):
    # Truncate if the string is longer than the specified length
    if len(input_string) > length:
        return input_string[:length]
    # Pad if the string is shorter than the specified length

MarkPryceMaherMSFT

create proc CreateStats @table varchar(128) as
begin


	declare   @create_type    tinyint -- 1 default, 2 Fullscan, 3 Sample
	declare  @sample_pct     tinyint


	IF @create_type IS NULL

MarkPryceMaherMSFT

 -- Is it a lakehouse or warehouse
 SELECT db_name() as db_name, DATABASEPROPERTYEX(db_name(), 'Edition') as [Type]

-- Whats the workspace id?
 SELECT DATABASEPROPERTYEX('master', 'workspaceid') AS workspaceid 
 
 -- What is the artifact id?
SELECT DATABASEPROPERTYEX(db_name(), 'ArtifactId') AS ArtifactId 

MarkPryceMaherMSFT

// use when you have workspace monitoring enabled

// when were tables last updated
MirroredDatabaseTableExecutionLogs
| summarize max(Timestamp), sum(ProcessedRows) by SourceSchemaName, SourceTableName

MarkPryceMaherMSFT

DECLARE @command varchar(8000) 
declare @i int =1;
declare @d int =0;
select @d = max(database_id) from sys.databases;
declare @dbname nvarchar(128);
set @command = '';
while(@i < @d)
begin
	set @dbname  = '';
	select @dbname = name from sys.databases where database_id = @i

MarkPryceMaherMSFT

  SELECT db_name(), DATABASEPROPERTYEX(db_name(), 'Edition')

MarkPryceMaherMSFT

-- Create test table
create table datetest (d varchar(50), dt DATETIME2(6));

insert into datetest SELECT 'Central European Standard Time', CONVERT(DATETIME2(6), '2022-03-27T01:01:00', 126)
AT TIME ZONE 'Central European Standard Time';

insert into datetest SELECT 'Pacific Standard Time' , CONVERT(DATETIME2(6), '2022-03-27T01:01:00', 126)
AT TIME ZONE 'Pacific Standard Time';

select d as TimeZone, dt as DateTime_without_TimeZone,