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.
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.
Machine Learning with SQL Server - From the Edge to the Cloud
Explore machine learning options in SQL Server ecosystem, from edge devices to cloud, covering training, testing, and operationalization for various workloads and design patterns.
The Battle of Cloud Data Warehouses - Snowflake, Synapse, and More
Explore cloud data warehousing solutions, comparing Snowflake, Synapse, Redshift, and BigQuery. Learn key principles, features, and how these platforms revolutionize data management and analysis.
DevOps - SSDT Makes Deployment Consistent
Learn to deploy database code consistently and accurately using Azure DevOps pipeline. Explore techniques for setting up database objects, including security and reports, for successful and repeatable deployments across different environments.
Guiding User Experiences With Advanced Reporting Features
Explore advanced Power BI features to enhance user experience: bookmark capture, button configurations, report tooltips, and measure-based formatting for improved report design and interactivity.
Lift and Shift Your SQL Servers to Azure SQL Virtual Machines
Learn best practices for migrating SQL Servers to Azure, including assessment, sizing, and data transfer. Discover cost-saving strategies, hybrid deployments, and tools for efficient Azure migration of existing SQL infrastructure.
PowerShell for DBA Beginners
Learn to automate SQL deployments and upgrades using PowerShell, starting with basics and progressing to multi-server scripts using JSON files.
Execution Plans - Where Do I Start?
Learn to read and understand SQL Server execution plans, crucial for optimizing query performance and troubleshooting slow queries. Discover how to obtain plans and interpret them effectively.
ORMs and the DBA - How to Keep Both Happy
Explore strategies to mitigate ORM-related issues, improve performance, and satisfy both developers and DBAs. Learn to audit SQL, optimize code, and use tools for better ORM implementation.
Pay Less, Get More - A Guide to SQL Server Licensing
Optimize SQL Server licensing costs with expert guidance on editions, models, and scenarios for virtual environments, high availability, and non-production setups.
App Modernization and Migration from End to End
Comprehensive guide to app modernization and data migration using Microsoft tools, focusing on SSIS to ADF and SQL Server to Azure SQL MI transitions with practical demonstrations.
Design Your Data Vault and Load It With Azure Data Factory
Explore Data Vault methodology for data warehouse design and learn how to populate it using Azure Data Factory's Mapping Data Flows, with insights on ETL patterns and practical implementation.
Unlock Business Value From Your SQL Server Backups as You Head to the Cloud
Discover how to seamlessly migrate SQL Server to the cloud while ensuring robust data protection. Learn about platform-independent backup solutions that enable data mobility and instant retrieval, unlocking business value from your backups.
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.
Understanding Accelerated Database Recovery
Explore SQL Server 2019's Accelerated Database Recovery feature, its mechanics, benefits, and implementation in on-premises and Azure environments for rapid recovery and instant transaction rollback.