Ted Yu

The only limit to our realization of tomorrow will be our doubts of today.

Streamlining Excel to CSV

Get all sheet from Excel to CSV

Converting Excel to CSV with PowerShell PowerShell is a powerful scripting language that allows for automation and task automation on Windows systems. In this article, we will explore a PowerShell...

Posted by Ted on November 14, 2023

Automating M365 License Reporting

Automating Microsoft 365 License Reporting with PowerShell Introduction Managing licenses for users in a Microsoft 365 environment can be a complex task, especially in large organizations. Keepin...

Posted by Ted on November 13, 2023

Refresh PowerBI Datasets

Refresh the Workspace from PBI

Automating Power BI Dataset Refresh with PowerShell Power BI is a powerful business analytics service provided by Microsoft, allowing users to visualize and share insights across their organizatio...

Posted by Ted on November 10, 2023

Export SQL Server Management to Csv

SQL Server to CSV

PowerShell Script for Exporting SQL Server Table Data to CSV Files In everyday data management tasks, exporting data from specific SQL Server tables to CSV files is a common requirement. To simpli...

Posted by Ted on November 9, 2023

Import CSV To SQL

PowerShell Script for Connecting to SQL Server and Importing CSV Data In this article, we’ll explore a PowerShell script designed to connect to a SQL Server database, read data from a CSV file, an...

Posted by Ted on November 8, 2023

Exports PowerBI workplace Summary

PBI Workspace Summary to CSV

Power BI Workspace Summary Export using PowerShell PowerShell is a powerful scripting language that enables automation and management tasks in various environments. In this script, we demonstrate ...

Posted by Ted on November 6, 2023

Power BI Service Data Export Script

PBI Workspace Metadata to CSV

Automating Power BI Service Interaction with PowerShell Introduction This article explores a PowerShell script designed to automate interactions with the Power BI service. The script connects to ...

Posted by Ted on November 3, 2023

The Sum of all Natural Numbers

The Riemann Hypothesis

This is the most reasonable proof I have encountered so far. The result of $1 + 2 + 3 + 4 + 5 + \ldots + \infty$ Proof: (1)···········$assume\ S_{1} = 1 - 1 + 1 - 1 + 1 - ...

Posted by Ted on May 21, 2023

Embracing the Opportunity: A Journey in the Laboratory

The first job in my life

The first job is not just a paycheck; it’s a stepping stone to the dreams. Embracing the Opportunity: A Journey in the Laboratory When the opportunity knocked, I didn’t hesitate to embrace ...

Posted by Ted on October 15, 2013

FEATURED TAGS
Power BI PowerShell SQL Server
ABOUT ME

The Dance of Data, Insight into Tomorrow