Data Pages, Allocation Units, IAM Chains Oh My!
Explore SQL Server's data organization, including row structure, data pages, and index types. Learn how understanding these internals can improve database design and performance.
Azure IOT - A Practical Introduction to Stream Analytics
Explore Azure Stream Analytics for real-time IoT data processing. Learn to capture, analyze, and present device data streams, integrating with Microsoft's IoT suite for business insights.
Common Table Expressions - Advanced
Explore advanced Common Table Expressions: recursive queries, hierarchical data, data manipulation, common use cases, performance considerations, and classic recursive algorithms in SQL Server.
Common SQL Server Mistakes and How to Avoid Them
Learn common SQL Server mistakes and best practices for installation, configuration, and support to optimize your environment and avoid critical errors.
Overlord Tracking Changes, Real Time, in Your Environment
Track database changes in real-time with Event Notifications. Learn to set up automated alerts, reports, and source control integration for immediate awareness of modifications, enhancing performance and security.
Turbo Charged Transaction Logs
Optimize SQL Server transaction log performance, prevent issues, and improve throughput. Learn about log structure, settings, and troubleshooting techniques for efficient database management.
Protecting Your Data with Encryption
Explore SQL Server's encryption methods to safeguard data from hackers. Learn about hashes, cell-level, database-level, and backup encryption, as well as key protection strategies.
Trend Analysis of SQL Error Logs - Seeing Beyond the Error
Learn to automate SQL error log parsing, centralize data storage, and create visual reports for trend analysis, leading to improved process efficiency and proactive problem-solving.
Introduction to Microsoft Azure DocumentDB
Learn to create and manage Azure DocumentDB instances, work with JSON documents, and develop application logic using JavaScript for efficient NoSQL database operations.
Improving Data Analytics with Azure Machine Learning
Explore Azure Machine Learning for data analytics, from data classification to model selection, integration, and deployment in Data Factory pipelines, enhancing decision-making and insights.
SQL Server 2014 - ¿Cómo crear soluciones de bases de datos híbridas
Aprenda a diseñar e implementar soluciones de bases de datos híbridas utilizando SQL Server 2014, combinando entornos locales y en la nube para optimizar el rendimiento y la escalabilidad.
SSAS multidimensional mejores prácticas
Aprende las mejores prácticas para optimizar el rendimiento y la eficiencia de SSAS multidimensional en este tutorial avanzado para profesionales de datos.
Patrones de busquedas aceleradas con Lookup entre periodos con Integration Services
Aprende técnicas avanzadas para optimizar búsquedas en Integration Services utilizando Lookup entre periodos, mejorando el rendimiento de tus procesos ETL.
Database Unit Testing
Learn effective techniques for database unit testing to improve code quality, catch errors early, and ensure reliable database functionality.
SQL Server 2014 Backup Encryption
Explore SQL Server 2014's backup encryption features, enhancing data security and protection for your database backups.
Catching the Butterfly in Data - Chaos or Patterns in the Data
Explore data analysis techniques, chaos theory, and pattern recognition in this webinar. Learn about Benford's Law, debt visualization, and advanced economic insights for business analysts.
Durabilidad diferida de transacciones y mejoras en gestión de bloqueos para tareas
Explora avances en durabilidad diferida de transacciones y gestión de bloqueos, optimizando el rendimiento y la eficiencia en sistemas de bases de datos.
ALM para el Desarrollo de Base de Datos SQL Server
Aprenda técnicas avanzadas de gestión del ciclo de vida de aplicaciones para optimizar el desarrollo de bases de datos SQL Server y mejorar la eficiencia del equipo.
AlwaysOn AG - What's New on SQL Server
Explore SQL Server 2014's enhancements to AlwaysOn Availability Groups and Failover Cluster Instances for improved high availability and disaster recovery solutions.
Novidades e Futuro de Azure SQL Database
Explore as novidades e o futuro do Azure SQL Database, incluindo as características da nova oferta que substituirá as edições Web e Business atuais, e teste as últimas atualizações do serviço.
SQL Server 2014 – New Feature – Delayed Transaction Durability
Explore os princípios ACID, WAL e a nova funcionalidade Delayed Durability Transaction no SQL Server 2014, com foco em melhorar o desempenho e a durabilidade das transações.