Blogs Dennes Torres 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... 06 March 2024 3 min read
Blogs Dennes Torres 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... 14 February 2024 4 min read
Phil Factor 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... 01 August 2020 22 min read
Nicolas Prigent 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... 17 March 2016 13 min read
Matthew Skelton 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... 16 March 2016 32 min read
Matthew Skelton 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... 09 March 2016 34 min read
Grant Fritchey 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... 19 February 2016 40 min read
Sergei Dumnov 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... 27 January 2016 11 min read
Dino Esposito 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',... 22 January 2016 12 min read
Jon Smith 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... 07 January 2016 14 min read
Richard Morris 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... 14 December 2015 10 min read
Nick Harrison 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 December 2015 14 min read
Paulo Morgado 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.... 30 November 2015 14 min read
Dino Esposito 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... 23 November 2015 12 min read
Michael Sorens 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... 17 November 2015 31 min read
Robert Sheldon 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... 09 November 2015 14 min read
Sjors Takes 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... 02 November 2015 8 min read
Dino Esposito 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... 15 October 2015 11 min read
Robert Sheldon 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.... 21 September 2015 19 min read
Casimir Saternos 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,... 18 September 2015 17 min read
