Working from home

Davide Mauri yorek

Working from home

Azure SQL Product Manager. Developer at heart with a huge passion for data management and analysis. C# and Python lover.

yorek / centos-set-keyboard

Last active August 29, 2015 14:23

Set keyboard map to Italian in CentOS 6.6

loadkeys it

yorek / gist:77eca81a1ab4e0f51dea

Created April 8, 2015 15:58

Powershell script to add and process a new SSAS Multidimensional partition (mimicking subpartitions usage)

	# Load Assembly
	[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") >$NULL

	# Connect to Tabular SSAS
	$srv = New-Object Microsoft.AnalysisServices.Server
	$srv.connect("localhost")

	# Point to a specific Database
	$db = $srv.Databases.FindByName("MyDatabase");

yorek / add-new-tabular-partition

Last active April 26, 2022 01:42

Powershell script to add and process a new SSAS Tabular partition

	# Load Assembly
	[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") >$NULL

	# Connect to Tabular SSAS
	$srv = New-Object Microsoft.AnalysisServices.Server
	$srv.connect("localhost\TABULAR")

	# Point to a specific Database
	$db = $srv.Databases.FindByName("DatabaseName");

yorek / get-wait-stats

Created August 25, 2014 12:22

Load and shows to top 25 highest wait stats taken in a period of 1 minute

	if (object_id('tempdb..#t1') is not null) drop table #1
	if (object_id('tempdb..#t2') is not null) drop table #2
	go

	select sample_date = sysdatetime(), * into #t1 from sys.dm_os_wait_stats
	waitfor delay '00:00:01'
	select sample_date = sysdatetime(), * into #t2 from sys.dm_os_wait_stats
	go

	select top 25

yorek / get-sql-table-size

Last active August 29, 2015 14:04

Return table (split by index and partition) size and row count

	DECLARE @tableNamePattern SYSNAME = '%'

	SELECT
	t.name,
	p.index_id,
	p.partition_number,
	[rows] = format(p.row_count, '#,0'),
	used_space = format(p.used_page_count * 8 / 1024., '#,0 MB'),
	reserved_space = format(p.reserved_page_count * 8 / 1024., '#,0 MB')
	FROM

yorek / get-ssas-server-info

Created July 9, 2014 11:49

Detects Analysis Services Version and Edition

	[Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices") \| Out-Null

	$serverName = "localhost"
	$server = New-Object Microsoft.AnalysisServices.Server
	$server.Connect($serverName)

	Write-Output ("`nServer: {0}`nEdition: {1}`nBuild: {2}" -f $server.Name, $server.Edition, $server.Version)

yorek / get-sql-supported-collations

Last active August 29, 2015 14:03

Show the list of supported collations in SQL Server

	SELECT
	[name]
	, [CodePage] = COLLATIONPROPERTY([name], 'CodePage')
	, [LCID] = COLLATIONPROPERTY([name], 'LCID')
	, [ComparisonStyle] = COLLATIONPROPERTY([name], 'ComparisonStyle')
	, [Version] = COLLATIONPROPERTY([name], 'Version')
	, [description]
	FROM
	::fn_helpcollations();