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:
Post a Comment