Azure SQL Database: Grouping Sets and Windowing Functions for Developers
Explore Grouping Sets and Windowing Functions in Azure SQL Database to enhance code efficiency and solution performance. Learn practical tips for developers to leverage these powerful features.
Workarounds for T-SQL Restrictions and Limitations
Aprenda técnicas criativas para superar limitações do T-SQL, incluindo cálculos de mínimo/máximo entre colunas, números de linha únicos e reutilização de aliases, com o especialista Itzik Ben-Gan.
Building Your T-SQL Tool Kit - Window Function Fundamentals
Explore T-SQL window functions to enhance data analysis skills, improve query performance, and solve complex business problems efficiently.
10 Dicas para Escrever Codigos T SQL Melhores
Aprenda 10 dicas essenciais para aprimorar seus códigos T-SQL, melhorando a eficiência e qualidade das suas consultas e procedimentos armazenados.
Offline Database Development and Unit Testing with SSDT
Explore offline database development, unit testing, and customization in SQL Server Data Tools. Learn to create test projects, write T-SQL unit tests, and extend functionality with C#.
New Features and Capabilities
Explore new features and capabilities of Appliance Update 2, covering T-SQL to HDInsight, enhancing your SQL Server knowledge and skills.
Using Data to Make Decisions
Learn practical techniques for leveraging data to simplify complex decisions, from buying cars to choosing healthcare, using precision questions, machine learning, and common tools like Excel and T-SQL.
Bug or Feature?
Explore unique T-SQL behaviors, distinguishing between bugs and features while uncovering key principles of this relational language.
Common Data Science Mistakes
Explore common pitfalls in data science, from data preparation to analysis. Learn to avoid mistakes in statistics, outlier handling, and visualization for more accurate insights and predictions.
Improving Database Code Quality with Unit Tests
Learn to implement unit testing for T-SQL code, enhancing database quality. Discover tools and techniques for automated testing, test-driven design, and integrating tests into your development workflow.
Azure DevOps Pipelines for BI
Learn to implement DevOps practices for SQL databases, Analysis cubes, and SSIS packages using Azure DevOps Pipelines. Discover techniques for code tracking, compile-time checking, and efficient deployments.
Increase Deployment Flexibility with Feature Flags
Learn to use feature flags for flexible database deployments, enabling dark deployments and reducing production impact. Includes T-SQL code examples and demonstrations of implementation in deployment processes.
Getting Started with Azure Data Studio
Learn to use Azure Data Studio: customize, create insights, use extensions, work with notebooks, and develop your own extensions. Master this cross-platform tool for data-related tasks and T-SQL editing.
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.
Unlocking The Data Lake With Azure Synapse SQL Serverless
Explore and transform massive data in Azure data lakes using SQL Serverless for Synapse. Learn to leverage T-SQL for analytics, BI, and ML at petabyte scale.
Developer Best Practices in SQL Server
Learn optimized T-SQL coding techniques for SQL Server, including Sarg-ability, performance improvement, SQL injection prevention, parameterization, and dynamic SQL best practices through real-world examples.
From Docker to Big Data Cluster - A New Era for SQL Server
Explore SQL Server's evolution from Docker support to Big Data Clusters, covering containerization, Kubernetes deployment, and integration with Python for modernized database management and analytics.
Get Your Optimizer to Give Up All Its Secrets
Uncover SQL Server's query optimization process, from parsing to rule application. Learn to analyze parse trees and memos for more efficient T-SQL writing and improved query performance.
Data Warehouse Automation Using Agile Methods
Explore agile data warehouse development using Data Vault design and metadata-driven automation for faster delivery, flexible architecture, and improved documentation in business intelligence projects.
Introducing SQL Server 2022
Explore SQL Server 2022's new features: cloud connectivity, disaster recovery, analytics, security enhancements, and T-SQL extensions. Learn about Intelligent Query Processing and SQL Server Ledger with live demos and expert Q&A.
Introduction to Kusto
Explore Kusto for interactive Big Data analytics on Azure. Learn advanced querying, monitoring, and debugging techniques used at DocuSign through practical examples and demonstrations.