Register Log in

Reverse Creating the PBIP file from Source Control

Articles tagged Source control

Blogs
in Blogs

Reverse Creating the PBIP file from Source Control

On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to use the PBIP file format to include Power BI...

3 min read
Blogs
in Blogs

4 Rules to follow on Microsoft Fabric Source Control

Power BI and Fabric are implementing source control support. It’s a long-awaited feature for Power BI. However, it’s important to highlight some basic principles which...

4 min read

Temporary Tables in SQL Server

Temporary tables are used by every DB developer, but they're not likely to be too adventurous with their use, or exploit all their advantages. They...

22 min read

PowerShell Desired State Configuration: LCM and Push Management Model

PowerShell's Desired State Configuration (DSC) framework depends on the Local Configuration Manager (LCM) which has a central role in a DSC architecture. It runs on...

13 min read

Database Lifecycle Management for ETL Systems

Few databases are self-contained. They take data from other sources, and publish them to downstream consumers of data. These ETL processes tend to grow in...

32 min read

Database Migrations: Modifying Existing Databases

It should be simple to upgrade a database to a new version. It certainly can be, but if you need to preserve the existing data...

34 min read

Better Ways to Build a Database

The purpose of a database build is simple: prove that what you have in version control can successfully create a working database. And yet many...

40 min read

Using R Machine Learning Script as a Power BI Desktop Data Source

You can develop a Power BI Dashboard that uses an R machine learning script as its data source and custom visuals. Here is a simple...

11 min read

Common Aspects of ASP.NET Code: in Web Forms and MVC

Is it time to abandon the use of Web Forms in favour of controller methods in ASP.NET MVC? As always, the answer is 'it depends',...

12 min read

How to Take an Asp.Net MVC Web Site Down for Maintenance

Keeping a customer facing web site up and performing well is a challenge, especially when you are still adding new features. While providing an "always...

14 min read

Chet Ramey: Geek of the Week

The BASH shell is the most popular UNIX command-line scriptable shell. It became the inspiration for PowerShell. As with so many standard components of the...

10 min read

Using Scaffolding to Create MVC Applications with Visual Studio

Scaffolding is a great way of kick-starting model-view-controller (MVC) framework development. Visual Studio's MVC Scaffolding uses templates to generate the routine code that is common...

14 min read

What’s New in C# 6

The C# language itself has changed little in version 6, the main importance of the release being the introduction of the Roslyn .NET Compiler Platform....

14 min read

Tips and Tricks about Razor Partial Views

Partial views in ASP.NET MVC allow you to reuse and customise components to act like user controls. They consist of both code and markup. They...

12 min read

Documenting Your PowerShell Binary Cmdlets

Whereas it is easy to provide inline documentation for a normal scripted PowerShell cmdlet or function so as  to provide comprehensive help at the command-line...

31 min read

The Logical Data Warehouse – Towards a Single View of All the Data

What is wrong with the Enterprise Data Warehouse? Quite a lot, it seems. By taking the narrow view that the struggle is that of accommodating...

14 min read

Implementing Continuous Integration for Databases

Continuous integration (CI) is becoming more and more common in application development. It ensures code and related resources are integrated regularly and tested by an...

8 min read

So You Need to Expose JSON Endpoints

Even the most experienced programmers can be caught unawares by software they've used for years without trouble. Dino Esposito explains why and how the JSON...

11 min read

Power Query Formula Language in Power BI Desktop

The Power Query Formula Language (PQFL) is a functional language that drives the Power BI transformations, and allows you to create mashup queries from scratch....

19 min read

SQL and R

Not only can you easily retrieve data from SQL Sources for analysis and visualisation in R, but you can also use SQL to create, clean,...

17 min read