The following section contains a list of the posts grouped by topic.
Just click on the link to jump to the post.General
Azure Synapse & Microsoft Fabrics
|
Business Intelligence |
|
- Part I: Monitoring the Warehouse
- SQL Databases
Notes
- Azure Data Factory (ADF)
- Azure service principals (SPN)
- data governance
- data stores
- data warehouse
- dataflows (Gen1)
- dataflows (Gen2)
- delta lake
- delta tables
- lakehouse
- medallion architecture
- metrics layer
- Microsoft Fabric
- mirroring
- notebooks
- OneLake
- Polaris
- parquet format
- Real-Time Analytics
- shortcuts
- Part I: General Issues
- Part II: The Complexity Myth
- Part III: Self Service BI
- Part IV: How Big is Your Report?
- Part V: Data Soup - From BI to Analytics
- Part VI: Data Soup - Reports vs Data Visualization
- Part VII: Insights - Aha Moments!
- Part VIII: Insights - The Complexity Perspective
- Part IX: Dashboards are Dead & Other Crap
- Part X: The Top 5 Pains of a BI/Analytics Manager
- Part XI: Ways of Thinking about Data
- Part XII: From Data to Data Models
- Part XIII-XV: From Data to Storytelling (Part I, II, III)
- Part XVI: On the Cusps of Complexity
- Part XVII: Creating Value for Organizations
-
Part XVIII: There’s More to Noise
- Part XIX: Data Visualization between Art, Pragmatism and Kitsch
- Part XX: From BI to AI
- Part XXI: Data Visualization Revised
- Part XXII: Queries' Complexity
- Part XXIII: In between the Many Destinations
- Learning curve
- Metrics Layer
- Notes
- Metrics Layer [private preview]
- Visual Calculations
- Preparatory Steps for Creating a Power BI Report
- Working with Visual Calculations (new feature)
- A One Man Show
- Part I: Some Personal Background and a Big Thanks!
- Part II: In the Cusps of Complexity
- Part III: The Microsoft Fabric
- Part IV: Data Roles between Past and Future
- Part V: Focus on the Foundation
- Part VI: The Lakehouse Perspective
- A Software Engineer's Perspective
- Part I: Houston, we have a Problem!
- Part II: Major Knowledge Gaps
- Part III: More of a One-Man Show
- Part IV: The Loom of Interactions
- Part V: From Process Management to Mental Models in Knowledge Gaps
- Part VI: The Data Citizen
- Part VII: Think for Yourself!
- Mea Culpa
- Approaching a Query
- Learning SQL
- A Reporting Guy’s Issues
- Addressable Questions in Reports’ Creation I
- Best Practices
- Choosing Report’s Attributes
- Filtering Internal Kitchen
- How Big Is Your Report?
- How Many Reporting Systems You Need?
- Levels of Accuracy in Reporting
- Levels of Detail in Reporting
- Reports Types
- Reports’ Lifecycle - Definition
- Drawing Concentric Circles with matplotlib.pyplot
- Installing PySpark and GraphFrames on a Windows 10 Machine
- Plotting Data with the Radar Chart
- Test Drive PySpark and GraphFrames
- Data Summaries without Using a DataFrame
- Data Transformations
- Part I: Temperatures' comparison between F° and C°
- Drawing Function Plots
- Hello World in R & Working with Data Frames
- Using the lessR Package in Microsoft Fabric's Notebooks (Test Drive)
- Visualizing the Iris Dataset
- Covid-19 Data Project
- Matrix Report Display - Fifth Magic Class
- Parameter Dependencies in Dropdowns- Fourth Magic Class
- Poor Design of Parameters
- Ranking Rows in Reports
- Report Formatting - Third Magic Class
- Report Parameters - Second Magic Class
- SQL Server CPU Utilization
- The Good, the Bad and the Ugly
- Wizarding a Report
- Graphical Representations II - Sixth Magic Class
Data Management
- Business Rules
- Part I: An Introduction
- Data Culture
- Part I: No Silver Bullet
- Part II: Leadership is Necessary but not Sufficient
- Part III: A Tale of Two Cities
- Part IV: Quo vadis? [Where are you going?]
- Part V: Quid nunc? [What now?]
- Data Driven
- Data Governance
- Data Integration
- Data Literacy
- Data Operations
- Data Profiling
- Data Quality
- An Introduction
- Data Cleansing
- Data Migration
- Dimensions
- Information Systems' Perspective
- Data Security
- Data Soup
- Master Data Management (MDM)
- Notes
Data Migrations
|
Data Warehousing
- Data Vault 2.0
- Data Warehousing
- Data Warehousing and Microsoft Dynamics 365
- A Few Issues to Consider (Part I)
- Building a Data Lakehouse for Dynamics 365 Environments with Serverless SQL Pool
- Data Warehousing and Microsoft Dynamics 365
- Dynamics 365, the Data Lakehouse and the Medallion Architecture
- ETL
- An Introduction
- Push vs. Pull
- SSIS packages vs. SQL code
- Synchronization
- The Extract Subprocess
- The Load Subprocess
- The Transform Subprocess
- Microsoft Fabric
- Data(base) Mirroring in Microsoft Fabric (New feature)
- SSIS
- Aggregate Data Flow Transformation
- Percentage Sampling Data Flow Transformation
- Second Magic Class - SQL Server to Oracle Data Export
- The Conditional Split Data Flow Transformation
- The Good, the Bad and the Ugly
- The Union All Data Flow Transformation
- Third Magic Class - Data Flow Task
- Using Oracle as Data Source
- Visual Studio 2010 CR doesn’t support SSIS Projects
- Wizarding an SSIS Package - First Magic Class
- Concepts
- Definitions
- Part I: The Stored Procedure Case
- Part II: What's in a Name
- Challenges
- Cheat sheets
- Database objects
- Dependencies I - Introduction
- Views I
- Views II
- Table Value Constructors at Work
- Temporary Tables vs. Table Variables and TempDB
- Databases
- An Introduction
- Event Streaming Databases - More of a Kafka’s Story
- Running a Statement for Each Database - CLR Version
- Searching a Value within a Database
- SQL Reloaded
- A Look into Reverse
- Advices on SQL logic split in Web Applications
- Aggregates
- Number of records
- Before and After
- Best practices
- Concatenation
- Common table expressions
- CRUD
- Incremental Update Technique
- Saving Data With Stored Procedures
- Self-Join in Update Query I
- Self-Join in Update Query II
- Stored Procedures from Metadata
- Updating Data With Values From The Same Table
- Cursor and Linked Server for Data Import
- Cursors and Lists
- Data Processing
- Preparing test data
- Processing JSON Files with Complex Structure in SQL Server 2016+
- Processing JSON Files with Flat Matrix Structure in SQL Server 2016+
- Randomized Data Selection
- SQL Server and Excel Data
- Trivial Equalities in Queries
- Useful Functions in Data Conversion
- Ways of Looking at Data
- When Queries Look Like Ducks
- XML on SQL Server 2005
- Dates
- GetDate SQL Server 2000/2005
- More Date-related Functionality I
- More Date-related Functionality II
- Some Notes on Dates
- Dynamic Queries
- Evaluating Textual Expressions with CLR UDFs
- Handling duplicates
- Joins
- Self-Join in Update Query I
- Self-Join in Update Query II
- Self-Joins and Denormalized Data Loading in Normalized Models
- The Power of Joins
- Just in CASE
- Part I: Introduction
- Part II: Clauses and Joins
- Part III: Quest for Performance
- Part IV: Other Scenarios
- Part V: Dynamic Queries
- Functions Useful in Data Migrations
- Lists
- List Based Aggregations - On Hand example
- Lists as Parameters in Stored Procedures
- Lists, Sets and a Little Math
- Table-valued Functions and List of Values
- Math
- Prime Numbers
- To be or not to be a Prime
- 6 out of 49
- Misusing Views and Pseudo-Constants
- Null-ifying the World
- Out of Space
- PIVOT Operator Example
- Partition-based functions
- Successive Price Increases/Discounts via Windowing Functions and CTEs
- STRING_AGG and STRING_SPLIT at Work, and a Bit of Pivoting
- String_Split Function
- Tricks with Strings via STRING_SPLIT, PATINDEX and TRANSLATE
- window functions
- Simple Aggregations (SQL Server 2022)
- Running Totals (SQL Server 2022)
- Ranking (SQL Server 2022)
- Window Functions
- Pulling the Strings of SQL Server
- Part I - An Introduction
- Part II - Creation and Selection
- Part IV - Spaces, Trimming, Length and Comparisons
- Part V - Character Indexes
- Part VI - Subparts of a String
- Part VII - List of Values
- Part VIII - Insertions, Deletions and Replacements
- Part IX - Special Characters
- Part X - Dynamic Queries
- The STUFF function
- Oracle
- Oracle vs SQL Server
- Query Patterns in SQL Server
- SQL Server
- Administration
- Database Recovery on SQL Server 2017
- End of Life for 2008 and 2008 R2 Versions
- Feature Bloat
- Killing Sessions - Killing ‘em Softly and other Snake Stories
- Monitoring the Database Logs
- System.OutOfMemoryException in SQL Server Management Studio and other 32-bit Drawbacks
- Metadata
- Part I: Indexes Overview
- Features
- New
- Undocumented
- Part I: Reading the SQL Server Log
- Part II: Execute Command for Each Table
- Part III: CPU Utilization via the Ring Buffer
- Part IV: DBCC SQLPERF
- Wish List
Notes
- buffer pool
- checkpoints
- compression
- garbage collection
- live query statistics
- logging
- minimally logged
- locking
- memory
- memory manager
- NUMA
- objects
- cursor [defs]
- databases [defs]
- model database [defs]
- tempdb database [defs]
- functions
- aggregate functions [defs]
- analytics functions
- system functions
- table-valued functions
- user-defined functions
- indexes [defs]
- clustered index [defs]
- clustered vs non-clustered indexes
- composite indexes [defs]
- covering indexes [defs]
- index selectivity [defs]
- non-clustered indexes [defs]
- keys
- stored procedures [defs]
- system stored procedures [defs]
- user-defined stored procedures
- tables [defs]
- contained database
- resource database
- scalable shared database
- stretched databases
- table variables
- tempdb
- temporal databases
- temporary tables
- triggers [defs]
- views [defs]
- user-defined views
- indexed views
- system views
- parameter sniffing
- partitions
- plan cache
- queries
- correlated subquery [defs]
- query optimization
- query plan
- query processing
- subqueries
- real-time operational analytics
- resource governor
- resource monitor
- service broker
- sessions
- transaction log [defs]
- transactions [defs]
- variables
- Troubleshooting
- Adventure Works - one year later
- Adventure Works installation error on Vista
- AdventureWorks requires FILESTREAM enabled
- Could not load file or assembly Microsoft.MSXML…
- Errors
- Information Schema Views
- Logical errors
- Login Failed for User
- Microsoft SQL Server 2008 installation error
- Porting 32 bit CLR UDFs on 64 bit Platforms
- Problems in SQL Server 2000 DTS Packages
- Root Blocking Sessions
- Searching the Error Log
- Who is Active
ERP Systems
- Data Migration
- Data Warehousing
- ERP Implementations
- Introducing an Upfront Proof-of-Concept Setup
- ERP Software Predictions for 2010
- It’s a Matter of Complexity
- It’s all about Partnership
- Part I
- Part II
- It’s all about Scope
- Preventing the Failure
- Simplifying the Implementation Project
- The Implementation Process Seems to be Broken
- The right ERP software
- Dynamics 365
- general
- Finance
- Invoice Capture
- Notes
- Vendor Invoices Processing
- Operations
- SQL queries
- Oracle e-Business Suite
Metablogging
MS Office
- MS Excel
- Excel for SQL Developers
- MS Access
Process Management
- Dynamics 365 for Finance & Operations
- ITIL
Project Management
- Methodologies:
- Agility under Eyeglasses
- The Good, the Bad and the Ugly
- Project Planning
- Planning Correctly Misundersood
- Some Thoughts on Planning
- The Butterflies of Project Management
- Project Tools
- Project Management
- Projects' Dynamics
- Redefining Projects' Success I
- The Agile Manifesto Reloaded
Software Engineering
- Application Design
- Documentation
- Programming
- A Problem Solving Approach to Troubleshooting I
- Believe and Not Doubt?!
- Football and Software Development
- Good Programmer, Bad Programmer
- Keeping Current or the Quest to Lifelong Learning for IT Professionals
- Mea Culpa I
- Misconceptions about Programming I
- Misconceptions about Programming II
- Pair Programming
- Programmer, Coder or Developer?
- Programming as Art
- The Dark Side of Programming
- To get or not Certified?!
- What is Programming About?
Strategic Management
- Lean Management
- Between Value and Waste
- Part I: Introduction
- Notes
- Performance Management
- First Time Right (The Aim toward Operational Excellence)
- Over-Educated, Yet Under-Qualified?
- The Need for Perfection vs. Excellence
- Simplicity
- Part I: Simple, but not that Simple
- Part II: A System's View
- Part III:
- Part IV: Designing for Simplicity
- Part V: ERP Implementations' Story I
- Part VI: ERP Implementations' Story II
- Strategy
- Strategic Perspectives
- Defining the Strategy
- Quality Acceptance Criteria for Strategies and Concepts
- Strategic Planning
- The Reason behind a Strategy
- The Impact of New Technologies
Systems Engineering
- Complex Systems
- Never-Ending Stories in Praxis (Quote of the Day)
- A Play of Problems (Much Ado about Nothing)
- Simplicity
No comments:
Post a Comment