Nr: 403
SQLSaturday #403 - Louisville 2015
SessionID: 12355
CSI: DW -- Anatomy of a VLDW!
Event Date: 22-08-2015 - Session time: 08:00:00 - Track: BI
Speaker: Dave Fackler
Title: CSI: DW -- Anatomy of a VLDW!
Abstract:
SessionID: 13489
How In-Memory Database Objects Affect Database Design
Event Date: 22-08-2015 - Session time: 08:00:00 - Track: Advanced DBA
Speaker: Louis Davidson
Title: How In-Memory Database Objects Affect Database Design
Abstract:
SessionID: 24600
How to Determine What Data Is Corrupt
Event Date: 22-08-2015 - Session time: 08:00:00 - Track: Advanced DBA
Speaker: Frank Gill
Title: How to Determine What Data Is Corrupt
Abstract:
There are two kinds of DBAs in the world -- those who have experienced corruption, and those who will. Join me for this session to learn what corruption is, how it can occur, and how to check if your data is corrupt. And if you do find corruption, I will show you how to identify what data is affected using DBCC CHECKDB and DBCC PAGE.
SessionID: 37105
Availability Groups 101: An Introduction
Event Date: 22-08-2015 - Session time: 08:00:00 - Track: DBA
Speaker: Adam Belebczuk
Title: Availability Groups 101: An Introduction
Abstract:
SessionID: 37250
Branding Yourself for a Dream Job
Event Date: 22-08-2015 - Session time: 08:00:00 - Track: Professional Development
Speaker: Steve Jones
Title: Branding Yourself for a Dream Job
Abstract:
Everyone wants a dream job that they enjoy going to each week. However finding that job, and getting yourself hired can be hard for most people. Steve Jones will give you practical tips and suggestions in this session that show you how to better market yourself, how to get the attention of employers, and help improve the chances that the job you want will get offered to you. Learn about networking, blogging, and more.
SessionID: 38265
14 Features in SQL Server 2014 You Haven't Considered
Event Date: 22-08-2015 - Session time: 08:00:00 - Track: DBA
Speaker: Tony Milne
Title: 14 Features in SQL Server 2014 You Haven't Considered
Abstract:
SQL Server 2014 was released in early 2014. Since then, most are struggling to understand why they should upgrade. This talk will uncover 14 features in SQL 2014 that you may have not thought of. Including in-memory tables, hybrid cloud environments, BI enhancements, and others. After this talk you'll be armed with the knowledge to take full advantage of the amazing improvements in SQL Server 2014.
SessionID: 28134
Getting Started with MDX
Event Date: 22-08-2015 - Session time: 09:15:00 - Track: BI
Speaker: William E Pearson III
Title: Getting Started with MDX
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
SessionID: 36585
Introduction to Wait Types and Response Time Analysis
Event Date: 22-08-2015 - Session time: 09:15:00 - Track: DBA
Speaker: Janis Griffin
Title: Introduction to Wait Types and Response Time Analysis
Abstract:
SessionID: 37604
SQL Server In-Memory OLTP Index Internals
Event Date: 22-08-2015 - Session time: 09:15:00 - Track: Advanced DBA
Speaker: Tim Chapman
Title: SQL Server In-Memory OLTP Index Internals
Abstract:
SessionID: 37994
SQL Server and PowerShell: Let's Get Serious
Event Date: 22-08-2015 - Session time: 09:15:00 - Track: Powershell
Speaker: Drew Furgiuele
Title: SQL Server and PowerShell: Let's Get Serious
Abstract:
Whether you've dabbled in PowerShell or wondered what all the fuss is about, make no mistake: PowerShell is something worth learning to make your life as a SQL Server professional easier. Whether you're a DBA, a SSIS developer, or security professional, In this session you'll see practical, real world examples of how you can blend SQL Server and PowerShell together, and not just a bunch of regular T-SQL tasks that have been made more complicated.
SessionID: 38286
Event Date: 22-08-2015 - Session time: 09:15:00 - Track: BI
Speaker: Kenney Snell
Abstract:
Which objects within your SSAS cubes or models are consuming the most CPU? Which objects are using the most memory? What MDX query is running the longest? What are the top 10 MDX queries consuming resources? Which objects (dimensions or facts) are having the most cache misses? Which of your measure groups are having the most aggregation misses.
You could be the hero of your BI group in recommending changes to the cube or model structures and in planning when to purchase more memory or storage. By using SSAS Dynamic Management Views (DMVs) or using PowerShell scripts to collect statistics on SSAS Performance Counters, you can easily build charts and reports to identify resource bottlenecks in your SSAS cubes and models.
Both SSAS multidimensional cubes and Tabular models consume system resources differently; but you can collect data and store performance statistics in SQL tables to build your performance monitoring solution for both types.
SessionID: 38322
A Day in the Life of a Row: Internals Deep Dive
Event Date: 22-08-2015 - Session time: 09:15:00 - Track: Advanced DBA
Speaker: Eddie Wuerch
Title: A Day in the Life of a Row: Internals Deep Dive
Abstract:
Attend this advanced session and you will be able to: * View and interpret raw data and metadata with DMVs, XEvents, and DBCC commands, including some undocumented ones (all demo scripts included in session download) * View and describe, with precise details, exactly what data and metadata actions any given query took, and, * Attack and destroy query performance problems with some neat new weapons.
SessionID: 10863
Using Extended Events in SQL Server
Event Date: 22-08-2015 - Session time: 10:30:00 - Track: Advanced DBA
Speaker: Jason Brimhall
Title: Using Extended Events in SQL Server
Abstract:
SessionID: 13706
Introduction to SQL Server Integration Services
Event Date: 22-08-2015 - Session time: 10:30:00 - Track: BI
Speaker: Ed Watson
Title: Introduction to SQL Server Integration Services
Abstract:
Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!
SessionID: 17227
What's your Character Type?
Event Date: 22-08-2015 - Session time: 10:30:00 - Track: DBA
Speaker: John Deardurff
Title: What's your Character Type?
Abstract:
This session focuses on what you need to know about working with SQL Server Data Types. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter will focus on the differences between character data types, working with implicit vs. explicit conversions and using conversion functions.
SessionID: 37252
Continuous Integration for Databases
Event Date: 22-08-2015 - Session time: 10:30:00 - Track: Developer
Speaker: Steve Jones
Title: Continuous Integration for Databases
Abstract:
SessionID: 38239
Powershell and the Art of SQL Server Deployment
Event Date: 22-08-2015 - Session time: 10:30:00 - Track: Powershell
Speaker: Michael Fal
Title: Powershell and the Art of SQL Server Deployment
Abstract:
SessionID: 38308
Table Vars and Temp Tables – What you NEED to Know!
Event Date: 22-08-2015 - Session time: 10:30:00 - Track: DBA
Speaker: Wayne Sheffield
Title: Table Vars and Temp Tables – What you NEED to Know!
Abstract:
Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, "When do I use one or the other and what are the various impacts of doing so?"
SessionID: 37996
Microsoft Analytics - Any Data and Anywhere
Event Date: 22-08-2015 - Session time: 11:45:00 - Track: Big Data/Cloud
Speaker: Madhu Desarapu
Title: Microsoft Analytics - Any Data and Anywhere
Abstract:
During this session, you will learn Microsoft Analytics strategy to empower businesses to gain insights into their data . This will help you to understand Microsoft SQL Server Data Analytics components and Microsoft Azure Cloud Services which will help to analyze structured and unstructured data either on Premise or in the Azure.
SessionID: 39944
Event Date: 22-08-2015 - Session time: 11:45:00 - Track: DBA
Speaker: Argenis Fernandez
Abstract:
SessionID: 40142
The Infrastructure Admin/DBA Relationship
Event Date: 22-08-2015 - Session time: 11:45:00 - Track: DBA
Speaker: Brent Earls
Title: The Infrastructure Admin/DBA Relationship
Abstract:
Storage
-How much data is actually hot and what does that mean for disk performance?
-The performance characteristics of the different storage sources
-Performance implications of full re-index
-SSD proper usage and placement – pros and cons
Virtualiztaion
CPU
Memory
Storage
Why would you?
Licensing
High level overview
SessionID: 12259
Database: The Motion Picture
Event Date: 22-08-2015 - Session time: 13:00:00 - Track: Big Data/Cloud
Speaker: Dave Mattingly
Title: Database: The Motion Picture
Abstract:
Power up your data presentations with Power View and Power Map. Charts and maps can be made interactive, generated on the fly, or recorded as video with a soundtrack and special effects. Instead of trying to make your point with a boring list of names, numbers, and dates, put on your movie director's hat and give your data the Hollywood treatment as you yell, "Lights! Cameras! Action!"
SessionID: 27835
Read Dirty to Me - Isolation Levels/User Impact
Event Date: 22-08-2015 - Session time: 13:00:00 - Track: DBA
Speaker: Wendy Pastrick
Title: Read Dirty to Me - Isolation Levels/User Impact
Abstract:
Issue a "SELECT {data} FROM {myTable}" statement and users need to trust the data returned is accurate. What happens when multiple processes access the same data? What happens further if one of those process is an UPDATE or even a DELETE statement? How about if both processes will be updating that data? Understanding Isolation in SQL Server is paramount in ensuring data integrity in your system. We will cover the different levels of isolation and how they impact what a user views when accessing the data at a given point-in-time.
SessionID: 36279
Who needs SSAS when you've got SQL?
Event Date: 22-08-2015 - Session time: 13:00:00 - Track: BI
Speaker: Meagan Longoria
Title: Who needs SSAS when you've got SQL?
Abstract:
For SQL and .NET developers, Analysis Services may seem foreign or unnecessary, but it can offer many advantages for reporting and data exploration. In this session, we will cover useful features of SSAS and discuss conditions where it is beneficial. Next we'll compare the two types of Analysis Services databases (Multidimensional and Tabular) and cover how to decide which type is right for your solution. Then we will explore common ways to retrieve data and browse your SSAS database such as Excel, Power BI, SSRS, and custom .NET applications.
SessionID: 37018
Spatial Data - Looking Outside the Map
Event Date: 22-08-2015 - Session time: 13:00:00 - Track: Advanced DBA
Speaker: Hope Foley
Title: Spatial Data - Looking Outside the Map
Abstract:
I've said it before and I'll say it again, spatial data doesn't get much love in SQL Server. It is a feature worthy of much appreciation and will become more vital as more location data is collected. In this session we will explore spatial data and discover many ways it can be used for incredible analytics. You will learn some new ways to visualize your data outside of the typical plots on a Bing map layer. Come and learn how powerful spatial data can be even though it lacks a snazzy "power" title.
SessionID: 38224
Data Analysis With SQL Window Functions
Event Date: 22-08-2015 - Session time: 13:00:00 - Track: Developer
Speaker: Adam McDonald
Title: Data Analysis With SQL Window Functions
Abstract:
SQL Window Functions provide a great way to aggregate and analyze data very efficiently. In this session we'll go over what functions are available and look at many examples of how to use them. When you leave you'll be familiar with the concept and will be able to recognize situations where they can be extremely useful.
SessionID: 38238
Powershell Tips and Tricks for SQL Server Administration
Event Date: 22-08-2015 - Session time: 13:00:00 - Track: Powershell
Speaker: Michael Fal
Title: Powershell Tips and Tricks for SQL Server Administration
Abstract:
SessionID: 38296
SSIS Project Deployment Model: Deployment and maintenance
Event Date: 22-08-2015 - Session time: 13:00:00 - Track: Developer
Speaker: Bill Fellows
Title: SSIS Project Deployment Model: Deployment and maintenance
Abstract:
In this session, you'll learn everything you need to know to successfully deliver a modern SSIS solution. We'll cover the mechanics of deployment; creation, configuration and migration of Environment variables; monitoring execution troubleshooting.
SessionID: 24572
SQL Server 2014 Cardinality Estimator changes
Event Date: 22-08-2015 - Session time: 14:15:00 - Track: DBA
Speaker: Sreeni Julakanti
Title: SQL Server 2014 Cardinality Estimator changes
Abstract:
This session covers the changes made to Cardinality Estimations and Calculations in SQL Server 2014.
SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance.
Topics Covered in this session
How to enable and disable the new cardinality estimator behavior?
What changed in new cardinality estimations?
How to troubleshoot plan-quality regressions if and when they occur?
Note : Presentation based on recent white paper released from Microsoft.
SessionID: 27580
Leveraging CDC and SSIS for ODS/DM/DW Loads
Event Date: 22-08-2015 - Session time: 14:15:00 - Track: BI
Speaker: Warren Sifre
Title: Leveraging CDC and SSIS for ODS/DM/DW Loads
Abstract:
SessionID: 36116
Event Date: 22-08-2015 - Session time: 14:15:00 - Track: Developer
Speaker: Mickey Stuewe
Abstract:
SessionID: 37289
Advanced Troubleshooting Your SQL Connections
Event Date: 22-08-2015 - Session time: 14:15:00 - Track: DBA
Speaker: Mike Hays
Title: Advanced Troubleshooting Your SQL Connections
Abstract:
Often in supporting SQL Server, we are asked to troubleshoot why a user or application cannot connect. It becomes more challenging when we find nothing is wrong with the way SQL Server is running. In this session we review common mistakes to the configuration of network settings. We’ll also show how to troubleshoot the SQL Server Browser. We’ll cover how to test for firewall issues. Finally we’ll discuss why SQL Server is blamed for dropping its connections.
SessionID: 37376
Getting Started With SQL Server Replication
Event Date: 22-08-2015 - Session time: 14:15:00 - Track: DBA
Speaker: Robert Verell
Title: Getting Started With SQL Server Replication
Abstract:
SessionID: 37405
Treating Tables Like Legos, Partitioning Basics
Event Date: 22-08-2015 - Session time: 14:15:00 - Track: Advanced DBA
Speaker: Brandon Leach
Title: Treating Tables Like Legos, Partitioning Basics
Abstract:
SessionID: 13329
Turbo-Charged Transaction Logs
Event Date: 22-08-2015 - Session time: 15:30:00 - Track: Advanced DBA
Speaker: David Maxwell
Title: Turbo-Charged Transaction Logs
Abstract:
The transaction log is one of the most critical, yet often mis-understood components
of SQL Server. From out of control log growth to very long startup times, problems with the
transaction log can cause a lot of pain. In this session, we'll look at how the transaction log
works and how to optimize it's performance. You'll learn how to determine the right settings
for maximum throughput, and what to do when things get out of control.
SessionID: 37341
Beginners SQL Server Security the Low Hanging Fruit
Event Date: 22-08-2015 - Session time: 15:30:00 - Track: DBA
Speaker: Lindsay Clark
Title: Beginners SQL Server Security the Low Hanging Fruit
Abstract:
Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA's can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA's are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.
SessionID: 37756
Keys to Successful SharePoint Administration for the DBA
Event Date: 22-08-2015 - Session time: 15:30:00 - Track: DBA
Speaker: Daniel Glenn
Title: Keys to Successful SharePoint Administration for the DBA
Abstract:
SessionID: 38190
Event Date: 22-08-2015 - Session time: 15:30:00 - Track: Advanced DBA
Speaker: Justin Randall
Abstract:
SessionID: 38268
Revenge: The SQL! - Director's Cut
Event Date: 22-08-2015 - Session time: 15:30:00 - Track: Advanced DBA
Speaker: Rob Volk
Title: Revenge: The SQL! - Director's Cut
Abstract:
Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?
Hint: You attend Revenge: The SQL!
This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!
Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.
SessionID: 38297
What is Biml and why are SSIS people talking about it?
Event Date: 22-08-2015 - Session time: 15:30:00 - Track: BI
Speaker: Bill Fellows
Title: What is Biml and why are SSIS people talking about it?
Abstract:
This session is designed for you, the experienced SSIS developer who's been hearing about Biml but hasn't taken the plunge. We will cover what Biml is and walk through some examples from Hello World equivalent to a fully baked truncate and reload pattern. You will leave this session armed with the knowledge of how Biml can help you achieve a consistent and reproducible approach for the creation of SSIS solutions.