Excel Power Pivot Introduction
What is Power Pivot? It is an add-in, and according to Microsoft: “Power Pivot is a data modeling […]
query
Excel Power Query Data Type Error
Sometimes when you bring in data into the Power Query Editor, you experience data type errors. Here below […]
Excel Power Query Fill Down
Are you using Power Query to import data into Excel and finding that one of your columns is […]
Create a Pivot Table from Multiple Sheets using Power Query
Do you have an Excel workbook (file) that has multiple worksheets of data that you need to combine […]
Power Query Transform Phone Number
Do you need to split a column of imported Excel telephone number data into two columns so that […]
Excel Power Query Introduction
What is Power Query? This is what Microsoft says: “Power Query is a data transformation and data preparation […]
Dapper micro-ORM Introduction
Dapper is an open-source Object Relational Mapper (ORM) for .NET. It was written by the people over at […]
WPF ListBox of Colors
This post is a sample Windows Presentation Foundation (WPF) program of a ListBox that lists all of the […]
C# LINQ Part 2
In this post on LINQ we will work with Mosh Hamedani and his video course on Udemy.com. With […]
SQL Server Access Methods
As Microsoft says: “Generally, there are different methods for accessing the data in each table. If only a […]
SQL Server Multi-Table Queries
This post serves as a series of links to the different kinds of multi-table queries. The Microsoft Press […]
SQL Server Logical Query Example
This post is a continuation of the post called SQL Server Logical Query. It is based on the […]