msornakumar Goto Github PK

azure-purview-excel-tool

Python tool to download Azure Purview search results to Excel.

bism-ssas-tabular-documentation-tool

Creates an Excel Document with the metadata of all objects in a SSAS Tabular Model.

load-complex-xml-to-sql-server

This generic SSIS script code loads any complex XML data into SQL Server Database. The table structure based on the XML structure is created dynamically and the data is loaded. There is an option of making this to work as Framework with Framework tables to store the File details and load the relationship between the tables in the XML File. The script loops through the XML files provided in the path and loads the data into the SQL Server database. All these values are configurable.

sqlserverjsonbeautifier

SQL Server 2016 has the new feature of creating JSON output using FOR JSON clause similar to FOR XML path.The output of the above clause will not be formatted in a readable format.It will be returned as a one single string. To format the JSON , an external application like Visula Studio or Internet Online Formatting tools to be used. The purpose of this function is to format the JSON to a readable format in the SSMS output itself. This function beautifies the JSON and provides the output. This is a CLR Function created using C#.

ssasamodb

SSAS AMO DB is a database version of AMO which helps to view the metadata stored in the SSAS cube. The Metadata will be loaded into a SQL Server database from the SSAS cube using AMO using SSIS package.

ssasquerylogdecoderandanalyzer

The Crisp description for the project will be "CUBE FOR CUBE". This is an end-to-end BI solution for analyzing the Query log created by SSAS Server. The Query Log data is loaded into a dimensional model and a cube is built on top of it for analysis of cube usage.

ssrs-branding-file-editor

A new feature of branding has been introduced for SSRS in SQL Server 2016. This feature is useful for customizing the SSRS Report Manager Portal with Display colors and a logo also can be added to the portal. This Branding consists of a process of zipping and uploading the below 3 files into the SSRS Report Manager portal. 1. Metadata.XML - This file holds the Branding Name , Colors file name and Logo Name (optional) 2. <Colors>.JSON -- This file has the Hex color values for the various elements applicable to the SSRS Report Manager. 3.<LogoFile> -- The logo file to be displayed on the top left corner of the SSRS Report Manager. This file is optional. This tool will be used to edit the Colors.JSON file to apply the colors for each relevant element. This is an excel based macro tool. This tool generate the above files based on the settings in the sheet. Also the colors can be chosen using the cells back color in Color column. For the selected color, the relevant hex code will be written in the colors JSON file. This tool can be used for generating new branding file and edit the existing branding file.

windowsserviceconsole