Post Index
The Frog-Blog post index:
- 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!