24 Hours of PASS: Summit Preview 2015
2015-09-17
-- online --
who it's for
sql server database administrators, business intelligence developers, etl and ssis developers, data engineers, analytics engineers, database architects, site reliability engineers
topics
MDX querying with SSAS; distributed replay workload testing; AlwaysOn availability groups; Storage Spaces Direct and SMB; SQL Server 2016 high availability; SSIS package design and BIML generation; PowerShell enterprise scripting; columnstore and MPP data warehouse; Azure SQL Data Warehouse (pause compute); Hadoop integration with SQL Server; transaction encryption (TDE) performance; index internals: rowstore and columnstore
| title | author | length |
|---|---|---|
| Beginners Guide to MDX | Alex Whittles | 58m |
Explains MDX by showing live queries against the Adventure Works Cube using SQL Server Analysis Services and SQL Server Management Studio and tools like Excel… | ||
| Distributed Replay Testing with Your Data, Your Way! | Melody Zacharias | 50m |
Distributed Replay uses SQL Server 2012+ tools to capture a profiler trace, preprocess it into replay files, and synchronize execution across up to 16 clients… | ||
| What’s New for High Availability in SQL Server 2016... | Allan Hirt | 01h 00m |
Demonstrations show Windows Server 2016 allowing no domain join clusters for AGs (workgroup clusters with certificate setup) and a live AG built from VMs, plus… | ||
| How to be a Ninja Troubleshooting SQL performance... | Amit Banerjee | 59m |
Clear, actionable rules: use DS3 or higher for Enterprise (DS2 for Standard), put data and logs on separate disks and prefer P30 premium disks with read cache… | ||
| Building Better SSIS Packages | Tim Mitchell | 57m |
Explains concrete practices: use catalog logging and environments for built-in audit and sensitive-parameter handling, enable checkpoints for restartability… | ||
| Stress Inoculation: Maintaining Performance Under Pressure | Russ Thomas | 01h 00m |
Claims that acute outages become manageable through rehearsal and automation back up the advice: a prepared PowerShell log-folder restore and a checked script… | ||
| Leadership Without Borders: Working with Global Teams | Mike Hillwig | 55m |
Distinguishes outsourcing from offshoring, argues the real value is follow the sun support that boosts client response and quality, and lists concrete… | ||
| Hadoop Essentials for the SQL Server Professional | Bill Preachuk | 59m |
Claims Hadoop scales to multi‑petabyte warehouses and that hdfs uses three-way block replication for fault tolerance; demonstrates YARN/tez replacing old map… | ||
| Finding Your Balance: BI in the Cloud, On Premises, or Both | Joey D'Antoni | 59m |
Clear claims and concrete tools: powerbi desktop is free and updates monthly, with a powerbi Analysis Services connector and gateways enabling real-time… | ||
| The Enterprise Scripting Workshop | Sean McCown | 01h 00m |
Shows how PowerShell carrier method runs SQL scripts across servers and databases, using Import-Module/SQLPS and querying sys.databases to target names… | ||
| The Top 8 Reasons for Your Transaction Performance Problems | Margarita Naumova | 54m |
Lists eight concrete causes and fixes rather than vague examples: misconfigured max server memory and optimize for ad hoc workloads settings that blow plan… | ||
| Advanced Scripting Using SSIS Script Tasks and Components | John Welch | 56m |
Shows concrete scripts and working demos: an ordered file list using System.IO and LINQ that feeds a ForEach, a script component that caches instance fields to… | ||
| 50 Things All SQL Server Developers Need to Know | Aaron Bertrand | 01h 00m |
Covers fifty concrete tips across dev environment, schema design, T‑SQL and tuning including how to create a stats-only database to get realistic plans, how to… | ||
| SQL Server Internals: The Practical Angle | Dmitri Korotkevitch | 53m |
Shows concrete internals: how forwarding pointers created by updates inflate storage and push rows off extents, how deleting 50 index entries produces blocking… | ||
| 7 Tips to Performance Tuning, Optimization, and Everything | Pinal Dave | 01h 00m |
Seven concrete tactics and measured outcomes: converting scans to seeks with a covering index with INCLUDE; replacing functions with computed columns and… | ||
| Visualizing Data: the Good, the Bad, and the Ugly | Stacia Varga | 49m |
Argues that clear decisions beat buzzwords and demonstrates Excel, Power Query/PowerPivot, Power View, Power BI and Reporting Services on real export data… | ||
| Optimize “All Data” with a Modern Data Warehouse Solution | Bradley Ball | 57m |
Shows concrete, tested approaches: streaming pipeline using Azure Event Hubs -> Azure Stream Analytics -> Azure ML for live Twitter sentiment analysis and a… | ||
| Take the SQL Server Index Quiz! | Kendra Little | 57m |
Six quick, concrete takeaways: a nonclustered index’s key columns are subject to the 900 byte limit but included columns are not; applying a function to a key… | ||
| Upgrade and Migration Planning BI Features for SQL Server 2014 and 2016 | Paul Turley | 01h 00m |
Covers concrete upgrade paths: in-place vs side-by-side, which files and symmetric keys to back up, and gotchas when moving from 2005/2008 to sql server 2014… | ||
| Taking the Scare out of Monster Reports | Pam Shaw | 46m |
Shows concrete tactics to tame two kinds of monster reports: handling disparate data by creating a SQL control table (or CTE in an RDL) for ordering, formats… | ||
| Integrating SQL Server Analysis Services with Hadoop | Edwin Sarmiento | 01h 13m |
Shows a working pipeline that ingests IIS web logs into a Cloudera quickstart VM, creates Hive tables and views, and exposes that data to Analysis Services so… | ||
| Index Internals: RowStore, ColumnStore, and NoStore! | Kalen Delaney | 59m |
Explains precise behaviors and tradeoffs: rowstore = B‑tree leaves contain every data row, columnstore groups ~2^20 (~1,048,576) rows per row group and… | ||
| Building a Scalable Analytical Solution Using IaaS and Elasticsearch | Allan Mitchell | 57m |
Plans and outcomes focus on building a four‑node cluster on IaaS with ARM templates, installing Java, deploying Elasticsearch, opening port 9200, and using… | ||
| Hacking Exposé Too: Just How Transparent is TDE? | Chris Bell | 56m |
Demonstration shows rawcap and Wireshark capture plain SQL queries and email rows in transit, and a hex editor (XVI32) reveals plaintext credit‑card fields… | ||
| nothing matches | ||