All articles
42 articles, newest first.
- AppsFeedMe, a calm feed reader for Windows that keeps your highlightsFeedMe is a free Windows feed reader for websites, YouTube channels and subreddits, with read later, highlights and notes. No account, everything stays on your PC.
- AppsSnipou, a free screenshot, whiteboard and video app for WindowsSnipou is a free Windows app to capture and annotate screenshots, explain a process on a whiteboard, record your screen and edit the video. No account needed.
- ObsidianRight-click, draw down, open anything in ObsidianA Snailkit feature for Obsidian where a right-click mouse gesture opens a launcher to find or create a note, switch tabs or start a task, plus gestures for any command.
- FabricFabric Source Atlas: which tables feed your semantic models?Three PowerShell scripts that export every semantic model of your Fabric workspaces and list the SQL tables, views and files each one reads, in Excel and an offline web page.
- AITwo AI developers and me: how I build with Claude Code and CodexHow I run one Claude Code session that hands work to Claude subagents and to OpenAI Codex, has each review the other, and spreads usage over two plans.
- ObsidianSnailkit, the Obsidian plugin I built for my own notesSnailkit, a free Obsidian plugin that gathers the tasks of all your notes in one list grouped by tag, sorts brainstorm notes, and adds a Home page and small writing tools.
- AILet the AI test what it builds: give it hands and eyesHow to make an AI coding assistant test its own changes in a throwaway copy of your app, with real clicks, screenshots, console checks and timings.
- Appsdbt Formatter, a small VS Code extension for dbt modelsdbt Formatter is a free VS Code extension that formats dbt SQL models to the dbt style guide, generates schema .yml files, checks doc() descriptions and shows lineage.
- AIClaude Code YOLO Mode on Windows: Skip Permissions Safely with DockerHow to run Claude Code without permission prompts on Windows, inside a Docker container that only sees your project folder, started with one PowerShell alias.
- SQL ServerHow to Make VS Code Look and Feel Like SSMSA keybindings.json file and a small VS Code extension that bring SSMS column selection, Ctrl+R and Query Shortcuts such as Ctrl+3 for top 1000 rows to VS Code.
- Power BIDocumenting Power BI Semantic Model sources Using DAX And AIA DAX query that extracts the Power Query M code of every table in a semantic model, and an AI prompt that turns it into documentation of tables and data sources.
- FabricExploring Power BI Semantic Models with Python in Microsoft FabricA Fabric notebook that uses Semantic Link (sempy) to list a Power BI model's tables and measures, run DAX and SQL queries on it, draw its relationships and check refreshes.
- FabricCreate a Calendar Dimension with SQL in a Fabric WarehouseA SQL query that creates a calendar dimension table in a Fabric Warehouse, one row per day from 1990 to 2050, with date keys, names and month, quarter and year end flags.
- FabricHandling Data Type Conflicts in SQL for Merging TablesA T-SQL script that reads the columns of two tables and generates a UNION ALL query to merge them, converting columns whose data types differ to a common type.
- Power BIAnalyzing Model Dependencies in Power BI with INFO.CALCDEPENDENCY()Five DAX queries using INFO.CALCDEPENDENCY() to see which measures, columns and tables depend on each other in a Power BI model before you change or delete one.
- Power BIOrganize your External toolsHow to tidy the External Tools ribbon in Power BI Desktop by editing the tool files in their folder to remove, rename, reorder or change the icon of each tool.
- ObsidianManaging efficiently your tasks with Obsidian and DataviewDataview queries that gather the tasks of your whole Obsidian vault into one list, filtered by open status, current file, #todo tag or YAML field.
- ObsidianI discovered Obsidian and I love itWhy I adopted Obsidian, the free note-taking app, how I use it as a second brain, and the plugins I started with, such as Dataview, Calendar and Webpage HTML Export.
- SQL ServerSP_Helptext Get DDL informationHow to display the code of a stored procedure, view, function or trigger in SQL Server with sp_helptext, plus sp_help for more details on an object.
- Power BIPower BI Scanner API List and document your Power BI tenantA PowerShell script that calls the Power BI Scanner API to export metadata for all workspaces in your tenant to JSON files, with the admin settings to enable first.
- Power BICreate a gradient background for Power BIHow to make a subtle gradient background image for Power BI in Paint.NET, a fix for the rainbow artifacts PowerPoint gradients can show in the Power BI Service.
- Power BIPower BI Sidetools extensions: A Must have!How Power BI Sidetools exports every DAX measure and Power Query to .dax and .m files, so you can version, reuse and search your model code in Visual Studio Code.
- Power BIFilter a Power BI report passing parameters through URLHow to filter a Power BI report from its URL with ?filter=, with ready-to-copy examples for numbers, text, lists of values and several fields, and the main limits.
- Power BILazyDAX: a Power BI File for your presentation, discoveries, or learn DAXA free Power BI file with a clean star schema and DAX measures grouped by function category, ready for demos, testing measures or learning DAX. Download on GitHub.
- Power BIPower BI Visuals List: Which Graphic to choose?A visual overview of the Power BI chart types, tested one by one and kept as a reference for choosing the right chart. The LazyDAX .pbix file is on GitHub.
- Power BIPower BI: Duplicate of Duplicate - The best way to test your reports and measuresA step-by-step way to debug Power BI reports. Duplicate the page, turn the visual into a table, remove filters one by one, test a single row and each measure variable.
- Power BIDAX is case insensitiveDAX string comparisons ignore letter case. Three measures filtering on Vegetable, VEGETABLE and VeGeTaBlE return the same count, shown in the LazyDAX file.
- Power BIPower BI Interview questions: a different way to know your applicantsA list of 16 open interview questions for Power BI candidates, on DAX, data modeling, Power Query, security, Premium and project approach, to see how they think.
- Power BIYour data model first!Before loading data, sketch your Power BI model on paper with your users. List their key terms, group them into dimensions, then shape the data to fit that view.
- Power BIPower BI Create a Calendar table automaticallyA ready-to-paste Power Query M function that generates a calendar table in Power BI from a start and end date, with year, quarter, month, day and week columns.
- AppsHow to stay always "Available" in Microsoft Teams with ExcelAn Excel macro that moves and clicks the mouse every five seconds so Microsoft Teams keeps you Available. Download the .xlsm file or copy the VBA code.
- AppsHow I optimized my learning time with InstapaperHow I use Instapaper to save web articles and read them later, the five features I rely on, and the Kindle integration that sends articles to my e-reader.
- Power BIPower BI - Your model mattersWhy one well-designed model beats many report-specific ones, and how to get there by denormalizing source tables and brainstorming with users to find facts and dimensions.
- Power BIPIT Point In TimeHow to show which records were valid on a chosen date in Power BI, with a disconnected calendar slicer and a DAX measure on ValidFrom and ValidTo. Sample .pbix included.
- SQL ServerManagement Studio - Faster with multiple selectHow to select a column of text with Alt+Shift and the arrow keys in SSMS or Notepad++, for example to put quotes around a list of values for an IN clause.
- SQL ServerSSIS - Create Environment from Packages variablesA T-SQL script that reads your deployed SSIS projects and generates the code to create their environments and variables with default values, and to assign them.
- Power BIPie Chart is bad!Why pie charts are discouraged in data visualization. Two datasets drawn as pie and bar charts show that comparing angles is harder than comparing lengths.
- SQL ServerSSMS - Query Shortcuts : Feel like a superman developerHow to set up Query Shortcuts in SSMS, with ready-to-paste queries for top 1000 rows, row count, table description and running queries on Ctrl+3 to Ctrl+0.
- SQL ServerSSIS - Log Execution timeA query on the SSISDB catalog that shows the start time, end time, duration in minutes and last status of each SSIS package, child packages included.
- SQL ServerSSIS - Export SSIS Catalog EnvironmentsA T-SQL script that generates the code to recreate an SSIS Catalog folder, environment and variables on another server, then map them to your project parameters.
- Power BIPower BI Desktop: Print in the A4 sizeHow to export a Power BI Desktop report page to PDF in A4 portrait format, by setting a custom page size of 794 x 1123 pixels.
- SQL ServerSP_WHO3 - Running Queries (Toolbox)A query that lists every running request on SQL Server with its user, host, database, SQL text, CPU and reads, and which session is blocking which.
