Index Posts

The following section contains a list of the posts grouped by topic. Just click on the link to jump to the post.


Book Reviews
Head First SQL
Business Intelligence
BI: Between Potential, Reality, Quality and Stories
BI: Between Products, Partners, People and Processes
BI: Issues
BI: Myths - Business Intelligence is Complex
Graphical Representation: Pie Charts - An Introduction
Graphical Representation: Reports vs. Data Visualizations
Graphics: Drawing Function Plots with R
KPIs: Introduction
Reports: A Reporting Guy’s Issues
Reports: Addressable Questions in Reports’ Creation I
Reports: Best Practices
Reports: Choosing Report’s Attributes
Reports: Enterprise Reporting
Reports: Filtering Internal Kitchen
Reports: How Big Is Your Report?
Reports: How Many Reporting Systems You Need?
Reports: Levels of Accuracy in Reporting
Reports: Levels of Detail in Reporting
Reports: Reports Types
Reports: Reports’ Lifecycle - Definition
Self-Service BI: An Introduction
Self-Service BI: The Good, the Bad and the Ugly
SSRS: Covid-19 Data Project
SSRS: First Magic Class - Wizarding a Report
SSRS: Graphical Representations I - SQL Server CPU Utilization
SSRS: Graphical Representations II - Sixth Magic Class
SSRS: Matrix Report Display - Fifth Magic Class
SSRS: Parameter Dependencies in Dropdowns- Fourth Magic Class
SSRS: Poor Design of Parameters
SSRS: Ranking Rows in Reports
SSRS: Report Formatting - Third Magic Class
SSRS: Report Parameters - Second Magic Class
SSRS: The Good, the Bad and the Ugly
Test Drive: Cognos & SQL Server 2008 - The First Report
Data Management
Business Rules: An Introduction
Data Integration: From Disintegration to Integration
Data Literacy as Second Language
Data Operations: One Database, Two Vendors, No Love Story or Maybe…
Data Profiling I: Introduction
Data Profiling II: Using CLR functions
Data Quality Dimensions: Accuracy
Data Quality Dimensions: Completeness
Data Quality Dimensions: Conformity
Data Quality Dimensions: Consistency
Data Quality Dimensions: Referential Integrity
Data Quality Dimensions: Uniqueness
Data Quality: Data Cleansing
Data Quality: Data Migration’s Perspective I (A Bird’s-Eye View)
Data Quality: Information Systems' Perspective
Data Quality: Introduction
Data Security: SQL Injection I - Introduction
Data Soup: Data Structuredness
Data Soup: From Business Intelligence to Analytics
Data-Driven: The Data-Driven Enterprise
Data Science
Data Science: Big Data vs. Business Strategies
Data Science: Generalists vs Specialists in the Field of Data Science
Data Warehousing
Data Soup: Data Lakes & other Puddles
Methodologies: Data Vault 2.0 (The Good, the Bad and the Ugly)
Data Warehouse: A Personal Journey
Data Warehouse: Data Load Optimization - A Success Story
Data Warehouse: Data Warehousing and Microsoft Dynamics 365
ETL: An Introduction
ETL: Push vs. Pull
ETL: SSIS packages vs. SQL code
ETL: Synchronization
ETL: The Extract Subprocess
ETL: The Load Subprocess
ETL: The Transform Subprocess
SSIS: Aggregate Data Flow Transformation
SSIS: Percentage Sampling Data Flow Transformation
SSIS: Second Magic Class - SQL Server to Oracle Data Export
SSIS: The Conditional Split Data Flow Transformation
SSIS: The Good, the Bad and the Ugly
SSIS: The Union All Data Flow Transformation
SSIS: Third Magic Class - Data Flow Task
SSIS: Using Oracle as Data Source
SSIS: Visual Studio 2010 CR doesn’t support SSIS Projects
SSIS: Wizarding an SSIS Package - First Magic Class
Database Management Systems (DBMS)
SQL Reloaded: CRUD Stored Procedures from Metadata I (Insert & Update)
SQL Reloaded: CRUD Stored Procedures from Metadata II (Get, Dropdown & Delete)
Database Objects: Dependencies I - Introduction
Database Objects: Views I
Database Objects: Views II
Databases: An Introduction
Databases : Event Streaming Database - More of a Kafka’s Story
Just In CASE I: Introduction
Just In CASE II: Clauses and Joins
Just In CASE III: Quest for Performance
Just In CASE IV: Other Scenarios
Just In CASE V: Dynamic Queries
Oracle Troubleshooting: ANSI 92 JOIN syntax error
Oracle Troubleshooting: No records returned by queries
Oracle vs. SQL Server: Averages I
Oracle vs. SQL Server: Date Conversion
Oracle vs. SQL Server: Date Operations
Oracle vs. SQL Server: Date Validation
Oracle vs. SQL Server: Handling Missing Dates
Oracle vs. SQL Server: Running Totals
Query Patterns in SQL Server: Aggregate Functions
Query Patterns in SQL Server: Inserts
Query Patterns in SQL Server: Joins and Subqueries
Query Patterns in SQL Server: Matrix Representation
Query Patterns in SQL Server: Window Functions
SQL Reloaded: A Look into Reverse
SQL Reloaded: Advices on SQL logic split in Web Applications
SQL Reloaded: Before and After - Drop If Exists
SQL Reloaded: Before and After - Splitting a String
SQL Reloaded: Before and After - Trimming Strings
SQL Reloaded: Best Practices in Query Writing I
SQL Reloaded: Concatenation
SQL Reloaded: Cursor and Linked Server for Data Import
SQL Reloaded: Cursors and Lists
SQL Reloaded: Dealing with data duplicates on SQL Server
SQL Reloaded: Deleting Sequential Data From a Table
SQL Reloaded: Deterministic Functions - GetDate SQL Server 2000/2005
SQL Reloaded: Dynamic Queries
SQL Reloaded: Evaluating Textual Expressions with CLR UDFs
SQL Reloaded: Functions Useful in Data Migrations
SQL Reloaded: Hierarchies in Oracle
SQL Reloaded: Incremental Update Technique
SQL Reloaded: List Based Aggregations - On Hand example
SQL Reloaded: Lists as Parameters in Stored Procedures
SQL Reloaded: Lists, Sets and a Little Math
SQL Reloaded: Misusing Views and Pseudo-Constants
SQL Reloaded: More Date-related Functionality I
SQL Reloaded: More Date-related Functionality II
SQL Reloaded: Null-ifying the World
SQL Reloaded: Number of Records - The CLR Version
SQL Reloaded: Number of Records - The DMV Approach
SQL Reloaded: Number of Records - via COUNT
SQL Reloaded: Out of Space
SQL Reloaded: PIVOT Operator Example
SQL Reloaded: Preparing test data
SQL Reloaded: Prime Numbers
SQL Reloaded: Pulling the Strings of SQL Server I - Introduction
SQL Reloaded: Pulling the Strings of SQL Server II - Creation and Selection
SQL Reloaded: Pulling the Strings of SQL Server IV - Spaces, Trimming, Length and Comparisons
SQL Reloaded: Pulling the Strings of SQL Server IX - Special Characters
SQL Reloaded: Pulling the Strings of SQL Server V - Character Indexes
SQL Reloaded: Pulling the Strings of SQL Server VI - Subparts of a String
SQL Reloaded: Pulling the Strings of SQL Server VII - List of Values
SQL Reloaded: Pulling the Strings of SQL Server VIII - Insertions, Deletions and Replacements
SQL Reloaded: Pulling the Strings of SQL Server X - Dynamic Queries
SQL Reloaded: Randomized Data Selection
SQL Reloaded: Running a Statement for Each Database - CLR Version
SQL Reloaded: Saving Data With Stored Procedures
SQL Reloaded: Searching a Value within a Database
SQL Reloaded: Self-Join in Update Query I
SQL Reloaded: Self-Join in Update Query II
SQL Reloaded: Self-Joins and Denormalized Data Loading in Normalized Models
SQL Reloaded: Some Notes on Dates
SQL Reloaded: SQL Server and Excel Data
SQL Reloaded: String_Split Function
SQL Reloaded: Table Value Constructors at Work
SQL Reloaded: Table-valued Functions and List of Values
SQL Reloaded: Temporary Tables vs. Table Variables and TempDB
SQL Reloaded: The Power of Joins I - Introduction
SQL Reloaded: The Power of Joins II - Horizontal Joins
SQL Reloaded: The Power of Joins III - Vertical Joins
SQL Reloaded: The Power of Joins IV - Multi-Joins Under Control
SQL Reloaded: The Power of Joins V - Semi-Joins and Anti-Joins
SQL Reloaded: The Power of Joins VI - Not-Equal Joins
SQL Reloaded: The Stuff function
SQL Reloaded: To be or not to be a Prime
SQL Reloaded: Trivial Equalities in Queries
SQL Reloaded: TSQL Challenge 24
SQL Reloaded: Updating Data With Values From The Same Table
SQL Reloaded: Useful Functions in Data Conversion
SQL Reloaded: Ways of Looking at Data I
SQL Reloaded: Ways of Looking at Data II
SQL Reloaded: Ways of Looking at Data III
SQL Reloaded: Ways of Looking at Data IV - Hierarchies
SQL Reloaded: Ways of Looking at Data V - Hierarchies
SQL Reloaded: Wish List - Replace From
SQL Reloaded: XML on SQL Server 2005
SQL Server Administration: Database Recovery on SQL Server 2017
SQL Server Administration: End of Life for 2008 and 2008 R2 Versions
SQL Server Administration: Feature Bloat
SQL Server Administration: Killing Sessions - Killing ‘em Softly and other Snake Stories
SQL Server Administration: System.OutOfMemoryException in SQL Server Management Studio and other 32-bit Drawbacks
SQL Server New Features: Hello World in R & Working with Data Frames
SQL Server New Features: Information Schema Views
SQL Server New Features: ROWCOUNT in action
SQL Server New Features: SQL Server 2012 is almost here
SQL Server New Features: Window Functions
SQL Server Troubleshooting: Adventure Works - one year later
SQL Server Troubleshooting: Adventure Works installation error on Vista
SQL Server Troubleshooting: AdventureWorks requires FILESTREAM enabled
SQL Server Troubleshooting: Could not load file or assembly Microsoft.MSXML…
SQL Server Troubleshooting: Errors
SQL Server Troubleshooting: Logical errors
SQL Server Troubleshooting: Login Failed for User
SQL Server Troubleshooting: Microsoft SQL Server 2008 installation error
SQL Server Troubleshooting: Porting 32 bit CLR UDFs on 64 bit Platforms
SQL Server Troubleshooting: Problems in SQL Server 2000 DTS Packages
SQL Server Troubleshooting: Root Blocking Sessions
SQL Server Troubleshooting: Searching the Error Log
SQL Server Troubleshooting: Who is Active
SQL Server Undocumented I: Reading the SQL Server Log
SQL Server Undocumented II: Execute Command for Each Table
SQL Server Undocumented III: CPU Utilization via the Ring Buffer
SQL Reloaded: When Queries Look Like Ducks
ERP Systems
Data Migration: An Introduction
Data Migration: Approaches to Planning
Data Migration: Facts, Principles and Practices
Data Migration: In-house Built Solutions
Data Migration: Migrating AdventureWorks to Dynamics 365 - Products
Data Migration: Principles
Data Migration: The Data Preparation Layer
Data Migration: The Import Layer
Data Migration: What is Data Migration?
ERP Implementations: It’s all about Scope I (Functional Requirements)
ERP Implementations: It’s all about Scope II (Nonfunctional Requirements & MVP)
ERP Implementations: Preventing the Failure
Microsoft Dynamics 365: AX 2009 vs. D365 FO - Product Prices with two Different Queries
Dynamics AX 2009: Deleting Obsolete Companies
ERP Systems: ERP Software Predictions for 2010
ERP Systems: Learning about Oracle APPS internals II
ERP Systems: Learning about Oracle APPS internals I
ERP Systems: The right ERP software
Microsoft Dynamics 365: The Good, the Bad and the Ugly
Knowledge Management
Concepts: Definitions I (The Stored Procedure Case)
Concepts: Definitions II (What's in a Name)
Learning: Keeping Current or the Quest to Lifelong Learning for IT Professionals
Metablogging
Blogging: Changing the Status quo
Blogging: Introduction
Blogging: Past, Present and Future
MS Office
MS Excel: Excel for SQL Developers I - Range to Delimited List of Values
MS Excel: Excel for SQL Developers II: Insert Statements
MS Excel: Excel for SQL Developers III: Creating a Stored Procedure from Table’s Metadata
MS Excel: Excel for SQL Developers IV: Differences Between Two Datasets
MS Access: MS Access vs. LightSwitch - About Starts and Ends of Software Products
MS Access: Is MS Access or MS Excel the Answer to your Problem?
MS Access: The Limitations of MS Access Database
MS Access: Why I dislike MS Access
Performance Management
Performance Management: Over-Educated, Yet Under-Qualified?
Performance Management: The Need for Perfection vs. Excellence
Project Management
Methodologies: Agility under Eyeglasses I
Methodologies: Agility under Eyeglasses II
Methodologies: The Good, the Bad and the Ugly
Project Planning: Planning Correctly Misundersood I
Project Planning: Planning Correctly Misundersood II
Project Planning: Planning Correctly Misundersood III
Project Planning: Planning Correctly Misundersood IV
Project Planning: Some Thoughts on Planning I
Project Planning: Some Thoughts on Planning II
Project Planning: The Butterflies of Project Management
Project Tools: The Choice of Tools in Project Management
Projects: Redefining Projects' Success I
Software Engineering
Application Design: Rapid Prototyping
Application Design: Who Messed with My Data?
Concept Documents: The Good, the Bad and the Ugly
Lessons Learned: Documentation
Programming: A Problem Solving Approach to Troubleshooting I
Programming: Approaching a Query
Programming: Believe and Not Doubt?!
Programming: Football and Software Development
Programming: Good Programmer, Bad Programmer
Programming: Learning SQL
Programming: Mea Culpa I
Programming: Misconceptions about Programming I
Programming: Misconceptions about Programming II
Programming: Pair Programming
Programming: Programmer, Coder or Developer?
Programming: Programming as Art
Programming: The Dark Side of Programming
Programming: To get or not Certified?!
Programming: What is Programming About?
Strategic Management
Simplicity I: Simple, but not that Simple
Simplicity II: A System's View
Simplicity IV: Designing for Simplicity
Simplicity V: ERP Implementations' Story I
Simplicity VI: ERP Implementations' Story II
Strategy: Agile vs. Lean Organizations
Strategy: Defining the Strategy
Strategy: Quality Acceptance Criteria for Strategies and Concepts
Strategy: Strategic Planning
Strategy: The Reason behind a Strategy

No comments:

Related Posts Plugin for WordPress, Blogger...