SQL Bad Practices
Aprenda práticas inadequadas de SQL e como evitá-las para melhorar o desempenho e a manutenção de seus bancos de dados.
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#.
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.
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.
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.
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.
Query Optimizer Deep Dive
Explore advanced techniques for optimizing SQL queries, enhancing database performance, and mastering the intricacies of query execution plans with expert Paul White.
Bug or Feature?
Explore unique T-SQL behaviors, distinguishing between bugs and features while uncovering key principles of this relational language.
Seeking SQL Server Secrets
Explore hidden SQL Server features, traceflags, and DBCC commands. Learn techniques to uncover undocumented secrets and enhance your database administration skills.
Advanced R Analytics in SS2016 Using R Tools for Visual Studio
Explore advanced R analytics using R Tools for Visual Studio, covering predictive modeling, data access, parallelization, and integration with SQL Server for improved performance and efficiency.
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.
Keep Your SQL Code Protected with GIT
Aprenda a proteger seu código SQL usando GIT e SSDT para gerenciar versões, detectar mudanças, revisar código e implantar em ambientes sem estresse.
Bad Designs Have Consequences
Explore real-world SQL database design pitfalls, their consequences, and learn from 15 years of experience to avoid common mistakes and improve your database architecture.
Packaging Permissions in Stored Procedures
Learn advanced techniques for fine-grained permission control in SQL Server stored procedures, including certificate signing and EXECUTE AS. Discover how to securely grant privileged actions without compromising overall database security.
Secure SQL Server Database Design - Tactics and Technology
Strategies for designing secure SQL Server databases, covering table design, roles, and built-in security features like Always Encrypted and Row-Level Security.
Cosmic DB - Cosmos DB for SQL Server Admins and Developers
Explore Cosmos DB's NoSQL approach, indexing, consistency levels, and JSON design for SQL professionals. Learn to leverage schema-free advantages and optimize query patterns in document-based databases.
Spatial Analysis with SQL Server, R and Power BI
Discover the power of spatial analysis using SQL Server, R, and Power BI. Learn to analyze location-based data, make informed decisions, and create compelling visualizations for real-world applications.
Identifying Anti-Patterns in Analytical Queries
Learn techniques to optimize SQL-based analytical queries, restructure jobs, and eliminate performance bottlenecks. Improve efficiency and deliver results faster across various data tools and platforms.
CosmosDB - Designing and Troubleshooting Lessons
Learn to design, query, and troubleshoot high-performance Cosmos DB solutions through hands-on labs covering partition design, SQL API querying, and request optimization techniques.