Nr: 241
SQLSaturday #241 - Cleveland 2014
SessionID: 10038
Automate Your ETL Infrastructure with SSIS and PowerShell
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Auditorium
Speaker: Allen White
Title: Automate Your ETL Infrastructure with SSIS and PowerShell
Abstract:
Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it's easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we'll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.
SessionID: 10246
Be Friendly to SQL Server with TSQL Best Practices
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Auditorium
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: 10668
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 6
Speaker: Brandon Leach
Abstract:
In this introductory session we'll delve into the basics of the resource governor feature in SQL Server. We'll look at the types of issues this feature can help resolve. We'll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we'll bring all this together with an example implementation. From there, if time allows, we'll look at best practices and questions to answer to ensure a successful implementation.
SessionID: 11115
BIML--Step by Step
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 1
Speaker: Julie Smith
Title: BIML--Step by Step
Abstract:
SessionID: 11403
SQL Server Transaction Log Internals
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 1
Speaker: Tim Chapman
Title: SQL Server Transaction Log Internals
Abstract:
The transaction log plays the most critical role in any SQL Server database. In this talk I will discuss the importance of transaction log and the roles it plays inside the database engine. We’ll look at how logging and recovery works, the checkpoint process, write-ahead logging, and steps you need to take as a DBA to ensure proper management of the transaction log for a SQL Server database.
SessionID: 11766
SQL Audit - auditing doesn't have to be boring
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 2
Speaker: Colleen Morrow
Title: SQL Audit - auditing doesn't have to be boring
Abstract:
Let's face it, auditing isn't fun. But if you're a DBA, you need to know what's going on in your SQL Server instance. Fortunately, SQL Audit makes it easy. In this session, we'll cover what you can and can't audit using SQL Audit, enhancements in 2012, configuring database and server audits, ways to process output, and ideas for how to implement SQL Audit on a larger scale. Auditing doesn't have to be hard. And with the help of a little custom coding, it can even be fun.
SessionID: 11876
SSIS Olympics
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 6
Speaker: Cory Stevenson
Title: SSIS Olympics
Abstract:
SessionID: 12008
Simplify your infrastructure with Managed Service Accounts
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 6
Speaker: Craig Purnell
Title: Simplify your infrastructure with Managed Service Accounts
Abstract:
We will review what are Managed Service Accounts, and their newer cousin, group Managed Service Accounts (gMSA) and why they are important for SQL Server DBAs. We will then implement a gMSA and explain some of the tips and tricks a DBA should know about in implementing this game changing way to simplify your service account management.
SessionID: 13319
DBA 911 - Database Corruption
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 4
Speaker: David Maxwell
Title: DBA 911 - Database Corruption
Abstract:
SessionID: 13936
Making the Leap from Profiler to Extended Events
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 3
Speaker: Erin Stellato
Title: Making the Leap from Profiler to Extended Events
Abstract:
If you’re like me, you’ve been using SQL Trace and Profiler since you started using SQL Server. They’re like old friends, tried and true. You know how they work, you know what you can capture, you know how to find the data you need. But now you’ve been told that your good friends have been deprecated in SQL Server 2012, and you need to become best friends with Extended Events. What is THAT all about? It’s ok. Really. In this session we’ll look at Profiler and Extended Events side by side to see how easy it is to transition to Extended Events. We’ll step through real world examples using Extended Events to do what you’re used to doing with Trace, and even more. You can find the time learn Extended Events…today.
SessionID: 14739
Statistics and Query Optimization
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 1
Speaker: Grant Fritchey
Title: Statistics and Query Optimization
Abstract:
There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.
SessionID: 14998
Spatial Data: Cooler Than You'd Think!
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 4
Speaker: Hope Foley
Title: Spatial Data: Cooler Than You'd Think!
Abstract:
Spatial data has been around since 2008 but it should fire it's PR person. It's too bad that spatial data gets no love, it's actually something that pretty much all SQL Server shops could use. This session will focus on utilizing these native types to store, analyze, and retrieve spatial data. I will use some real world examples to help get the wheels turning on how you can use it within your organization and show how powerful it can be to see your data visually on a map.
SessionID: 16043
Hierarchies... on Steroids the No RBAR Way
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 6
Speaker: Jeff Moden
Title: Hierarchies... on Steroids the No RBAR Way
Abstract:
Hierarchical data sets are everywhere. If you haven't worked with one yet, you will. If you're already working with them, you know they can be horribly complex, slow performing, difficult to maintain resource hogs that can really take the steam out of any GUI or batch process. This simple but code intensive "black arts" session shows you how to quickly and easily get around all of that using all 3 common hierarchical structures and includes a very high performance method (100,000 nodes in less than 4 seconds and 1 Million nodes in less than a minute) for converting Adjacency Lists to Nested Sets that even a beginner can understand. As a finale`, we'll cover a new "pre-aggregated" Hierarchical table structure that answers most of the questions you'd ask of a Hierarchy. You just have to know that a Tally Table is involved somewhere in this. ;-)
SessionID: 16192
SQL 2012 -- All About HA and DR
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 3
Speaker: Joseph D'Antoni
Title: SQL 2012 -- All About HA and DR
Abstract:
Have you heard about all of the new Availability Group features in SQL 2012? Thinking about implementing a DR solution, but don't know where to start? In this session we will walk through the process of creating a disaster recovery plan for your organization, all of the HA and DR options within SQL Server (even the ones that aren't in Enterprise Edition), and finally a demonstration of the new Availability Groups feature in SQL Server 2012 and see them in practice
SessionID: 16193
In-Memory Columnstore Indexes--Make Your Data Warehouse Fly
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 3
Speaker: Joseph D'Antoni
Title: In-Memory Columnstore Indexes--Make Your Data Warehouse Fly
Abstract:
SessionID: 16275
A Tour of Power BI: Pivot, View, Query, and Map
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 5
Speaker: Jeff Mlakar
Title: A Tour of Power BI: Pivot, View, Query, and Map
Abstract:
In this session, we’ll show you how you can expose your reportable data in the cloud and use Microsoft’s Power BI in different ways to empower your business users to Self-Service BI. Equal demo time will be given to all 4 of Power BI’s pillars: Power Pivot, Power View, Power Query, and Power Map.
SessionID: 18064
Discover, Document, Diagnose Your Servers on Your Coffee Break
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Auditorium
Speaker: Kendal Van Dyke
Title: Discover, Document, Diagnose Your Servers on Your Coffee Break
Abstract:
Documentation is the bane of every DBA's existence. We all know we should do it but it's time consuming; by the time you're finally done it's probably out of date. Throw in the new servers you just found out about last week and keeping documentation up to date can turn into a full time job. And with everything we have to do in our day, who has time for that?
You need a way to work smarter, not harder, and automate your documentation. It can be done, and in this session you'll learn how to discover all the SQL Servers on your network, document their configuration from top to bottom (including OS details), and diagnose common problems before they turn into big headaches - all while you're on a coffee break. You'll look like a rock star without writing a line of code on your own or having to ask management to sign a check.
Attend this session and walk away with everything you need to generate documentation for your entire SQL Server environment on your first day back at the office
SessionID: 18065
Building Your Own SQL Server Virtual Playground
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 5
Speaker: Kendal Van Dyke
Title: Building Your Own SQL Server Virtual Playground
Abstract:
As the number of SQL Server versions and features grow over time so does the the difficulty in maintaining a set of tools for working with all of them on your local machine. Add in that some features require multiple physical instances and suddenly a single installation isn't enough. Need to quickly switch between versions and editions of SQL Server? Want to learn how to set up a cluster? Or maybe you want to try out the latest features in SQL 2012...virtualization offers a convenient way to do any or all of these. In this session we'll show you how by covering the fundamentals of desktop virtualization and demonstrating how to set up a virtual playground on your own machine.
SessionID: 18406
Writing Better Queries with T-SQL Window Functions
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 3
Speaker: Kathi Kellenberger
Title: Writing Better Queries with T-SQL Window Functions
Abstract:
SessionID: 18548
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 2
Speaker: Konstantin Melamud
Abstract:
In this presentation, we will identify what indexes are being used by the SQL Optimizer, the different type of index operations that are performed by SQL Server and which operations are generally considered the preferred method of data retrieval. We will discuss how to determine if the indexes used by the Optimizer are optimal, according to best practices, and the exceptions to those cases. Finally, we will cover the relationships between different types of index operations and joins within SQL Server, including how the SQL Optimizer determines which join type it will use, along with the pros and cons of each join operation
SessionID: 19162
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 4
Speaker: Lisa Gardner
Abstract:
SessionID: 19637
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 5
Speaker: Mark Vaillancourt
Abstract:
SessionID: 19638
DANGER: The Art and Science of Presenting
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 5
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: 20767
SQL Server Bingo – Install, Migration Config
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 2
Speaker: Mindy Curnutt
Title: SQL Server Bingo – Install, Migration Config
Abstract:
Get ready to play SQL Buzzword Bingo with the subject matter being SQL Install, Migration Configuration. Are you preparing to move a database from one SQL Server to another? Whether it's your first SQL install, a SQL Server Upgrade or changing from physical to virtual, there is a lot to consider. In some areas of the setup, you get only one chance to "get it right." Come to this session and find out all about the process - and have some fun while you're at it. First one to hit BINGO! will win a copy of the book SQL Server 2012 - Step by Step.
SessionID: 22102
The Evils of Cursors
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 6
Speaker: Paul Hiles
Title: The Evils of Cursors
Abstract:
We have all heard that cursors are evil, but most of the time we are not told why they are evil and how to replace them. The goal of this session is to fix that problem. We will be reviewing a number of types of cursors and explain why they are being used, why are bad and then show better ways to write them. This session will include lots of actual scripts and demos comparing these different examples of cursors and then better ways to rewrite the code to replace the cursor.
SessionID: 22651
Getting Started with Hekaton (In-Memory OLTP)
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 2
Speaker: Brian Davis
Title: Getting Started with Hekaton (In-Memory OLTP)
Abstract:
SessionID: 23858
14 New T-SQL Functions
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 4
Speaker: Sam Nasr
Title: 14 New T-SQL Functions
Abstract:
The 2012 release of SQL Server introduces 14 new functions for developers. This list includes functions for conversion, date/time calculation, enhanced logic, and string manipulation. In this session we’ll cover the ins and outs of these new functions, making you a better T-SQL developer.
SessionID: 24509
The Encryption Primer
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 3
Speaker: Steve Jones
Title: The Encryption Primer
Abstract:
Learn the options for encryption in SQL Server, covering hashing, symmetric keys, asymmetric keys, and encrypted communications.
SessionID: 24510
Branding Yourself for a Dream Job
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 3
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: 24664
Reduce, Reuse, Recycle: Automating Your BI Framework
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Auditorium
Speaker: Stacia Varga
Title: Reduce, Reuse, Recycle: Automating Your BI Framework
Abstract:
Quite frankly, some aspects of building out a business intelligence solution are tedious. As you cycle through iterations of your star schema, you’ll find that even a simple data type change in the data warehouse requires you to make corresponding changes to staging tables, SSIS packages, and SSAS multidimensional or tabular models that take a considerable amount of time to implement. But there’s a better, faster way!In this session, we’ll explore lessons from a project that required implementation of a framework to easily generate BI objects based on reusable patterns. We’ll walk through the decision points in the framework design, review the implementation steps, and see demonstrations of how easily you can make iterative changes to your BI solution’s design by using reusable design patterns. Whether you simply want to accelerate change management or reproduce objects in bulk on demand, this session will give you practical tips for automating these processes.
SessionID: 24665
A Big Data Primer
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 1
Speaker: Stacia Varga
Title: A Big Data Primer
Abstract:
The term "big data" dominates the headlines in technology news these days, but what is the fuss really all about? What are the implications for traditional data warehousing and reporting? What kind of technology and skill sets do you need to successfully implement to a big data strategy? Come to this session for a gentle, business-focused introduction to big data and leave with some inspiration and practical steps for tackling your first big data project.
SessionID: 25138
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Auditorium
Speaker: Thomas LaRock
Abstract:
SessionID: 25139
Database Design: Size DOES Matter
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 1
Speaker: Thomas LaRock
Title: Database Design: Size DOES Matter
Abstract:
SessionID: 25799
Monitoring and Baselines
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 4
Speaker: Steve Hood
Title: Monitoring and Baselines
Abstract:
Covers monitoring OS Perf Counters, Wait Stats, Traces, Blocking, Query Stats, Index Stats, Database Sizes and Table Sizes, all presented in a format of what you should be watching and how it will help you. How to watch them is covered in my blog at SimpleSQLServer.com.
This will give you a great starting point for finding root causes to incidents, trending database growth, and a better way to find the queries in most need of tuning.
SessionID: 25999
45 min to build your first SSRS report
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 5
Speaker: Tamera Clark
Title: 45 min to build your first SSRS report
Abstract:
Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you're a DBA and could use a daily report. Either way, I've got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it's all about the output.
SessionID: 26203
SQL Server 2014 New Features
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 4
Speaker: Kevin Boles
Title: SQL Server 2014 New Features
Abstract:
There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. We will take a look at some of the new functionality via demos as well.
SessionID: 26715
Know Backups and Know Recovery
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 2
Speaker: Tim Radney
Title: Know Backups and Know Recovery
Abstract:
SessionID: 26716
You Inherited a Database, Now What?
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Auditorium
Speaker: Tim Radney
Title: You Inherited a Database, Now What?
Abstract:
SessionID: 27808
Navigating the Options for Data Redundancy
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 5
Speaker: Wendy Pastrick
Title: Navigating the Options for Data Redundancy
Abstract:
SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.
SessionID: 8975
XML Without Xanax: How to Handle XML in SQL Server
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 2
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: 9079
Manageable SSAS Deployment Strategies
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 6
Speaker: Kerry Tyler
Title: Manageable SSAS Deployment Strategies
Abstract:
If you've answered "yes" to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.
SessionID: 9771
Code-Less Securing of SQL Server
Event Date: 08-02-2014 - Session time: 00:00:00 - Track: Training 1
Speaker: Argenis Fernandez
Title: Code-Less Securing of SQL Server
Abstract:
Learn from a Microsoft Certified Master how to secure your SQL Server infrastructure and your Windows installations to enhance resiliency and minimize exposure to attacks—all without touching any of your code!