Research Areas
Author: John A Mahady
2021 August 4
LinkedIn Account of John Mahady
Proc: convert flat table with multivalue columns
Function: return multi-valued string as a table
Proc: ETL to merge industry code book with corporate inventory
Proc: runs in SSIS package to produce a pipe delimited TXT file
Script: Server Diagnostics
My in-house training class on Common Table Expressions
Tools for the IT Professional
Procedure: dynamic analytics of A/R process by operator and date range
NMEDW: Code using a cursor to create HTML output of columns for a clicked table
NMEDW: Code using a Cursor to HTML output foreign key relationship
Sample Linux Shell Script
Sample Profile PowerShell Script
eInvoice Process Flow -Visio
Sample Conversion Design document
Sample Audit File Design document
Virtual Machine Network - PDF
PMP: 47 Processes -
Click on each process to see ITTO
Power BI Screenshot Examples
NMEDW Metadata Explorer
1- SP XML two Files of Fact and Dim Views
2- SP XML List of Columns for each Fact and Dim View
3- SP XML List of linked key columns for Fact and Dim Views
4- SP XML List of unique columns count and location view
5- SP XML List of Descriptions of Fact and Dim Views
6- SP XML List of Column Descriptions for Fact and Dim Views
DOC: SSMS Import Wizard: Import Excel spreadsheet into SQL Server 2014
DOC: ONIX Modernization_Data Stratification Overrides_Knowledge Transfer
vw_DataStratificationEngine_Filtered
sp_Stats_On_EANs_In_A_List
sp_Populate_PRE_with_Current_DSE_and_OvrAgg_Values_DSEF
sp_Isolate_Override_Updates_From_Returned_Spreadsheet_vs_PRE_sent
sp_Merge_OverridesAggregate_with_DSE
sp_Rebuild_OverridesAggregated_table
FUNCTION: tbl_GetBISACdescription123_ID10
FUNCTION: GetBISACdescription123_ID10
VIEW: vw_BISACfilterWithDesc_ID10
VIEW: vw_DataStratificationEngine_For_JDA_Extract
sp_Run_JDA_DataStrat_Extract
Talend Resources
SSAS tutorials
SSIS webpage
SSRS webpage
SSMS tutorials
How to create and configure a linked server in SQL Server Management Studio
TechBrothersIT
FastSqlServer.com -performance and optimizing SQL Server ideas
Excel 2013 PowerPivot Basics - 57 Youtube tutorials
How To Excel At Excel.Com - 45 videos
Computergaga Excel tutorials
R tutorial
SQL Server R Services
UMLet 14.2 - Free UML Tool for Fast UML Diagrams
Quick tutorial
UML 2.0 Tutorials
Microsoft Drivers v4.3.0 for PHP for SQL Server released!
QGIS - Open Source Geographic Information System
JSON webpage
Tableau webpage
All Analytics
Top Business Intelligence Blogs
Power BI webpage
Power BI Desktop Update - August 2017
Solutions Review - BI and Analytics
Data Stories Gallery from PBI Community
DAX Studio
All the secrets of SUMMARIZE
Sql Server sample Database - AdventureWorks2014
Sql Server sample Database - Wide World Importers v1.0
So long AdventureWorks, we’ll miss you! (And hello Wide World Importers!)
U-SQL
U-SQL Language Reference
Sampling data in Data Lake U-SQL for Power BI
Extract Year/Month Value from DateTime Column in U-SQL
Stack Overflow tagged U-SQL questions
PowerShell webpage
XPath Tutorial
XPath Overview
XPath W3 Specification
Examples from XML in a Nutshell
The 10-Minute XPath Tutorial
MSDN:Get Started Developing with XML and download for XML Notepad 2007
XML Notepad 2007 Design
EditiX Lite - Free XML Editor
XML Copy Editor - GNU GPL
Introduction to Active Directory Directory Services Structure in Windows Server 2012
IIS 7.5 Architecture and components (part 1)
IIS 7.5 Architecture and Components (part 2)
IIS 7.5 Architecture and Components (part 3)
The Curse and Blessings of Dynamic SQL
parameter-sniffing-in-sql-server
Database Administrators Stack Exchange is a question and answer site
PMP: Certification Preparation
ASP.NET MVC
Current Work Links
T-SQL
Java and Web Services
Sample JQuery/database intranet site--
pwd needed
PM/BA/IC links
Blockchain
Miami where luxury real estate meets dirty money
Why is Miami America's most vulnerable metropolis to sea-level rise—having yet another beachfront development boom?
Foreign buyers flood US real estate, but buy cheaper homes
Wolf Street | Business, finance, money
Regional Town Events
Peru News Agency
Peru - craigslist
LivinginPeru blog
googled Living in Peru
testboxes