Nr: 357
SQLSaturday #357 - Cleveland 2015
SessionID: 10270
PoShDBA: Practical PowerShell for the DBA
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4
Speaker: Ben Miller
Title: PoShDBA: Practical PowerShell for the DBA
Abstract:
This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some SQLPSX to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour.
SessionID: 11129
Swimming in the Deep End with SSIS
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1
Speaker: Julie Smith
Title: Swimming in the Deep End with SSIS
Abstract:
Many developers of all sorts get thrown into the deep end of the ETL pool without water wings with SSIS. While the dataflow and basic connections are easier to grok, the true complexity of SSIS often lies hidden in configurations, expressions, and parent child packages. This session is a primer on these lesser known, but frightfully important elements.
SessionID: 11677
SSAS, MD.: Tuning your cubes for fast processing and faster queries
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5
Speaker: Chris Schmidt
Title: SSAS, MD.: Tuning your cubes for fast processing and faster queries
Abstract:
SessionID: 11782
Enterprise-level auditing on a Standard Edition budget
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4
Speaker: Colleen Morrow
Title: Enterprise-level auditing on a Standard Edition budget
Abstract:
SessionID: 12041
Hardening SQL Server
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4
Speaker: Craig Purnell
Title: Hardening SQL Server
Abstract:
SessionID: 13340
The usual SUSPECTs: When good databases go bad.
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4
Speaker: David Maxwell
Title: The usual SUSPECTs: When good databases go bad.
Abstract:
You just restarted SQL Server, but some of your databases aren't coming online. Maybe
you see a database marked SUSPECT, or RECOVERY PENDING. What do you do? In this session
we'll cover the various states that a database can be in, how they get into those states, and
learn the proper techniques to bring your data safely back online.
SessionID: 14199
APPLY Yourself
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium
Speaker: Kevin Feasel
Title: APPLY Yourself
Abstract:
SessionID: 15002
Spatial Data - Looking Outside the Map
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5
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: 15744
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2
Speaker: Janis Griffin
Abstract:
SessionID: 15774
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3
Speaker: Jim Arko
Abstract:
SessionID: 16065
Partitioning System for "WORM" Tables - Part 1 - The Theory and the Problems
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2
Speaker: Jeff Moden
Title: Partitioning System for "WORM" Tables - Part 1 - The Theory and the Problems
Abstract:
This isn't your typical talk on "partitioning". This is a deep dive into all the problems that you'll run into when partitioning new or existing "Write Once, Read Many" tables, such as large Audit Tables, and how to code around them. You'll also learn the methods to support three of the best reasons for partitioning such monster tables... MUCH shorter nightly index maintenance, MUCH shorter and smaller backups, and MUCH shorter "Get back in business" piecemeal restores. We'll also learn how to do the "impossible"... compact a File Group (one per partition) so that there's virtually no unused space in the underlying file. After all, we don't want to set any "free" disk-space to "Read Only". Don't let the "Advanced" rating of this session scare you away. Anyone with a decent handle on T-SQL (or wants one) will be able to understand this session because "all will be explained" and there will be oodles of well-documented code to back up the explanations.
SessionID: 16066
Partitioning System for "WORM" Tables - Part 2 - Deep Dive on the Code
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2
Speaker: Jeff Moden
Title: Partitioning System for "WORM" Tables - Part 2 - Deep Dive on the Code
Abstract:
This isn't your typical talk on "partitioning". This is a deep dive on the code for the problems and desired results for partitioning things like the "Audit" Table covered in Part 1. It's strongly recommended that you attend Part 1 where the groundwork for this session has been laid out. In this session, we'll build a 4 million-row test table and do the initial partitioning. We'll follow that up with the monthly process to re-index and compress the latest full partition automatically every month and do a deep dive on a view that makes monitoring partitions easy. This code helped me reduce backups to 1/60th the amount of time that they used to take. There's a ton of ancillary learning in the code, as well. Don't let the "advanced" rating of this session scare you away because it's written for all levels to understand.
SessionID: 16234
Who Moved My Tuple--Columnstore Indexes in SQL Server 2014.
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2
Speaker: Joseph D'Antoni
Title: Who Moved My Tuple--Columnstore Indexes in SQL Server 2014.
Abstract:
Data Warehouse workloads can be very large and taxing on your database server. With the modern demands of real-time analytics against growing volumes of data this challenge continues. When columnstore indexes and batch mode query processing were introduced in SQL Server 2012 were a performance game changer. In the 2012 implementation of columnstore, direct updating and inserting of data was not supported and other restrictions, such as data types limited the use of the feature. SQL 2014 removes those limitations—you can use a columnstore index as a clustered index, and more importantly directly perform DML against the index. Also, more query operators support batch mode, which means more of your queries can see performance benefits. You will understand the changes for 2014—and how having updateable columnstore indexes may cause changes to your process design. You will see the power of columnstore indexes in analytics, their limits, and how to include them into your system design.
SessionID: 16279
Working with BimlScript to ease and automate your SSIS development
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1
Speaker: Jeff Mlakar
Title: Working with BimlScript to ease and automate your SSIS development
Abstract:
SessionID: 17238
Working with Data Types
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5
Speaker: John Deardurff
Title: Working with Data Types
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: 18080
Transactional Replication: Tuning and Troubleshooting
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4
Speaker: Kendal Van Dyke
Title: Transactional Replication: Tuning and Troubleshooting
Abstract:
At some point in every DBA's career they'll be probably be asked to work with transactional replication but most DBAs don't look under the covers once they're done walking through the setup wizards. In this session we'll take a deeper look at setting up, monitoring, and calibrating transactional publications plus share some tricks and tips gleaned from years of experience working with high volume, multiple datacenter topologies.
Session Goals:
• Learn how to baseline performance metrics by gleaning information from the distribution database
• Show how to tune replication agent performance with agent profiles
• Demonstrate advanced troubleshooting techniques to apply when problems occur
SessionID: 18580
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2
Speaker: Konstantin Melamud
Abstract:
SessionID: 18875
Think like SSIS and Build a package
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1
Speaker: Ravi Kumar
Title: Think like SSIS and Build a package
Abstract:
You wouldn't drive to a new place without directions? Then why build a SSIS package without having a road map on how to build it. Learn how to think like SSIS, make your ETL life easy, and convert a Process into an SSIS Package. If time allows, we will also cover SSIS Package Configurations, security and deployment. Expect to participate actively in the class.
SessionID: 19849
Building dynamic SSIS packages for more flexibility
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1
Speaker: Matt Nelson
Title: Building dynamic SSIS packages for more flexibility
Abstract:
After building a handful of SSIS packages, you probably want to have more flexibility to make the package execution more dynamic. In this session, we will learn how to use variables, expressions, and loops to do things like: extract data to a file with today's date in the file name, load all files in a directory at the same time, and loop through a set of servers to gather data. For this session, you should already be familiar with how to create SSIS packages to load data from flat files and extract data to flat files.
SessionID: 20047
Before You Optimize: Understanding Execution Plans
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3
Speaker: Tim Corey
Title: Before You Optimize: Understanding Execution Plans
Abstract:
You know what your query does, but do you know how it does it? Do you know what type of resources your query uses? Come to this session to find the answers to these questions and more as we walk through reading execution plans. We will see how SQL breaks down the execution of your query and what each step tells us about the overall query. If you are newer to Microsoft SQL or you just don’t feel totally comfortable with reading execution plans, this session is for you.
SessionID: 20236
Database Virtualization and Drinking out of the Fire Hose
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3
Speaker: Michael Corey
Title: Database Virtualization and Drinking out of the Fire Hose
Abstract:
A database by its very nature is one of the most resource intensive applications you will ever virtualize. This is even more difficult to do correctly in the context of a virtualized infrastructure that is a shared resource environment. We will look at every possible dynamic to virtualizing a database from Design, Storage, Memory and Network considerations. This presentation is based upon material given at VMworld from a presentation that was in the top 10 out of all presentation given.
SessionID: 20779
The Ins and Outs of SQL Indexes
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3
Speaker: Mindy Curnutt
Title: The Ins and Outs of SQL Indexes
Abstract:
SessionID: 20841
Drawing Conclusions
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5
Speaker: Michael Swart
Title: Drawing Conclusions
Abstract:
A fun and sometimes irreverent look a the SQL Server and Data world through illustrations.
I often blog about my DB Developer life in a very visual way. I explore a subset of useful topics such as Normal Form, Deadlocks, the Query Optimizer.
SessionID: 20966
Handling catch all or sometimes queries
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium
Speaker: Michael John
Title: Handling catch all or sometimes queries
Abstract:
This session will provide a number of different ways to handle "sometimes" queries, and provide techniques to make these perform faster.
Michael John is a Senior DBA with almost 20 years experience working and solving problems for both Fortune 100 companies and smaller firms. As a frequent contributor to many of the community newsgroups, and expert at answering the 2:00 AM problem phone calls, Michael has seen nearly every issue as a DBA in his career.
SessionID: 21145
What Every DBA Needs To Know About Storage For SQL Server
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3
Speaker: Matt Slocum
Title: What Every DBA Needs To Know About Storage For SQL Server
Abstract:
Do you have issues communicating your needs to your Storage/SAN Administrator? Do they seem to speak a different language when it comes to determining and providing your SQL Server storage needs? In this session we'll review storage technologies so that you can communicate effectively with your Storage/SAN Administrator as well as methods of monitoring your storage to ensure that your needs are met.
In this session we will discuss RAID types, Local/Direct Attached Storage vs SAN Storage, and Flash Storage (including how it fits into multiple storage models). We'll also review methods for monitoring and testing your storage performance. With the information gathered in this session, you'll be able to have thorough, informed discussions with your Storage Administrator as well as being able to provide solid metrics to confirm storage performance.
SessionID: 22082
Common Coding Mistakes and how to Mitigate them
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium
Speaker: William Wolf
Title: Common Coding Mistakes and how to Mitigate them
Abstract:
There are several programming design patterns that work great in object orientated code that doesn’t scale well inside of SQL Server. In this session we will focus some of these patterns and show you how to make them scale in the database engine. We will touch on Scalar-Value functions, Union, CTE, RBAR and more.
SessionID: 22122
Interactive Data Visualizations in Power View
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5
Speaker: Phillip Labry
Title: Interactive Data Visualizations in Power View
Abstract:
SessionID: 25727
Fixing Page Life Expectancy
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 2
Speaker: Steve Hood
Title: Fixing Page Life Expectancy
Abstract:
Starting with what Page Life Expectancy really means to query, server, and disk performance, we’ll get a firm understanding of what this counter means to you. After that we can start talking about if and how you want to raise it. It’s important to know that this is just a counter and there are situations where you don’t care about it nearly as much as you’d expect. It’s also important to know what effect a drop in PLE mid-day really means beyond query performance, including a possible impact on other, unrelated servers.
SessionID: 27566
DBA Monitoring and Maintenance Fundamentals
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 3
Speaker: Warren Sifre
Title: DBA Monitoring and Maintenance Fundamentals
Abstract:
The key to becoming a great DBA is time. The best way to regain some time is by spending less time doing the daily mundane work. Let this mundane effort work autonomously. We will introduce the basics in monitoring and maintenance. The how and why certain things should be done at a minimum and what things can be done to help improve the quality of life in larger dynamic environments.
SessionID: 27740
Table Vars Temp Tables - What you NEED to Know!
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium
Speaker: Wayne Sheffield
Title: Table Vars 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 represent 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: 27826
SQL Server in Azure
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 4
Speaker: Wendy Pastrick
Title: SQL Server in Azure
Abstract:
SessionID: 8833
Database Deployment with Release Management for Visual Studio
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1
Speaker: Aaron King
Title: Database Deployment with Release Management for Visual Studio
Abstract:
SessionID: 8927
Top 5 Ways to Improve Your triggers
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium
Speaker: Aaron Bertrand
Title: Top 5 Ways to Improve Your triggers
Abstract:
SessionID: 8950
T-SQL Tips Tricks
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Auditorium
Speaker: Aaron Cutshall
Title: T-SQL Tips Tricks
Abstract:
SessionID: 9003
XML Without Xanax: How to Handle XML in SQL Server
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 5
Speaker: Adam Belebczuk
Title: XML Without Xanax: How to Handle XML in SQL Server
Abstract:
Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!
We'll start with reasons why having XML in SQL Server might be a good thing, then we'll face our fears and turn tabular data into XML, and finally we'll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.
If you survive this session, you'll have faced your fears about XML in SQL Server, you'll have a solid understanding of creating XML from tabular data, and you'll know how to use xQuery to parse XML.
SessionID: 9968
The Data Warehouse is Dead! Long Live the Data Warehouse!
Event Date: 07-02-2015 - Session time: 00:00:00 - Track: Training 1
Speaker: Audrey Hammonds
Title: The Data Warehouse is Dead! Long Live the Data Warehouse!
Abstract:
Okay, the Data Warehouse isn't really dead. But, it's time to think past your favorite textbook and begin looking at practical solutions that fit the schedule, budget, and team you're working with. In this session, we'll discuss design options, implementation considerations, and lessons gained from the many mistakes the presenter has made over the years. This is a highly interactive session, so bring your ideas, opinions, and experiences.