What's New in SQL Server 2016 Analysis Services
Explore new features in SQL Server 2016 Analysis Services, including Extended Events, Tabular Mode enhancements, DAX functions, and Direct Query improvements for more powerful data analysis.
Cross-Platform SQL Server Management - Taming Infrastructure and Application Usage
Learn to monitor SQL Server instances using extended events, capturing data for CPU utilization, resource usage, and performance analysis. Gain insights into best practices and practical implementation techniques.
Choosing the Wrong Isolation Level Causes Bad Results
Learn about SQL Server isolation levels, focusing on read committed, to understand their impact on query results and prevent data inconsistencies in concurrent transactions.
Azure Data Lake - Summit Preview
Explore Azure Data Lake technologies, their benefits, challenges, and implementation strategies for effective big data storage, processing, and analysis in the cloud.
Hackers Move Away, We Are Always Encrypted - Data Security
Explore Always Encrypted in SQL Server, its implementation, advantages, and comparison with other security technologies. Learn about key management roles and RDBMS security features across editions.
Migrating to SQL Server 2017
Explore efficient methods for migrating data to SQL Server 2017, optimizing hardware and licensing costs while meeting key objectives. Learn from expert Glenn Berry's insights.
Prepare for Change, Because It's Coming
Explore 45 years of data technology evolution and learn strategies to drive your career forward in this rapidly changing field.
The Real Self-Tuning Database
Explore SQL Server 2019's self-tuning features, including adaptive query processing and automatic plan regression fixes, to optimize database performance and efficiency.
Modernize Data Platform
Explore key considerations and implementation approaches for migrating on-premise databases to Azure, setting up a modern data platform, and utilizing Azure Database Migration Service.
Indexes - Are Things That Different to Twenty Years Ago
Explore key indexing features and game-changing developments in database technology over the past two decades with Rob Farley's insightful analysis.
Modernizing SQL Server
Explore free Microsoft tools for successful SQL Server upgrades, covering compatibility, migration, assessment, and optimization strategies for modernizing your database infrastructure.
End of Support for SQL Server 2008R2 - 20 Years of PASS
Detailed guide on migrating SQL Server 2008/R2 to Azure, covering migration lifecycle, tools, and strategies for near-zero downtime transitions as end-of-support approaches.
Intelligent Query Processing in SQL Server 2019 - Modernizing Your Data Platform
Explore groundbreaking query performance enhancements in SQL Server 2019's Intelligent Query Processing, revolutionizing data platform modernization and boosting efficiency.
Masking Sensitive Data - The New World of Data Privacy
Practical demonstration on automatically masking and refreshing sensitive data in database copies for developers, enhancing data privacy and security in SQL environments.
Help! SQL Server 2008 is Still Here
Learn strategies to convince management to upgrade from unsupported SQL Server 2008, addressing concerns and highlighting benefits of newer versions for improved performance and security.
Modernizing SQL Server the Right Way
Discover efficient SQL Server modernization strategies, from assessing upgrade readiness to optimizing performance using free Microsoft tools. Learn about compatibility, deprecated features, and post-migration best practices.
SQL Server Security Basics - Security
Learn SQL Server database security essentials, including permissions, principals, and best practices. Gain practical knowledge to protect your company's valuable data and manage security effectively.
You Should Use Column Store but
Explore column stores for efficient data handling, from creation to optimization. Learn from common mistakes and best practices to implement effective designs from the start.
Analytics on AWS
Explore AWS analytics services like Data Migration, S3, Athena, and QuickSight. Learn to build cloud-based analytics solutions using Amazon's infrastructure, platform, and software services.
Deadlocking for Mere Mortals
Explore common SQL Server deadlocks, their causes, and troubleshooting methods using various tools like Trace Flags, SQL Trace, Event Notifications, and Extended Events.
Azure Data Security
Explore Azure's data security tools: encryption, masking, threat protection, and more. Learn to safeguard your data assets effectively in the cloud environment.