Using Amazon's Cloud for the SQL Server Professional
Explore Amazon Web Services for SQL Server pros: EC2, S3, RDS, NoSQL, and more. Learn to leverage cloud storage, virtual machines, and PaaS solutions for efficient data management and processing.
Introduction to Data Mining in SQL Server Analysis Services
Learn to create and integrate data mining models in SQL Server Analysis Services for customer prediction, marketing optimization, and forecasting using various algorithms and tools.
End-to-End SQL Server PowerPivot
Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative business intelligence within familiar Microsoft tools.
Developing and Managing a Business Intelligence Semantic Model in SQL Server Analysis Services
Learn to create, manage, and troubleshoot BI Semantic Models using SQL Server "Denali" features, with PowerPivot as a starting point for enhanced business intelligence capabilities.
PowerPivot - A Cool Reporting Tool
Explore PowerPivot for Excel to combine diverse data sources, create analytics, and overcome Excel limitations. Learn to import, pivot, and visualize data for self-service business intelligence.
Reporting with Crescent - Your Organization's Got Talent
Become a Crescent hero and delight business users with beautiful, meaningful self-service reporting for your organization.
More DBA Mythbusters
Debunking SQL Server myths and misconceptions, covering data compression, file management, isolation levels, checkpoints, logging, recovery, and more for improved database administration.
Many-to-Many Relationships in DAX
Explore advanced DAX techniques for handling many-to-many relationships in data modeling, with practical examples and insights into the Vertipaq engine's capabilities.
Bug or Feature?
Explore unique T-SQL behaviors, distinguishing between bugs and features while uncovering key principles of this relational language.
Beyond the Hype - Hybrid Solutions for On-Premise and In-Cloud Database Applications
Explore hybrid architectures combining on-premise and cloud databases. Learn decision-making strategies, Azure technologies, and component options for extending applications securely and efficiently.
End-to-End SQL Server PowerPivot
Explore SQL Server PowerPivot add-ins for Excel and SharePoint, enabling large-scale data analysis, multidimensional modeling, and collaborative BI solutions with scheduled data refreshes and IT management.
What's New in Security for SQL Server Code Name "Denali"
Explore advanced security enhancements in SQL Server "Denali", including Audit improvements and enhanced manageability, to better protect against data breaches and meet compliance regulations.
Top 10 Things You Didn't Know About SSIS in SQL Server Code Name "Denali"
Explore SSIS improvements in SQL Server "Denali": enhanced developer experience, project & parameter model, server-based deployment, and hundreds of customer-reported fixes for highest quality release.
Query Tuning Mastery - Zen and the Art of Workspace Memory
Explore advanced query tuning techniques, focusing on workspace memory optimization for improved performance and scalability in SQL Server. Learn monitoring, query hints, and memory internals for complex queries.
What Happened? Exploring the Plan Cache
Explore SQL Server's plan cache to identify problematic queries and performance issues. Learn tools and techniques for analyzing cached plans, their lifespan, execution frequency, and potential optimization opportunities.
DBA Mythbusters
Debunking common SQL Server myths and misconceptions, covering topics like non-logged operations, corruption risks, MAXDOP settings, and table-scan behaviors. Gain accurate insights for better database management and maintenance.
Inside Tempdb
Dive deep into SQL Server's tempdb internals with expert Bob Ward. Explore memory structures, classes, and bitmaps for practical insights to optimize tempdb usage and avoid common issues.
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.
You're Not Attractive - But Your Presentations Can Be
Learn presentation techniques from industry experts to create engaging and impactful talks, regardless of your appearance or charm. Discover tips and tricks to elevate your presentation skills.
Inside SQL Server Latches
Explore advanced SQL Server internals, focusing on latches for critical operation synchronization. Gain insights into internal data structures and advanced diagnostics for optimizing database performance.
Tales from the Trenches - GUIDs - Use, Abuse and How to Move Forward
Explore GUID usage in databases, its impact on performance, and alternative solutions for efficient data handling and scalability in SQL Server environments.