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.
Every Byte Counts - Why Your Data Type Choices Matter
Explore how data type choices in SQL Server impact performance and storage efficiency. Learn best practices for optimizing database design and mitigating performance issues through informed data type selection.
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.
Rethink Your ETL with BIML
Revolutionize data warehousing with BIML: Learn to create templates for corporate standards and generate multiple packages efficiently, reducing weeks of SSIS development to hours.
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.
Making the Leap from Developer to DBA
Discover strategies for transitioning from developer to DBA, including essential skills and knowledge needed for success in database administration.
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.
Optimizing Your Data Warehouse for OLAP Processing
Optimize data warehouse processing for OLAP with SSAS best practices, enterprise features, and database engine alignment. Learn compression, partitioning, and file group strategies for 200%+ performance improvement.
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.
Planes de ejecución en SQL Server 2014
Aprenda a optimizar consultas SQL analizando planes de ejecución en SQL Server 2014. Mejore el rendimiento de su base de datos y resuelva cuellos de botella.
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.
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.
Fundamentos de los Bloqueos en SQL Server
Aprenda los conceptos esenciales de bloqueos en SQL Server para optimizar el rendimiento y la concurrencia de sus bases de datos.
Database Unit Testing
Learn effective techniques for database unit testing to improve code quality, catch errors early, and ensure reliable database functionality.