Blog
All blog posts by category.
Data
- Quicksilver Project - Database
- Quicksilver Project - Intro
- Viewing Column Sizes in Power BI Desktop
- Goodbye, SQL PASS
- Passing the DA-100 Exam - Study Notes
- SQL Saturday #919 Recap
- Drive Space and File Size via T-SQL
- SQL Saturday #845 Recap
- T-SQL Tuesday #104: Code I would hate to live without
- Using PowerShell to generate T-SQL
- MERGE Quick Reference (T-SQL)
- PIVOT and UNPIVOT quick reference
- Safe UPDATE and DELETE
- Extending the AdventureWorksDW2012 Date Dimension
- Master Data Services Import File
- T-SQL Study: A SEQUENCE of Unfortunate Events
- T-SQL Study: OFFSET FETCH
- T-SQL Study: Create View and Procedure Options
- T-SQL Tuesday #47: Your Best SQL Server Swag
- Data Management and Indexing Options for SQL Server Data Warehouses
- T-SQL Tuesday #44: Second Chances
- Best week EVAR
- T-SQL Tuesday #42: The Long and Winding Road
- T-SQL Tuesday #41 - Presenting and Loving it
- Performance Tuning Challenge: DBAs vs Developers
Analysis
- Viewing Column Sizes in Power BI Desktop
- Aggregate Changes with T-SQL Window Functions
- Passing the DA-100 Exam - Study Notes
- Power BI Exam 70-778 Study Guide
- Astroball: The New Way to Win It All
- Datazen Technical Overview
- Extending the AdventureWorksDW2012 Date Dimension
- Processing SSAS with SSIS script tasks
- SSAS Default NULL Measure
- SSAS Clear Cache snippet
- SQL Saturday #285: Atlanta
- MDX: Fundamentals Presentation
- Data Management and Indexing Options for SQL Server Data Warehouses
- Google Hangout with Boris Hristov
- Recap of DAX vs MDX Smackdown
Integration
Automation
- Sharpen the Saw
- Quicksilver Project - Database
- Quicksilver Project - Intro
- PowerShell and Zip files
- T-SQL Tuesday #104: Code I would hate to live without
- Using PowerShell to generate T-SQL
- Processing SSAS with SSIS script tasks