Python for Threat Intelligence
Explore threat intelligence using Python: automate tasks, analyze data, and build tools for security incident prevention. Learn from real-world examples and development practices.
Goodbye, "Hello, World." Hello, Functional FastAPI Web App!
Build a functional FastAPI web app, transitioning from beginner to intermediate. Learn app planning, configuration, structure, and database modeling for real-world scenarios.
Using PostgreSQL as a Better NoSQL
Explore PostgreSQL's capabilities as a superior NoSQL alternative, leveraging its flexibility and performance for modern data management challenges.
Composite Key is Ready for Django 1.4
Explore the implementation and benefits of Composite Key in Django 1.4, enhancing database management and improving application performance.
Introduction to Cassandra
Learn about Cassandra's architecture, data model, and use cases. Explore its advantages, limitations, and how it compares to traditional databases in this comprehensive overview.
Building a Multi-Purpose Platform for Bulk Data Using SQLAlchemy
Learn to build a scalable platform for processing bulk data across multiple business domains using SQLAlchemy, with insights on optimizing performance and maintaining flexibility.
Optimizing Queries for Not So Big Data in PostgreSQL
Optimizing PostgreSQL queries for medium-sized datasets: strategies for efficient database design, query optimization, and maintenance to handle high-volume data and requests.
How to Be Pythonic - Design a Query Language in Python
Explore the design of WOQLpy, a Python query language for TerminusDB. Learn about challenges, methods, and best practices in creating Pythonic packages, with interactive discussions on effective Python design.
Everything You Know About MongoDB is Wrong
Debunking MongoDB myths: ACID compliance, transactions, schemas, security, and best practices for development. Insights into MongoDB's evolution and current capabilities.
Windows Azure SQL Database Design - Silver Lining and Dark Side
Explore Windows Azure SQL Database design, covering editions, limitations, costs, data types, and modeling. Learn 10 tips for effective design and migration strategies.
50 Things All SQL Server Developers Need to Know
Discover 50 essential SQL Server development tips, covering database design, T-SQL best practices, and query optimization techniques for improved performance and efficiency.
The Art and the Science of Designing a Mission Critical SQL Server Solution
Explore mission-critical SQL Server design archetypes, selecting optimal features for high availability and scalability. Learn best practices and real-world advice for robust database system implementation.
Database Design - Solving Problems Before They Start
Explore key database design principles to prevent future issues. Learn about data types, normalization, and naming conventions through live demos, enhancing your TSQL skills and decision-making abilities.
Aprende todo sobre Business Intelligence con SQL Server 2012, SharePoint y Excel 2013
Domina las herramientas de Business Intelligence: SQL Server 2012, SharePoint y Excel 2013. Desarrolla habilidades para analizar datos y tomar decisiones empresariales informadas.
Query Performance Tuning in SQL Server 2014
Comprehensive guide to SQL Server query optimization, covering database design, server configuration, and T-SQL coding techniques for improved performance.
Create Your First SSAS Tabular Model
Learn to create your first Analysis Services Tabular model using Visual Studio. Import tables, establish relationships, and write formulas for data browsing with Excel and Power View.
Power BI Deep Dive
Explora las nuevas capacidades de Excel y Office 365 para Business Intelligence. Descubre, analiza y visualiza datos en Excel, y comparte tus hallazgos a través de Office 365.
Many-to-Many Relationships in DAX
Explore advanced DAX techniques for handling many-to-many relationships in data modeling, with practical examples and insights into the Vertipaq engine's capabilities.
Tales from the Trenches - GUIDs - Use, Abuse and How to Move Forward
Explore GUID usage in databases, its impact on performance, and alternative solutions for efficient data handling and scalability in SQL Server environments.
What's New in SQL Server 2016 Analysis Services
Explore new features in SQL Server 2016 Analysis Services, including Extended Events, Tabular Mode enhancements, DAX functions, and Direct Query improvements for more powerful data analysis.
Adding Data Quality - Kimball Data Warehouse
Learn to enhance small to mid-size Kimball data warehouses with a design architecture for capturing, measuring, and relating data quality issues to existing fact and dimension tables.