Nr: 287
SQLSaturday #287 - Madison 2014
SessionID: 10221
Be Friendly to SQL Server with TSQL Best Practices
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Ben Miller
Title: Be Friendly to SQL Server with TSQL Best Practices
Abstract:
This session will take a look at things that you should regularly know and use when coding TSQL. How can you be really friendly to SQL? The items covered will show you things that will help ensure that your code is readable, efficient and maintainable. We will look at query semantics, datatypes, things to avoid as well as how to be super friendly to the SQL Engine and allow things to work well.
SessionID: 10445
SSIS development is done: now what? Deployment, migration, maintenance and troubleshooting
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Bill Fellows
Title: SSIS development is done: now what? Deployment, migration, maintenance and troubleshooting
Abstract:
After attending this session, you will have the knowledge to care and maintain an SSIS Project Deployment model outside of SSDT
SessionID: 10522
Fast and Flexible with Better Database Design
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Bill Lescher
Title: Fast and Flexible with Better Database Design
Abstract:
SessionID: 10744
How to Tune Queries
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Brent Ozar
Title: How to Tune Queries
Abstract:
You’re in a dark room with an ugly query. What do you do next? Microsoft Certified Master Brent Ozar shares his time-tested method of tuning queries starting with simplifying, analyzing the execution plan, making index tweaks, and measuring improvements with statistics. You’ll learn a repeatable process you can use to make queries go faster.
SessionID: 10769
Database Unit Testing
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Brian Beswick
Title: Database Unit Testing
Abstract:
SessionID: 11684
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Chuck Heinzelman
Abstract:
SessionID: 12056
SQL Server 2014 Buffer Pool Extension
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Chirag Shah
Title: SQL Server 2014 Buffer Pool Extension
Abstract:
SQL Server 2014 Buffer Pool Extension to SSD.
We will explore this new feature
a) When it is make sense to use it
b) Common misconception about this feature
c) Demo!
SessionID: 12505
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: David Klee
Abstract:
SessionID: 13067
Delivering Self-Service BI with Power
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Dan English
Title: Delivering Self-Service BI with Power
Abstract:
In this session, we will discuss the enhancements and new features that are provided with Excel 2013 as Microsoft continues its roadmap with self-service BI. First we will go over the changes that have been made in Excel 2013, covering the new features. From there we will show how PowerPivot models can be used to integrate and load data to be used for analysis. Lastly, we will look at using Power View inside Excel to provide self-service reporting capabilities that are highly interactive.
SessionID: 13306
DBA 911 - Database Corruption
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: David Maxwell
Title: DBA 911 - Database Corruption
Abstract:
SessionID: 14643
You're the DBA. Now What?
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Gill Rowley
Title: You're the DBA. Now What?
Abstract:
Are you an accidental DBA trying to find your way through your new role? Are you an experienced DBA moving to a new position, team, or major application? This presentation is for you! In this presentation, we will review best practices for what to do when you're a brand new DBA. You will learn what to look for when you walk into a new environment, as well as pitfalls to avoid.
SessionID: 15554
Contained Databases: What, Why and Where.
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Jim Dorame
Title: Contained Databases: What, Why and Where.
Abstract:
In SQL Server 2012, Microsoft added the new feature "contained databases".
Database movement with out the orphans! Developers working independent of an instance! Delegate some database administration
with out granting SA! Sound to good to be true?
Come learn how these and other elements of a "contained database", can impact your database life.
SessionID: 15724
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Janis Griffin
Abstract:
SQL Server query tuning is often more art than science and it can quickly eat up a lot of DBA and/or Developer time. This presentation will outline a method for determining the best approach for tuning queries by utilizing response time analysis. Regardless of the complexity of the statement, this quick, systematic approach will lead you down the correct tuning path.
SessionID: 15725
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Janis Griffin
Abstract:
SessionID: 15795
Maintenance and Backups: Intro to Ola Hallengren
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Jason Carter
Title: Maintenance and Backups: Intro to Ola Hallengren
Abstract:
This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you're using Maintenance plans, you're started in the right direction, but Ola's solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.
SessionID: 15968
Recognizing the Parallel Data Warehouse (PDW) Workload
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Jason Strate
Title: Recognizing the Parallel Data Warehouse (PDW) Workload
Abstract:
SessionID: 16637
SSMS: More Than Meets The Eye
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Jes Schultz
Title: SSMS: More Than Meets The Eye
Abstract:
SessionID: 17069
Solving Complex Problems with Extended Events
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Jonathan Kehayias
Title: Solving Complex Problems with Extended Events
Abstract:
New to SQL Server 2008, Extended Events provide a refreshingly new method of looking at what occurs inside of SQL Server. This session will show you how to leverage Extended Events to solve complex problems by identifying the root cause faster than other methods of data collection provide.
SessionID: 17125
Practical SQL Server Cardinality Estimation
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Joe Sack
Title: Practical SQL Server Cardinality Estimation
Abstract:
SessionID: 17256
Social Networking Is Alive!!!
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: John Morehouse
Title: Social Networking Is Alive!!!
Abstract:
SessionID: 17546
An Introduction to FileTables
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: John Pertell
Title: An Introduction to FileTables
Abstract:
With the release of SQL Server 2012 Microsoft introduced FileTables, a better way to store large objects inside a database. With FileTables you get the advantage of the security and transactional consistency of a database AND improved file streaming from the OS. In this session I'll show you how easy it is to set up and use FileTables, as well as improved methods of searching document keywords with FullText and Semantic searches.
SessionID: 17848
Hekaton Data: A Whole New World
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Kalen Delaney
Title: Hekaton Data: A Whole New World
Abstract:
SQL Server 2014's In-Memory OLTP stores your data and indexes in a whole new way. In this session we'll take a look at way SQL Server 2014 In-Memory Database keeps track of your data with two new kinds of indexes, and why your data storage is so much more efficient.
SessionID: 18390
Implement a Dynamic Table Partitioning Solution
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 2
Speaker: Kirby Richter
Title: Implement a Dynamic Table Partitioning Solution
Abstract:
Have a large or potentially large database that you would like to partition? Manually implementing partitioning and the corresponding maintenance can be a lot of work, especially if you have many tables. In this presentation we look at how you would implement a partitioning solution dynamically for all tables with the designated partition column. We set it up to keep a FIXED number of file groups. The partition maintenance will recycle the file groups over time as partitions are dropped and created. We do as much as possible through dynamic scripting. This solution can easily be used for archiving but in this example we are simply keeping the most current 6 months of data and dropping the rest. Assumes you have a basic understanding of SQL Server table partitioning.
SessionID: 18851
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Ken Stuber
Abstract:
SessionID: 18949
Building Hadoop Clusters on Azure
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Lara Rubbelke
Title: Building Hadoop Clusters on Azure
Abstract:
SessionID: 19507
Using DAX in SSMS and C#
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Marc Temkin
Title: Using DAX in SSMS and C#
Abstract:
While the Tabular Model provides great self-service features with Excel and Power View many BI needs exceed these solutions. Using the DAX language within SSMS provides more flexibility and power. Incorporating these statements into a solution, such as in C#, can provide for better delivery of complicated BI requests that users cannot complete on their own. This presentation will give you a start on creating DAX statements and using those statements within a programming language.
SessionID: 19652
DANGER: The Art and Science of Presenting
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Mark Vaillancourt
Title: DANGER: The Art and Science of Presenting
Abstract:
Is there a great difference in the brain chemistry of someone fleeing a hungry mountain lion and someone presenting to a group of colleagues in a corporate board room? The answer is: NO. Over the past decade, a lot has been learned about the chemistry of the brain and why humans react the way we do to events in our environment. The concept of EQ (Emotional Intelligence) is a compelling and growing concept that applies this knowledge in a set of learnable, improvable skills for leading human beings. While EQ is often applied to corporate leadership, the parallels to presenting are fantastic. This session will explain the basics of EQ and demonstrate how you can apply it to make your presentations better in the following areas: * Crafting better slide decks * Preparing yourself for presenting * Delivering your content * Dealing with the unexpected Understanding and practicing the concepts of EQ can make your presentations a better experience for everyone in the room--including you.
SessionID: 20071
PowerShell 101
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Merrill Aldrich
Title: PowerShell 101
Abstract:
If you haven't dug in to PowerShell at this point, you're missing out on some amazing, powerful, practical stuff that could save you time every day. PowerShell does have a learning curve at the outset, especially for those not already familiar with OO concepts or programming in a language like C#, so this introductory session will go through the very basics of PowerShell syntax. If that collection of pipes and hyphens and curly braces seems to be written in some incomprehensible foreign language, this session is for you. At the end of the session you should have a grasp of how and why a PowerShell script does what it does, and the confidence to dig in deeper and begin using POSH scripts in your own work.
SessionID: 21132
Extending SQL Server with Advanced Analytics and R
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Michael Schulte
Title: Extending SQL Server with Advanced Analytics and R
Abstract:
SessionID: 21151
SQL 2012 and 2014 AlwaysOn Configuration Deep Dive
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Michael Steineke
Title: SQL 2012 and 2014 AlwaysOn Configuration Deep Dive
Abstract:
Brief overview of AlwaysOn features, then dive into what you need to consider when implementing these new features. This session will be interactive, with demos and systems refer to. Bring ideas and questions on how to make this work in the real world. We will discuss the entire infrastructure needed to support DR and HA, and why you need to have a very good understanding of AD to have a successful implementation. We may even break out a white board!
SessionID: 21172
Resistance is Futile: What You Need To Know About Big Data
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 1
Speaker: Michelle Ufford
Title: Resistance is Futile: What You Need To Know About Big Data
Abstract:
The data community is all abuzz about Big Data, and for good reason. Much like Business Intelligence before it, we're rapidly approaching the point where all data professionals should have at least a cursory understanding of what Big Data is and how it fits into an organization. To that end, this presentation will provide an overview of what Big Data is, discuss some common use cases for Big Data across a variety of industry verticals, and explore some common architectures for integrating relational and analytical data with Big Data. We'll conclude with QA and an overview of resources for learning more.
SessionID: 22398
Database Snapshots - Making Your Job Easier
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 3
Speaker: Paul Timmerman
Title: Database Snapshots - Making Your Job Easier
Abstract:
Want to off load some of that reporting workload, make an emergency rollback during a production upgrade faster, or make managing your test databases easier? If any of these appeal to you, then you should be familiar with database snapshots within SQL Server. Available since SQL Server 2005, use of this feature can make your life a lot easier.We'll spend the first part of this session taking an in depth look at how database snapshots work. We’ll look at what exactly is happening behind the scenes when you create a snapshot and when you query a snapshot. Once we've covered the basics, we'll spend the rest of our time analyzing and discussing a number of real world use cases where snapshots can be very beneficial and save you a great deal of time.
SessionID: 22646
Getting Started with Hekaton (In-Memory OLTP)
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Brian Davis
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract:
SessionID: 24303
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Luke Jian
Abstract:
SessionID: 24416
How Skyline Does Innovative BI
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Scott Hietpas
Title: How Skyline Does Innovative BI
Abstract:
SessionID: 24539
Unstructured Data in SQL Server
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Steve Jones
Title: Unstructured Data in SQL Server
Abstract:
A look at the Filestream and Filetable features in SQL Server that can allow you to handle unstructured data inside your SQL Server database.
SessionID: 24875
Integrate SQL Server with hadoop
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 5
Speaker: Pat Wright
Title: Integrate SQL Server with hadoop
Abstract:
SessionID: 24882
Every Byte Counts: Why Your Datatype Choices Matter
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Andy Yun
Title: Every Byte Counts: Why Your Datatype Choices Matter
Abstract:
SessionID: 24958
Forward the Federations
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: MIKE DONNELLY
Title: Forward the Federations
Abstract:
If you are working with Windows Azure SQL Database (WASD) then you know that the way to scale large data sets is to use federations. If you were using SSIS to move data into a federated database you know how challenging this can be. This year Microsoft released a new SSIS component that handles a lot of the federated headache. I'll give the steps you need to set up federations in your WASD database and how to use SSIS to fill the tables with data.
SessionID: 26042
How do I create an automated ETL test suite ??
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 6
Speaker: Terry Bunio
Title: How do I create an automated ETL test suite ??
Abstract:
We will review how the automated test suite is a data driven approach by showing how the tests self-generate based upon the data in the Information-Model schema in SQL Server and 4 slender custom tables that define the field data mapping between the source and target.
The last half of the session will be a demonstration of the tests to illustrate how they execute. To do this we will quickly review the stored procedure code that generates the tests.
SessionID: 26064
Upgrading and Migrating SQL Server with limited downtime
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 7
Speaker: Ted Krueger
Title: Upgrading and Migrating SQL Server with limited downtime
Abstract:
SessionID: 26071
Keynote
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 8
Speaker: Ted Krueger
Title: Keynote
Abstract:
SessionID: 27060
10 Ways To Abuse T-SQL
Event Date: 29-03-2014 - Session time: 00:00:00 - Track: Track 4
Speaker: Tracy McKibben
Title: 10 Ways To Abuse T-SQL
Abstract:
Learn 10 common T-SQL mistakes and how to avoid them. Procedural coding, misuse of user-defined functions, and non-SARGable filters are just some of the topics we'll cover.