Post Index
The Frog-Blog post index:
- How to Trigger a Power BI Dataset Refresh via Azure Synapse Analytics in 3 Simple Steps.
- Deploy Azure AutoML Model And Consume In Excel
- The SQL Query Alias Conundrum – Order of Execution
- ADF Dataflow CTE workaround
- Download Power BI Reports using PowerShell
- How to parameterise the Execute Pipeline activity in Azure Synapse Analytics.
- AutoML; How to use it and why
- Combining Queries from Multiple Sources in Power BI using Merge and Append
- Execute SQL Task in ADF
- Creating a quadratic solver in Python
- How to resolve SSIS “Row yielded no match during lookup” error.
- Azure Backup for Virtual Machines
- Pandas; Why Use It And How To Do So!
- Making the DAX Engine Work for You
- Azure Storage Backup Retention
- How to create a toggle button in Power BI
- Change the Compatibility Level of a Power BI report
- Automate changing SSIS connection at runtime
- Replicating SQL windowing functions in Power Query.
- Increasing DAX Filter Speed and Efficiency
- Variables in DAX
- How to create the Fibonacci Sequence in Python
- How to change the summarization of multiple columns in Power BI.
- Azure Synapse Series: What is Workload Management (part2)
- How the UNICHAR() DAX Function Enhances Power BI Reports
- Join 2 Python lists together using nested loops
- How to export more than 30,000 rows of data from Power BI Desktop.
- Azure Synapse Series: What is Workload Management (part1)
- Dynamic Date Formats in Power BI
- My DAX Training Evaluation
- Power BI – Enable Load
- How to make your matrix column widths all equal to each other in Power BI using DAX.
- Azure Synapse Series: Hash Distribution and Shuffle
- Power BI Drill Through using Multiple Data Points
- Azure Analysis Services Cube Backup
- ADF Switch Activity – A neat solution for nested IFs.
- Tabular Cube Processing Report
- My Experience of SQLBits 2020
- Speaking at Data Platform Summit
- How to block the creation of a classic workspace in powerbi.com when a new MS Team is created!
- My experience in obtaining an MCSE
- How to delay a Python loop
- SSAS Tabular Calculation Groups – avoid using SELECTEDMEASURE or ISSELECTEDMEASURE
- ADF: Where have my connections gone?
- Using ConcatenateX in PowerBI to return multiple values.
- Regular Expression to get tables from SQL query
- Sorting a Power BI table by multiple columns
- Power BI Databricks Spark connection error
- Cube deployment error: Cannot resolve all paths while de-serializing Database
- Azure Data Factory (ADF) Parent Activities don’t trigger ON ERROR OUTPUT when Child Activities Error… What happens?
- Creating calendar tables with DAX using Power BI
- Creating a Python function to calculate Pi
- SQL LAST_VALUE() wrong results
- System OutOfMemoryException when deploying SSIS .ispac
- Creating Power BI Layouts using PowerPoint
- Capturing Insert and Update Counts from Merge
- Power BI Sentinel
- SSAS Tabular Deployment Wizard fails Newtonsoft.Json error
- Lookups and If Conditions in Azure Data Factory v2 (ADFv2)
- Sampling data in Data Lake U-SQL for Power BI
- Showing December to December to see opening values for a year in SSAS/MDX
- SQL Server 2016 Licensing Changes, SP1, v.Next CTP1, etc.
- What is U-SQL?
- PASS Summit and MVP Summit 2015
- MDX Compare or Rank Similar Members
- Excel crashes when enabling macros
- First thoughts on DataZen
- Excel creates inefficient MDX
- Microsoft Acquires Datazen
- New Azure User Group in Birmingham
- BIML – What is it?
- Why you should start presenting at conferences
- SSAS Tabular String Imported as Integer
- Excel doesn’t open CSV files correctly from sp_send_dbmail
- Analysis Services Tabular or Multidimensional? A performance comparison
- SSAS Tabular performance – NUMA update
- Renaming an SSAS Tabular Model
- SSAS Tabular – NUMA and CPU Cores Performance
- SSAS Tabular performance – DefaultSegmentRowCount
- Dimension ProcessAdd in SSAS
- LogParser Performance Inserting into SQL Server
- SQL Relay Interview
- SQL Relay 2013
- MDX Between Start Date and End Date
- Database Management PhD survey
- SSIS Expression Editor and Tester
- Querying dimension members in MDX
- Rock Paper Scissors Lizard Spock
- Find first order date in MDX
- Still time to register for SQL Saturday 162 in Cambridge
- Speaking at SQL Saturday 162 in Cambridge
- MSc Dissertation – Performance of Loading SCDs in SSIS
- SQLBits X Video available
- SQL Relay Agenda Announced
- Automating T-SQL Merge to load Dimensions (SCD)
- Map Postcodes in SSRS Reporting Services
- SQLBits X talk – Loading Data Warehouse Dimensions
- Using T-SQL Merge to load Data Warehouse dimensions
- Introduction to T-SQL Merge Basics
- Fast record count in SQL Server using sp_spaceused
- PowerPivot Vs QlikView 101 – SQLBits Video
- SQLBits 9 Session – PowerPivot and QlikView 101
- New UK SQL Server User Groups
- Midlands SQL Server User Group now a PASS chapter
- Pattern matching in SSIS using Regular Expressions and the Script component
- SQL User Groups and SQLBits
- Video: Automating SSAS OLAP Cube documentation
- The Business Intelligence Semantic Model (BISM)
- SQL Server Art using Spatial Data
- SQLBits 8 in Photos
- Drawing a logo or diagram using SQL spatial data
- SQL Server User Group – Birmingham
- Speed up SSIS by using a slower query
- Debug MDX queries using Drillthrough in SSMS
- How to add calculations in SSAS cubes
- Forecasting the Performance of SSIS packages
- Deploying MDX calculation scripts with xmla
- Business Intelligence in the Cloud
- OLAP Cube Documentation in SSRS part 3
- OLAP Cube Documentation in SSRS part 2
- OLAP Cube Documentation in SSRS part 1
- BCS talk on Business Intelligence – Slides
- BCS talk on Business Intelligence
- Will DAX replace MDX
- Calculating Run Rate in DAX for PowerPivot
- Calculate Run Rate (Full Year Projection) in MDX
- Seagate Momentus XT Hybrid Drive
- MDX Calculated Member Spanning Multiple Date Dimensions
- Data Warehousing: Kimball vs Inmon
- Leap before you can land
- SQL User Group Session 24 June 2010
- SQL Server 2008 R2 – PowerPivot and Master Data Services
- SQLBits and Microsoft BI conferences
- Clearing SSRS Query cache
- Excel Cube Pivot drillthrough limited to 1000 rows
- Loan Amortisation in SQL Server (PMT, FV, IPMT, PPMT)
- SQL Bits 6 – Registration Open
- MDX Sub select Vs WHERE clause
- Data Warehouse Presentation
- Scope Problems with MDX Calculated Members
- Excel 2007 and SSAS 2008 Error
- Style Sheets with Reporting Services
- Dynamic MDX in Reporting Services
- Mosha's MDX Studio
- SQLBits III and more…
- Use Stored Procedure Output Parameters in SSRS
- Ranking results from MDX queries
- SSRS Report Performance monitoring
- Semi Additive Measures using SQL Server Standard
- Sky Anytime – Killing Kontiki
- Extract Datasource and Query from Excel Pivot
- Report Parameter Selection Memory
- Open SSRS report in a new Window
- Excel Addin for Analysis Services
- Convert MDX fields to SQL
- Chris Hays Reporting Services Sleazy Hacks
- The Frog-Blog is open for business!
Leave a Reply
The Frog Blog
Team Purple Frog specialise in designing and implementing Microsoft Data Analytics solutions, including Data Warehouses, Cubes, SQL Server, SSIS, ADF, SSAS, Power BI, MDX, DAX, Machine Learning and more.
This is a collection of thoughts, ramblings and ideas that we think would be useful to share.
Authors:
| Alex Whittles (MVP) |  |
| Jeet Kainth |  |
| Jon Fletcher |  |
| Nick Edwards |  |
| Joe Billingham |  |
| Lewis Prince |  |
| Reiss McSporran |  |
