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.
Techniques to Beautiful Data Insights with R and SSRS
Discover five powerful techniques for creating stunning data visualizations using R and SQL Server Reporting Services, enhancing your ability to derive meaningful insights from data.
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.
A Gentle Introduction to Data Analytics in SQL Server 2016
Explore data analytics using SQL Server 2016, comparing it to BI and data science. Learn to organize data, use Power BI, R, and Analysis Services for exploration and visualization techniques.
Predictive Analytics Using R and SQL
Explore predictive analytics concepts, applications, and integration with BI environments. Learn data science processes, methodologies, and practical techniques using R and SQL for effective predictions.
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.
Tips and Tricks for Using SQL Server Management Studio Effectively
Discover essential tips and tricks to enhance your productivity with SQL Server Management Studio, covering features like object explorer, scripting, query plans, and multi-server management.
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.
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.
A Game of Hierarchies - Graph Processing with SQL Server 2019
Explore hierarchies and graph processing in SQL Server 2019 using "Game of Thrones" examples. Learn best practices for transforming complex data structures into useful information.
SQL and MongoDB - When Two Worlds Collide
Explore hybrid SQL-NoSQL solutions, focusing on integrating MongoDB with SQL Server. Learn scenarios, implementation techniques, and performance considerations for leveraging strengths of both database types.
What's New in Security for Azure SQL - MI
Explore cutting-edge Azure SQL security innovations, including network security, authentication, data encryption, and management. Gain insights into new customer scenarios and opportunities unlocked by these technologies.