Designing Azure Data Science and AI Projects
Aprenda a diseñar proyectos de ciencia de datos e IA en Azure, desde la comprensión del negocio hasta la implementación, utilizando un enfoque práctico basado en equipo y las últimas tecnologías disponibles.
One Bite at a Time
Efficient techniques for anonymizing PII data, archiving old data, and performing garbage collection in databases. Learn to create procedures for updating large datasets while maintaining performance and avoiding blocking operators.
Embracing Database DevOps through CI/CD
Learn to implement Database DevOps using SQL Server containers, Flyway, Kubernetes, and Azure DevOps. Explore strategies for efficient database migrations and build your first CI/CD pipeline for database deployment.
Securing Your Data in Azure - Tips and Tricks
Comprehensive guide to Azure security features, covering SQL Database, Key Vault, blob storage, CosmosDB, and Power BI. Learn to protect data, manage access, and implement best practices for secure data handling in Azure.
Deploying SQL Server Big Data Clusters
Learn to deploy SQL Server Big Data Clusters, demystify Kubernetes, and compare on-prem vs cloud deployments. Gain practical tools and scripts for immediate implementation.
Surprising Setbacks for Data Modernization and Azure Migration
Explore common setbacks in data modernization and Azure migration, covering strategies, planning, cost forecasting, performance monitoring, and team composition for successful projects.
Navigate Your Big Data Journey with AWS Big Data Services
Comprehensive guide to AWS big data services, covering data ingestion, warehousing, analysis, and visualization using tools like Jupyter notebooks and Amazon Redshift for effective data lifecycle management.
Data Modeling and Partitioning Patterns in Azure Cosmos DB
Explore key strategies for effective data modeling and partitioning in Cosmos DB, using real-world examples to optimize performance and scalability in NoSQL database design.
Data Analysis with Spark and Databricks in Azure Synapse
Comparing Spark and Databricks in Azure Synapse: use cases, costs, data types, processing volumes, and implementation demos. Learn when to choose Spark-based tools vs. alternatives like SQL on-demand or ELT.
Best Practices for Deployment of SQL Server on Azure Virtual Machines
Optimize SQL Server deployment on Azure VMs: right-sizing, high availability, performance, migration, disaster recovery, and licensing for Windows and Linux environments.
Dialogue with Your Data - Interactive AI with Cognitive Services
Explore Azure Cognitive Services for enhanced communication, language translation, and customer support analysis. Learn practical applications of Language and Speech APIs for immediate implementation.
Common Data Service - Why Is It Not Common Yet?
Explore Common Data Service's strengths and weaknesses in the Power Platform. Learn to build, ingest, and extract data through demos, understanding its role in centralizing business logic across applications.
Machine Learning, Artificial Intelligence, and Deep Learning Explained
Explore AI, ML, and DL with Buck Woody: learn key differences, use-cases, and implementation options, including SQL Server platform technologies.
Building a Security Dashboard for SQL Server
Learn to create a Power BI security dashboard for SQL Server, monitoring crucial security data and changes to ensure robust protection of your database systems.
A Self-Tuning Fill Factor Technique for SQL Server
Discover a technique for optimizing SQL Server index fill factors, reducing fragmentation and bad page splits, leading to significant performance improvements in OLTP databases.
Localizing Reports in Power BI
Learn to localize Power BI reports, including content translation, currency conversion, and language settings for global audiences. Explore options for multi-language support and automated translation using Azure Cognitive Services.
What's Your Bacon Number - An Introduction to Graph Databases
Explore graph databases using IMDB data to calculate Bacon Numbers. Learn graph theory, database types, and practical applications with Azure Cosmos DB and Gremlin API.
Standardize Your Environments Leveraging Infrastructure As Code
Explore methodologies for standardizing SQL Server deployments, identify gaps, and learn how Infrastructure as Code tools like Terraform can enhance and streamline your environment setup.
Migrating SQL Servers to AWS
Learn to migrate SQL Servers to AWS efficiently, exploring deployment options, migration strategies, and best practices for system sizing, security, and automation. Discover how to modernize workloads using cloud-native AWS databases.
DAX Studio
Explore DAX Studio with its creator, learning to profile and diagnose query and model performance issues through live demos of core features and practical applications.
Maximize Performance for Less Cost Using Azure SQL Database Serverless
Learn to optimize Azure SQL Database serverless for intermittent workloads, automatically scaling resources and improving cost-efficiency while simplifying performance management.